Function

Description

Examples

ADDXML(String xml)

This function adds XML structure to the present element. This function is used when the source application doesn't expose their fields in their API then a user can map the field by modifying the XML structure to post back. This will add the XML on the root node of the target XML structure.

Mapping: <TargetField> = { ADDXML("<xml element>" + VALUE("sourcefield") +  "</xml element>");return "";}

Example: Database fields 
Trigger: select id,firstname from contact.

The above query fetches id, firstname from contact table of the database. The table also has a field of "contactaddress" and so query will not populate the "contactaddress" field in the target schema.

Name = {ADDXML("<address>" +VALUE("ContactAddress") + "</address>");return VALUE("Firstname");}

However i can map the source field and the populate the source field data in to contactaddress column of database and this contactaddress field is written to the target application

ADDXML(String xPath, String xml)

This function appends XML structure to the XPath passed. This function is used when the source application doesn't expose their fields through their API then a user can do the mapping for the field and parse the data

Let us take an example of custom field SalesRep__c  on Opportunity in Salesforce.

We have to map this field to SalesRep custom field on QuickBooks online.To map this field, type custom field name(SalesRep) in the target area(QuickBook online) and add below given query in the source field.

Mapping: <TargetField> = { ADDXML("<CustomField><DefinitionId>2</DefinitionId><Name>SalesRep</Name><Type>StringType</Type><StringValue>"+VALUE("SalesRep__c")+"</StringValue></CustomField>");

return "";

}

Where:
<DefinitionId>2</DefinitionId> :Position of custom field in QuickBooks online.

<Name>SalesRep</Name> : The custom field name in QuickBooks online.

  <StringValue>"+VALUE("SalesRep__c")+"</StringValue> : The custom field in Salesforce.

AND (boolean booleanExp1, boolean booleanExp2)

Mapping: <TargetField> = AND(booleanExp1,booleanExp2) 

Example : <TargetField> = AND(VALUE("Stage")=="Closed Won", VALUE("Type")=="Key Account") 

From the above example, The function returns true for all the records which are having "stage" as "Closed Won" and Type as "Key Account".

ASNUMBER(String value)

This function checks if a supplied value is a number and returns the actual number passed; else returns zero.

MAPPING: <TargetField> = ASNUMBER("String")

<TargetField> = ASNUMBER("123")

If the value for the number of employees is null or empty it will return zero. In this example, it will return 123 as a number.

CLEAN(String s1, String s2)

This function removes all non-printable characters from a supplied string value.

Mapping: <TargetField> = CLEAN("String VALUE")

Example: Salesforce object fields
Trigger: select Id, name from account

The above query will select Id and name from the account object of Salesforce. You can use the CLEAN() function to get the first character of the name field and set it to the target field.

<TargetField> = CLEAN (VALUE("Name"))

TODO:THIS IS WRONG - please check

CONCATENATE(String... strings )

This function allows you to join two or more text strings together.

Mapping: <TargetField> = CONCATENATE("String1", "string2", "string3")

Example: passing text values

<TargetField> = CONCATENATE("It's", "raining ", "heavily ", "outside.")

The value returned by the function from the above example is "It's raining heavily outside."

CODE(String s)

This function returns the numeric code of the first character of a supplied text value.

Mapping: <TargetField> = CODE("text value")

Example 2: <TargetField> = CODE("Salesforce")
The above mapping will put 'S' in the target field.

TODO:THIS IS WRONG - please check

Mapping: <TargetField> = DATE("date string")

DATE (String dateString, String inputFormat)

This function reads a date string and returns the date string as per user specified date format.

If user specified date format is not passed then it passes date string as "yyyyMMdd-HHmmssZ".

Mapping: <TargetField> = DATE(VALUE("source field"), "format string")

<TargetField> = DATE(VALUE("lasttransferdate"),"MM-DD-YYYY HH:MM:SS")
The value of lasttransferdate is Mar-12-2010 12:33:21, then the DATE() function will return value as 03-12-2010 12:33:21

This function reads a date string and returns the date string as per user specified date output format.

If the user specified date input format is not passed then it returns date string as "yyyyMMdd-HHmmssZ".

Mapping: <TargetField> = DATE(VALUE("source field"), "source format", "target format string")

<TargetField>= DATE(DATE(VALUE("createddate"),"yyyy-MM-dd hh:mm:ss"),"yyyy-MM-dd'T'HH:mm:ss'Z'")

The value of createddate is 03-12-2010 12:33:21, then the DATE() function will return value as 2010-12-03'T'12:33:21.

DOLLAR(Arg 0)

Not implemented yet

EQUALS(String v1, String v2)

This function compares two given string values and returns true if both the values are exact match otherwise false(case-insensitive).

Mapping: <TargetField> = EQUALS(VALUE("CurrencyISO"),"USD")

This function compares USD in CurrencyISO field for USD value and if found then it returns true; else false.

TODO: Example missing

ERROR()

This function can be used to get the error message for errors during writing to target. This is used in Status write back once an attempt has been made to write the record to the target.

Mapping: <TargetField> = ERROR()

Example : Error while processing the state

TODO: Example missing

EXACT(String str1, String str2)

This function compares two given string values and returns true if both the values are exact match otherwise false(case-sensitive).

Mapping: <TargetField> = EXACT(VALUE("SourceField1"), VALUE("SourceField2"))

<TargetField> = EXACT(VALUE("FirstName"),VALUE("FirstName"))

The above example will return true as the value of first attribute is "Chris" and the value of second attribute is also "Chris".

FAST_TLOOKUP(String query)

Mapping: <TargetField> = FAST_TLOOKUP("select id from account where writer_name = { reader_name } and writer_code = { reader_code }")

@return value of the return_col based on the where_clause, else it would return empty value

TODO: NOT CLEAR - explain when to use and how to use

FIND(String findText, String withinText)

This function returns the position of the first string parameter within the supplied second string parameter.

Mapping: <TargetField> = Find(VALUE("SourceField1"), VALUE("SourceField2"))

<TargetField> = FIND("arch","search")

In this example, pass the first string as "arch" and second string as "search". The FIND() function will return the position of "arch" in "search". The FIND() function will return 3 as the value.

Note: If the findText parameter finds value in withinText parameter more than once, then the function returns the position of very first existence.

FIND(String findText, String withinText, int startNum)

This function returns the position of the first string parameter within the supplied second string parameter from the passed start index.

Mapping: TargetField = FIND(VALUE("SourceField1"), VALUE("SourceField2"), "Start Position")

TargetField = FIND("arch","search",2)

In this example, pass the first string as "arch" and second string as "search". The FIND() function will search the string "arch" in "search" starting from the 2nd position of the "search" string and return the position of "arch" in "search". The function return 3 and first two characters of the string "Search" i.e. 's' and 'e' are ignored.

Note: If the findText parameter finds value within Text parameter more than once, then the function returns the position of very first existence.

Mapping: <TargetField> = FIXED("sourcefield")

<TargetField> = FIXED(12.6789)

In the price field the value passed is 12.6789 so the FIXED() function will return the price value as 12.68

FIXED (Double, Integer)

This function rounds a supplied number to a specified number of decimal places.

Mapping: <TargetField> = FIXED("sourcefield",1)

<TargetField> = FIXED(14.789,1)

In the price field the value passed is 14.789 so the FIXED() function will return the price value as 14.8

FIXED (Double, Integer, Boolean)

Not supported

FORMAT(String value, String format)

Mapping: <TargetField> = FORMAT("SourceField", "Format String")

<TargetField> = FORMAT(210.6,"#,##0.00")

In the price field the value passed is 210.6 so the FORMAT() function will return the price value as 210.60

TODO: #,##0.00 - check if this format will return as above ??

GETROOTVALUE(String elementName)

This function returns the immediate parent node of XML element.

Mapping: <TargetField> = GETROOTVALUE("SourceField1")

<TargetField> = GETROOTVALUE(VALUE("Name"))

<Contact>
<Name>John</Name>
</Contact>

The "Name" value will be compared in the XML and if found returns the parent node

GETSOURCEXML2STRING()

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

Mapping: <TargetField> = GETSOURCEXML2STRING()

The XML elements are returned as a string.

Please Review

GETSOURCEXML2STRING(String elementName)

Mapping: <TargetField> = GETSOURCEXML2STRING("elementname")

<TargetField> = GETSOURCEXML2STRING(VALUE("InvoiceRet"))

The "InvoiceRet" node element is found in the xml and returned as a string.

Please Review

IF(Boolean condition, String trueValue, String falseValue)

This function tests the user-defined condition and returns one result if the condition is true, and another result if the condition is false.

Mapping : <TargetField> = IF(String,Integer,String)

<TargetField> = IF(ISEMPTY(VALUE("Rate")),"0.00",VALUE("Rate"))

In this case the IF function checks the value of Rate to be empty then it returns 0.00 or else it returns original rate value from the Rate field.

ISEMPTY(String s)

This function returns true if the variable is unintialized or explicity set to empty; otherwise it returns false.

Mapping: <TargetField> = ISEMPTY("sourcefield")

<TargetField> = ISEMPTY(VALUE("FirstName"))

In the above example, the first name field has a value of "Alan" so the function ISEMPTY() returns true.

ISNULL(String s)

This function checks if the passed value is null then returns true; else, returns false.

Mapping: <TargetField> = ISEMPTY("sourcefield")

<TargetField> = ISNULL(VALUE("lastname"))

In the above example, the first name field has a value of "Alan" so the function ISNULL() returns false.

LEFT (String var)

This function returns the first character of the supplied string which is on left hand side.

Mapping: <TargetField> = LEFT(VALUE("SourceField"))

Example: passing a string

<TargetField> = LEFT("search")

In this example, pass a string as "search". The LEFT() function returns the value as "s" which is on the extreme left of the string "search".

LEFT(String var, int count)

This function returns the specified number of characters from the left of the given string.

Mapping: <TargetField> = LEFT(VALUE("SourceField1"), noofcharacters)

Example: passing a string

<TargetField> = LEFT("search",3)

In this example, pass the first parameter as "search" and second parameter as 3. The LEFT() function will return three characters from the left of the parameter "search" and the function returns "sea".

Note: If the length of the passed string is less than the second parameter then the function will return a full string as a result.

LEN(String var)

This function returns the length of the given string.

Mapping: <TargetField> = LEN(String)

Example : passing a string

<TargetField> = LEN("search")

In this example, pass the string as "search". The LEN() function will returns result as '6' which is the length of string "search".

LINK(String colName, String value)

Note: This function is deprecated and an alternative function could be MEMLOOKUP orTLOOKUP functions.

Mapping: <TargetField> = LINK(VALUE("SourceField1"), VALUE("SourceField2"))

LINK(String colName, String query, String fieldName, String refValue, String objectName)


Note: This function is deprecated and an alternative function could be MEMLOOKUP orTLOOKUP functions.

The 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

The function creates an internally cached table querying the target (Salesforce) database with two columns, first column being the primary key for the table, second for the other column name.
 
It then looks for a string that is same across both Source and Target system before updating the Target LOOK-UP(Salesforce) field with the Source field value.

LINK(String colName, String query, String fieldName, String refValue, String objectName, String valueField)

Note: This function is deprecated and an alternative function could be MEMLOOKUP orTLOOKUP functions.

LOG()

This is not in function2base

Mapping: <TargetField> = LOG(VALUE("SourceField"))

Example : <TargetField> = {LOG("********ChainId"+LEFT(VALUE("Udf_Pa_Pricing"),20));return LEFT(VALUE("Udf_Pa_Pricing"),20);}

The log function gets the value of the target field "udf_pa_pricing" to while performing write operation and can be viewed in logs section for debugging whenever there is an error.

LOOP

This function is different from the conventional '=' operator to map source and target.

<SourceField "loop" TargetField> is used in
scenarios where a grouping the Line Items are required based on the target identifier. It can also be used when the identifier is unique and same across both source and target systems.

Example1:  Salesforce Oppotunity LineItems to QuickBooks Invoice LineItems

Mapping <TargetField> : InvoiceAddRq/InvoiceAdd/InvoiceLine Add [dbsync:loop] "OpportunityLineItems/records"

In the above example for every opportunity Line Item, the loop will create a corresponding Invoice Line Item.

Example2:  Source - Database ; Target - Quickbooks
Database Query : select invoice_no,customerid,item,itemdesc from InvoiceTable
Mapping : InvoiceAddRq/InvoiceAdd/InvoiceLineAdd [dbsync:loop]  "invoice_no/list"

In the above example, we are using "invoice_no" column from the database as an identifier. Based on this identifier we are grouping each row as a line item and then mapping it with Quickbooks Invoice Line Item.

For instance, if the database Invoice table has four rows with "invoice_no" being the same for all the four rows, then the mapping will create one Invoice in Quickbooks with four Line Items rather than creating one Invoice for each row.

LOOKUP(String adapterName, String queryString)

Mapping: <TargetField> = LOOKUP("sourceconnector" , "querystring")

Example:<TargetField> = LOOKUP("Salesforce","select Id from Account where Name='Test'")

The above example with fetch the Id from account object of Salesforce from the source application and assigns it to the target field whenever the name field has a value of "Test"

LOWER (String var)

This function converts all character in a given string to lowercase.

Mapping: <TargetField> = LOWER(String)

Example: passing a string

In this example, pass a string as "SEARCH". The LOWER() function will return the string converted to lowercase.

<TargetField> = LOWER("SEARCH")

The function will return "SEARCH" as "search".

LPAD(String text, String pattern, int pad)

This function is used to pad left side of a string with the specific set of characters. The integer is the total length of the string returned after padding.

Mapping: <TargetField> = LPAD(VALUE("SourceField"), "string", Int)

Example1: <TargetField> = LPAD("tech on the net", "0", 15)

The function would return result as "tech on the net"

Example2: <TargetField> = LPAD("tech on the net", "0", 18)

The function would return result as "000tech on the net"

LSPLIT(String text, String splitter)

This function returns the split value of the string starting from left side of a string till the splitter value.

Mapping: <TargetField> = LSPLIT(VALUE("SourceField"), "string")

Example: <TargetField> = LSPLIT ("tech-on-the-net", "-")

The LSPLIT() would return result as "tech"

MAP(String key, String...mapEntries)

This function returns the value against the key passed from the key-value pair(s) passed via second parameter of the function.

Mapping: <TargetField> = MAP(VALUE("string1", "string2", string3, string4)

Example: <TargetField> = MAP("myKey", "a=b", "c=d", "myKey=myValue")

The MAP function will return "myValue". If key is not present in any of the key-value pairs then function will return empty string.

MEMLOOKUP(String cacheIdentifier, String query)

This function uses unique identifier of a query i.e cacheIdentifier which would load up the dataset for a lookup.This function creates a table in memory for returning the value of a lookup.

Mapping: <TargetField> = MEMLOOKUP(StringCacheIdentifier, StringKey)

Example1: Salesforce object

<TargetField> = MEMLOOKUP("AccountID",VALUE("SourceField") ) 

In this example, AccountID is the memory table created on Account object of Salesforce using MEMTABLE() function. 

Example2: DATABASE TABLE

<TargetField> = MEMLOOKUP("AccountID", VALUE("SourceField") )

In this example, AccountID is the memory table created on dbAccount table of database using MEMTABLE() function.

MEMLOOKUPREGEX(String cacheIdentifier, String key, String regex)

A variant of the MEMLOOKUP function which takes an additional parameter i.e. regex, returns the value of only those key which matches with regex.

The value whose key starts with prefix, or null if not available

This need to be fixed

MEMTABLE(String cacheIdentifier, String query)

This function creates a memory table in the system with key-value pair of the query passed through this function.


You can append the MEMTABLE() at the end of any other mapping.

MAPPING: <TargetField> = VALUE("SourceField") + MEMTABLE(StringCacheIdentifier, StringQuery)

Example : Database Table

<TargetField> = VALUE("SourceField") +MEMTABLE("AccountID","Select ID, Name from dbAccount")

In this example, select ID and name value from dbAccount table for all records in dbAccount Table.

 This need to be fixed.

MID(String text, Int startNum, Int numChars)

This function extracts a substring from the string and returns the substring.

Mapping: <TargetField> = NOTEQUALS("string1","string2")

Example : <TargetField> = NOTEQUALS(VALUE("CurrencyISO"),"USD")

This function compares "USD" against all the values of "CurrencyISO" field and it's start the function finds there is an value of "USD" to which it returns true.

NUMBER(String text)

This is not in UI

This function returns an integer value of the string passed to it.

MAPPING: <TargetField> = NUMBER("String")

<TargetField> = NUMBER(*VALUE("NumberOfEmployees"))*

If the value of "numberofemployees" field is null or empty then the function returns zero.

OR(boolean exp1, boolean exp2)

This function evaluates the conditions passed through the function and returns true if any one of condition evaluates to true; otherwise, returns false.

Mapping: <TargetField> = OR(Boolean, Boolean)

Example : <TargetField> = OR(VALUE("FirstName")==VALUE("LastName"), VALUE("Id")=="123")

In the above function the firstname has a value "Alan" and last name has a value "Chris" and Id field has a value of 456 which is not equivalent to 123 and hence, the function returns false.

This function PARAM extract the values from session which is in the format PARAM.SOURCE_Object.Variable=PARAM.TARGET_Object.Variable and returns the variable value.

Mapping: <TargetField> = PARAM(''string'')

Mapping: <TargetField> = PARAM_PARENT(''string'')

Example: <TargetField> = PARAM_PARENT(VALUE("Description"))

If the value of "Description" starts with "PARAM" and the value is present in the session, then the second text literal is concatenated with "/" and third text literal and returned.

Mapping: <TargetField> = PARENTVALUE("sourcefield")

Example : Salesforce object fields

Trigger : select Id, name, account.name from opportunity

The above query will retrieve ID, name and account name from opportunity object of Salesforce.

<TargetField> = PARENTVALUE("Account/Name")

This function to retrieves the value of the Account Name which is a lookup against each opportunity and returns to assigned target field.

Mapping: <TargetField> = PARENTVALUEATTR("stringpath","attr")

Example : <TargetField> = PARENTVALUE("CustomerRef","Name")

<CustomerRef>

<Name>Alan</Name>

</CustomerRef>

In this example the the CustomerRef object has a Name field in the form of the XML and will return the value as "Alan".

Mapping: <TargetField> = PROPER("SourceField1")

Example: <TargetField> = PROPER("search")

In this example, Pass string "search" as the parameter then the function returns the result as "Search".

REPLACE (String oldText, Int startNum, Int numChars, String newText)

This function replaces a full string or a part of string text with another text string from the position sent through parameter i.e. startNum.

Mapping: <TargetField> = REPLACE(VALUE("SourceField1), 1, 5, "replace string")

Example : Pass a string

<TargetField> = REPLACE("seaaarch",3,3,"a")

In this example, Pass string "search" as the first parameter, 3 as start number for the second parameter, 3 as a number of characters to be replaced for third parameter and "a" as the replace string. The REPLACE() function will replace three characters from third character to fifth character in the string. The resulting string returned by function will be "search".

Mapping: <TargetField> = REPT(VALUE("sourcefield"), 2)

Example:<TargetField> = REPT("tech", 2) 

In the above example, The function REPT() would return result string as "techtech"

RIGHT(String var)

This function returns a right most character of the string value passed.

Mapping: TargetField = RIGHT(String)

Example 1: String Parameter

In this example, Pass string as "search". The RIGHT() function will return first character from the right of string "search". So string returned by function will be "h".

<TargetField> = RIGHT("search",1)

RIGHT(String var, Int count)

This function returns a specified number of characters from the end of a supplied text string.

Mapping: <TargetField> = RIGHT(VALUE("SourceField1"), NoOfCharacters)

Example : String parameter

In this example, Pass first string as "search" and second parameter as 5. The RIGHT() function will return five characters from the right of string "search". So string returned by function will be "earch".

<TargetField> = RIGHT("search",5)

Note: If number of characters in the string is less than number of characters requested from the function, it will return the full string.

Mapping: <TargetField> = RPAD(VALUE("SourceField1"), "string", Int)

Example 1: <TargetField> = RPAD("tech on the net", "0", 15)

The function would return result string as "tech on the net"

Example 2: <TargetField> = RPAD("tech on the net", "0", 18)

The function would return result as "tech on the net000"

Mapping: TargetField = RSPLIT(VALUE("SourceField"), "string")

Example: <TargetField> = RSPLIT ("tech-on-the-net", "-")

This function would return result string as return "net"

SEARCH(String findText, String withinText)

This function returns the position of a supplied text string from within a supplied text string.

Mapping: <TargetField> = SEARCH(VALUE("SourceField1"), VALUE("SourceField2"))

Example : String parameters

In this example, Pass the first string as "arch" and second string as "search". The SEARCH() function will return the place value of "arch" in "search". So it will return 3 as the place value.

<TargetField> = SEARCH("arch","search")

Note: If the search string exists more than once in the second string, the function returns the place value of first existence.

SEARCH(String findText, String withinText, int startNum)

This function returns the position of a supplied text string from within a supplied text string for which starting position can be specified.

Mapping: <TargetField> = SEARCH(VALUE("SourceField1"), VALUE("SourceField2"), "Start Position")

Example : String parameters

<TargetField> = SEARCH("arch","search",2)

In this example, Pass the first string as "arch" and second string as "search". The SEARCH() function will search the string "arch" in "search" from the second position in the string and will return the place value of "arch" in "search". So it will return 3 as the place value. So character 's' will be ignored.

Note: If the search string exists more than once in the second string, the function returns the position of first existence.

Mapping: <TargetField> = SESSION_GET("KEY")

Example: Retrieving the "key" stored in the session

CustomerAddRq/CustomerAdd/Name = SESSION_GET("Account_Name")

In the above example, we are retrieving the KEY ie. "Account_Name" of Salesforce opportunity object stored in the session and value that is being parsed internally in that of what was stored in the session, "Avankia".

SESSION_PUT(String name, String value)

This function stores the key/value pair in the session of that particular process or workflow which is active. This function can only work active workflows within DBSync.

Mapping: <TargetField> = SESSION_PUT("KEY","VALUE")

Example: Storing a static value (Account_Name) in the session

out = SESSION_PUT("Account_Name","Avankia")

The example stores a static key/value pair for an "AccountName". This assigns the value "Avankia" to the key "Account_Name" which can be retrieved using SESSION_PUT variable and printed to the console.

SETATTR(String colName, String attName, String attValue, String 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. This function can only be applied when writing to salesforce for pricebook object.

Mapping: <TargetField> = SETATTR(TargetField, TargetobjectName, Targetobjecttype, sourcefield1)

Example :SETATTR("PricebookEntryId","pricebook","Standard Price Book",VALUE("ItemRef/FullName"))

This function is used to query pricebook object i.e.( select pricebookentryid where name=standardpricebook and itemref/fullname = pricebookentryid) and if these condition is satisfied it returns the value of pricebookentry id and assigns it to the mapped target field.

Mapping: <TargetField> = SUBSTITUTE("sourcefield", "string1", "string2")

Example: <TargetField> = SUBSTITUTE(VALUE("FirstName"), "John" "Alan")

In the above example all of "firstname" field records which are having values as "John" will be replaced with "Alan".

Mapping: <TargetField> = SUBSTITUTE("sourcefield", "string1", "string2", occurences)

Example : TargetField = SUBSTITUTE(VALUE("FirstName"), "John" "Alan",2)

In the above example the firstname field which are having values as "John" with "Alan" for the first two occurrences only.

TLOOKUP(String queryString)

Mapping: <TargetField> = TLOOKUP(stringQuery)

Example: Database table
In this example, I will select ID value for Account from dbAccount table with name as ABC.
<TargetField> = TLOOKUP("Select Id from dbAccount where Name = '" + VALUE("NAME") + "'")
Here assumption is that name field contains value ABC.

TODAY()

This function returns Today's date.Format returned from TODAY() is "Day Mon DD HH:MM:SS TTT YYYY"

Mapping: <TargetField> = TODAY()

Example: Fri May 06 07:10:58 CDT 2011

Mapping: <TargetField> = TRIM(VALUE("sourcefield"))

TargetField = TRIM(VALUE("FirstName"))

In the above example the field of "firstname" has a value " John" so the TRIM() function will remove the leading space and will return result as "John"

UNIQUEFIELD(String colName, String value, String colValue)

This function sets the column with the column value and attribute with the unique field value and returns as an object.

UPPER(String text)

This function converts all the character in a passed string to upper case.

Mapping: <TargetField> = UPPER(String)

Example: <TargetField> = UPPER("search")

In this example, Pass string as "search". The UPPER() function will return the string converted to lowercase. So "search" string will be returned as "SEARCH".

Mapping: <TargetField> = Conditional Statement

Example: <VALIDATEROW> = IF(ISEMPTY(VALUE("OpportunityId")),"true","false")

This condition will execute a row only if the field of "opportunityid" has a value and returns true; else false. In the above example the opportunitydid has a value of null and returns false.

VALUE(String xPath)

This function converts the input parameter to be read as string and returns the passed value as string.

MAPPING: TargetField = VALUE("SourceField")

Example: <TargetField> = VALUE("Name")

In the above example the "Name" field is read as string by the system. The "Name" field has a value of "John" which in itself is returned as string.

MAPPING: TargetField = VALUE("SourceField", true)

XML Sample :

<person gender = "female">

<firstname>Alan</firstname>

</person>

<TargetField> = VALUE("person/firstname", true)

In the above example as the "firstname" attribute has a value of "Alan" so the function will return "Alan" as example. For better understanding lets assume if the firstname has no value in the attribute so the function returns the string as empty string as second parameter is set to true.

Mapping: TargetField = VALUEATTR("xpath","name")

XML Sample :

<person gender = "female">

<firstname>Alan</firstname>

</person>

<TargetField> = VALUEATTR("person", "gender")

In the above example the function returns second passed attribute value i.e. female from the xml sample.