Page History

Issue:

...

1. If the name contains special characters, we We cannot update the QuickBooks IDs QB Id’s based on the name from QuickBooks to Salesforce.2. If QB to SF if the name contains special characters, we .

2. We cannot link any Object based on name if the name contains special characters.Description

Reason:

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

Image RemovedImage Added

Figure Fig 1

Image Removed

...

Image AddedFig 2Resolution:

Solution

1. Open the mapping and identify the field in QuickBooks

that needs

2. which has to be linked and

check whether it

3. contains special character

(s)

4. .

5. Pass the value of the field

by using

6. in 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")