2022
Function | Description | Examples |
ADDXML(Arg 0) |
ADDXML(Arg 0, Arg 1) |
AND | This function returns Boolean value (True or False) for Boolean parameters passed in. | Mapping: <TargetField> = AND(Boolean, Boolean) |
ASNUMBER(Arg 0) |
CLEAN | It removes all non printable characters from String. | Mapping: TargetField = CLEAN("String VALUE") |
CONCATENATE(Arg 0) |
CODE | This function returns the first character of the string passed to it. | Mapping: <TargetField> = CODE("String VALUE") |
DATE | This function returns the formatted Date or Date Time for specified string as per the format specified in function. | Mapping: <TargetField> = DATE(VALUE("SourceField"), "format string") |
DOLLAR(Arg 0) |
EQUALS(Arg 0, Arg1) |
ERROR() | This function can be used to print out error messages to your desired field or column as it returns error messages from the stack trace on integration failure. | Mapping: <TargetField> = ERROR() |
EXACT | This function returns the Boolean value of the comparison of 2 string parameters. | Mapping: <TargetField> = EXACT(VALUE("SourceField1"), VALUE("SourceField2")) |
FIND | This function returns the place value of the first string parameter in the second string parameter. | Mapping: <TargetField> = Find(VALUE("SourceField1"), VALUE("SourceField2")) |
FIND | This function returns the place value of the text identified in the search text from the specified start index. | Mapping: TargetField = FIND(VALUE("SourceField1"), VALUE("SourceField2"), "Start Position") |
FORMAT | Returns the value converted to the format specified. | Mapping: TargetField = FORMAT ("SourceField1", "Format String") |
FIXED (Arg 0, Arg1) |
FIXED (Arg 0, Arg1, Arg2) |
GETROOTVALUE(Arg 0) |
GETSOURCEXML2STRING() | This function returns the string formatted XML Structure of the row. | Mapping: TargetField = GETSOURCEXML2STRING(VALUE("SourceField1")) |
IF | This function can be used as a normal if-else statement. | Mapping : TargetField = IF(String,Integer,String) |
ISEMPTY | This function returns Boolean value of whether the parameter is null or empty. | Mapping: <TargetField> = ISEMPTY(STRING) |
ISNULL(Arg 0) |
LEFT | Returns the first left char of the parameter. | Mapping: <TargetField> = LEFT(VALUE("SourceField1)) | |
LEFT | Returns the specified number of chars from left of the parameters. | Mapping: <TargetField> = LEFT(VALUE("SourceField1"), NoOfCharacters) | |
LEN | This function returns the length of the parameter passed in. | Mapping: <TargetField> = LEN(String) | |
LINK | Link function is used to update Salesforce (Target) field with a source value based on the source identifier that remains unique across Salesforce (Target) as well as Source (Ex: Quickbooks) application | Example:
|
|
|
| ||
LOOP | This is a DBSync function different than the conventional '=' operator | Example1: Salesforce OppotunityLineItems to InvoiceLineItems |
LOWER | Returns the lowercase value | Mapping: <TargetField> = LOWER(String) |
LPAD | Left Padding of the String with the value passed in for a specified size. | Mapping: <TargetField> = LPAD(VALUE("SourceField1"), "string", Int) |
LSPLIT | Returns the Split value of the string starting from first character to the splitter specified. | Mapping: TargetField = LSPLIT(VALUE("SourceField"), "string") |
MAP(Arg 0, Arg1) |
MEMLOOKUP | This function identifies the value against the key stored in memory table created by MEMTABLE() function. | Mapping: <TargetField> = MEMLOOKUP(StringCacheIdentifier, StringKey) |
MEMLOOKUP (Arg 0, Arg1, Arg2) |
MEMTABLE | This Functions creates a memory table in DBSync for Key Value pair for the Query provided. | MAPPING: <TargetField> = VALUE("SourceField") + MEMTABLE(StringCacheIdentifier, StringQuery) |
MID(Arg0, Arg1, Arg2) |
NUMBER | This function returns integer value of the string passed to it. | MAPPING: <TargetField> = NUMBER("String") |
OR | Returns the Boolean value of the condition of 2 parameters passed in. | MAPPING: <TargetField> = OR(Boolean, Boolean) |
REPLACE | Returns the value with replacing the newText in oldText for specified start index and number of chars. | Mapping: TargetField = REPLACE(VALUE("SourceField1), 1, 5, "replace string") |
RIGHT | Returns the last char of the string value passed. | Mapping: TargetField = RIGHT(String) |
RIGHT | Returns the number of chars specified from right of the string. | Mapping: <TargetField> = RIGHT(VALUE("SourceField1"), NoOfCharacters) |
PARENTVALUE() | This function gets the value of the column which is in the higher level of the XML Structure. |
REPT | Returns the string with repeated string value for number of times specified. | Mapping: <TargetField> = REPT(VALUE("SourceField1"), 2) |
SEARCH | Returns int value of Boolean if the findText exists in withinText | Mapping: <TargetField> = SEARCH(VALUE("SourceField1"), VALUE("SourceField2")) |
SEARCH | Returns the int value of Boolean, if the findText exists in withinText from the startNum of withinText. | Mapping: <TargetField> = SEARCH(VALUE("SourceField1"), VALUE("SourceField2"), "Start Position") |
SESSION_PUT | This function stores the key/value pair in the session of that particular state/workflow which is active. This can be accessd from any mapping within the same active state/workflow. | Mapping: out = SESSION_PUT("KEY","VALUE") |
SESSION_GET | This function returns the value of the key sotred in the session of that particular state / workflow. | Mapping: <TargetField> = SESSION_GET("KEY") |
SETATTR | 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 | Mapping: <TargetField> = TODAY() |
TLOOKUP | Returns the value for the column in the query. In the query only one column can be specified. | Mapping: <TargetField> = TLOOKUP(stringQuery) |
UNIQUEFIELD | Sets the column with the 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 | Returns the Uppercase String value | Mapping: <TargetField> = UPPER(String) |
If the VALUE for FirstName is "Dbsync" the resulting string will be "DBSYNC". | ||
VALUE | This function returns string value of the FieldName. | MAPPING: TargetField = VALUE("SourceField") |