Working with searches and query API. Executing a SOQL query using "IN" clause

Question

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

Answer 1

You should put ' ', but you don't need to escape them try that one https://{myWorkplaceDomainUsed}--sandbox.cs67.my.salesforce.com/services/data/v42.0/query/?q=select+Id+from+Contact+where+Email='[email protected]'.

If you want IN you can use it like this https://{myWorkplaceDomainUsed}--sandbox.cs67.my.salesforce.com/services/data/v42.0/query/?q=select+Id+from+Contact+where+Email+IN+('[email protected]', '[email protected]')

UPDATE: Code for IN close with escaping for '+' emails

List<String> emails = new List<String>();
// init emails;

String emailString = '(\'' + String.join(emails, '\', \'') + '\''.replaceAll('\\+', '\\\\+');

String query = '... Email IN ' + emailString;