Page History

...

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)

...

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)