We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ROQL - Email address with single quote

Received Response
32
Views
3
Comments
edited Mar 12, 2018 10:48AM in Integrations and APIs 3 comments

Content

Following ROQL sentence throws error, because it contains single quote in the email address. 

select count(*) from Contact where Emails.EmailList.Address='gavin'[email protected]' and Emails.EmailList.AddressType.ID = 0

How to write ROQL without error?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!