select Id, Name from Contact where Email in ('apple+super@gmail.com','apple+100@gmail.com')
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=%27apple+super@gmail.com%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=\'apple+super@gmail.com\'
and the malformed query is the resulting respone.
What will be the correct way to query my SOQL using "IN" clause?
Thanks in advance