We are working hard to make updates to the Shop and Account Management portal.

Please note that many of these changes will roll out this Saturday, June 1st and will require downtime. We are working to ensure minimal disruption for our eOne community and really appreciate your patience as we push out these changes. Please reach out to sales@eonesolutions.com with any questions.

Back

Escape Characters in Salesforce.com SOQL Query

Published: Apr 11, 2017
Post Author Written by eOne Solutions

I am trying to compare a Salesforce.com field with a string that contains a single quote character and I am receiving the error, ERROR at Row:1:Column:390 unexpected token: s


To handle single quotes or other reserved character in a SOQL query, we need to put a backslash in front of the character ( ).

The correct query to get Account Information¬†for Joe’s boats would be the following:

select Account.Id, Account.Name, Account.Address, Account.City from Account where Account.Name = ‘Joe’s Boats’

Link to additional Salesforce.com character’s that need to be escaped. https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_quotedstringescapes.htm

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.