Passing (Escaping) Special Characters from QuickBooks to Salesforce

Issue: 

1. If the name contains special characters, we cannot update the QuickBooks IDs based on the name from QuickBooks to Salesforce.

2. If the name contains special characters, we cannot link any Object based on name.

Description:

Salesforce does not allow to query the field name if it contains any special characters(‘,/,\) in it. Hence we need to escape the special characters so that the respective field can be queried.

Figure 1

Figure 2

Resolution:

1. Open the mapping and identify the field in QuickBooks that needs to be linked and check whether it contains special character(s).
2. Pass the value of the field by using the ESCAPESPECIALCHARACTER() function and save it.

Examples:

1. TLOOKUP("select Id from Account where Name='"+ESCAPESPECIALCHARACTER(VALUE("Name"))+"'")
2. LINK("Account","select Id,AccountId from Opportunity","Name",ESCAPESPECIALCHARACTER(VALUE("CustomerRef/FullName")),"Opportunity")