2022

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

The Map Component

This section provides details as to how to operate the Map component of the application. Follow the instructions and the screen shots provided below.

1. Open an existing process that you have already created (see section 3.1 on how to create a process)

2. Right-click on the created process in the Navigation section of the Process Builder and select 'Open'.

3. Next select the rectangular process in the process map labeled "execute" (this rectangular box is called an "action"), right click on the selected box and click on "open dataflow" in the menu.

4. At this point, a process map with the action "Map" should be visible on the canvas as illustrated in the screen shot below:

5. Right click on the action "Map" and select "properties"
6. Next you will find that you can edit the map file and sequence in the properties tab.
7. The sequence is useful when you have more than one map in the process so that you can specify as to which map should execute first. The maps execute in the ascending order as specified. As soon as you drag and drop the map on the canvas it asks for a name to be specified for it. Providing the name is necessary for each action.

Note: If the sequence number is not present for the map then please enter it manually if you need to do so.

8. Click Delete to delete the specific Map component.
9. Click Close to close the Map window.

Mapping Functions:

Function

Description

VALUE(“FIELDNAME”)

This function is used to set the value of a field from the Target Adapter to Source Adapter.Eg: VALUE(“FirstName”) in Salesforce Adapter on Contact Object

AND(Boolean,Boolean)

This function returns Boolean value for the Boolean parameters passed in.Eg: AND(VALUE(“FirstName”)==VALUE(“LASTNAME”), VALUE(“ID”)==”123”)

NUMBER(String)

This function return the integer value of the string paratmeter passes in, if null or empty then it would return 0.

CLEAN(String)

 

CODE(String)

This function returns the first char value of the string.

DATE

 

DOLLAR(Double)

Not implemented yet

EXACT(String, String)

This function returns the Boolean value of the comparison of 2 parameters.

FIND(String, String)

This function returns the int value of the text identified in the search text.First Parameter: Text to find Second Parameter: Text in which it has to find.

FIND(String, String, Integer)

This function returns the int value of the text identified in the search text from the specified start index.First Parameter: Text to find Second Parameter: Text in which it has to find. Third Parameter: Start the find from what column or index.

FORMAT(value, format)

Returns the value converted to the format specified.

GETSOURCEXML2STRING

This function returns the string formatted XML Structure of the row.

IF(Boolean,trueStringVal,falseStringVal)

This function returns trueStringVal if the Boolean condition

ISEMPTY (String)

This function returns Boolean value of whether the parameter is null or empty.

LEFT(String)

Returns the first left char of the parameter.

LEFT(String, Int)

Returns the specified number of chars from left of the parameters.

LEN (String)

This function returns the length of the parameter passed in.

LINK


LOWER(String)

Returns the lowercase value

LPAD(stringText, stringValue, intSize)

Left Padding of the String with the value passed in for a specified size.

LSPLIT(stringText,stringSplitter)

Returns the Split value of the string to the splitter specified.

MAP

 

MID(String, Int, Int)

Returns the chars of the String between the 2 integer parameters passed.

OR(Boolean,Boolean)

Returns the Boolean value of the condition of 2 parameters passed in.

PARENTVALUE

This function gets the value of the column which is in the higher level of the XML Structure.

REPLACE(String, Int, Int, String)

Returns the value with replacing the newText in oldText for specified start index and number of chars.First Param: Old Text Second Param: Start Number Third Param: Number of Chars Fourth Param: newText

REPT(String, Int)

Returns the value with repeated string value for number of times specified.

RIGHT(String)

Returns the last char of the string value passed

RIGHT(String, Int)

Returns the number of chars specified from right of the string.

SEARCH(findText, withinText)

Returns int value of Boolean if the findText exists in withinText

SEARCH(findText, withinText,startNum)

Returns the int value of Boolean, if the findText exists in withinText from the startNum of withinText.

SESSION_PUT(KEY, VALUE)

This function stores the key/value pair in the session of the process. This can be access from any mapping within the same process.

SESSION_GET(KEY)

This function returns the value of the key passed in from the Process Definition Session.

SETATTR(colName,attName,attValue,colVal)

This function sets the column with an attribute of name and value as specified. The column value would be set as specified in the colVal.Eg: SETATTR(“Name”,”priceBook”,”Standard PriceBook”,VALUE(“Name”))

TODAY

Returns Today’s Date

TRIM(String)

Returns the trimmed value of the string passed.

UNIQUEFIELD(stringColName,stringAttValue,stringColValue)

Sets the column with attribute of the unique field and sets the column value.This function returns the value of the key passed in from the Process Definition Session.

UPPER(String)

Returns the String converted to UpperCase

LINK(stringColName,stringQuery,stringFieldName,stringRefValue,stringObjectName)

Links the foreign object to the column for setting up the relation.Eg: LINK("OpportunityId","Select Id,Name from Opportunity","Name","Invoice "+PARENTVALUE("RefNumber"),"Opportunity")
In the above example, we are setting the OpportunityId column with the value that we get from the Query. The column for filtering from the query is passed as FieldName and fieldValue along with the ObjectName)

  • No labels