2022
...
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") |