select Id, Name from Contact where Email in ('[email protected]','[email protected]')
Can anyone help me to query this using the salesforce query api endpoint.
The endpoint that I have tried
https://{myWorkplaceDomainUsed}--sandbox.cs67.my.salesforce.com/services/data/v42.0/query/?q=select+Id+from+Contact+where+Email=%[email protected]%27
and the response that I get is:
{
"totalSize": 0,
"done": true,
"records": []
}
Records are present in salesforce but the result is not displayed.
I even tried escaping query string with "\". The URL that I used is:
https://{myWorkplaceDomainUsed}--sandbox.cs67.my.salesforce.com/services/data/v42.0/query/?q=select+Id+from+Contact+where+Email=\'[email protected]\'
and the malformed query is the resulting respone.
What will be the correct way to query my SOQL using "IN" clause?
Thanks in advance