Conversion of a String Value Type Present in QuickBooks to Double Value of Type at Salesforce

Issue:

Mapping a custom field, in a Customer object in QuickBooks, couldn’t be mapped into the custom field in Salesforce.

The main reason was Type conversion mapping. Custom field Type was String in QuickBooks and it was Type Double in Salesforce.

The following screen shot displays the custom field of Type String in QuickBooks that has to be mapped to another custom field of Type Double in Salesforce.

Solution:

I used the following mapping query in order to convert the String to Double in Salesforce instance.

VALUE("DataExtRet[DataExtName[1]/text()='Item Code']/DataExtValue")

The value in the custom field was converted successfully and synchronized to Salesforce instance as shown below:

The converted value is shown in Salesforce.