[SalesForce] How to write SOSL IN query

I've following SOQL query –

SELECT Id, Name, Email, Account.Id, Account.Name FROM Contact WHERE Email in :emails

Here emails is a comma separated list of email ids.

Can I write the same query in SOSL? I'll be running the query using rest API. The reason I want to do it using SOSL is –

a) I want to get around the limit of 4000 characters in SOQL where clause

b) I also want to search Lead object, not just Contact. This one is low priority though.

Best Answer

Yes, you can write the query in SOSL. There's a great bit of info here: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_sosl.htm

Please be aware that SOSL isn't the most precise way of finding records, so you may be better off even splitting your query into two SOQL queries and combining the result objects somehow.

I'm a little nervous that you might have a SOQL query of longer than 4000 characters. Do you really need every part of it? All the fields and all the WHERE clause parts? If so, you may wish to consider breaking your query into multiple queries and combining them.

Related Solutions

[SalesForce] Bulk match contacts based on email

You can write a custom endpoint if you wanted to; Apex can bypass the normal character limits for a SOQL query. Here's the Apex for that:

@RestResource(urlMapping='/getContacts')
global class GetContacts {
  @HttpPost global static Contact[] getContactsByEmail(String[] emails) {
    return [SELECT Name, Email FROM Contact WHERE Email = :emails];
  }
}

To call this, you'd use a call like this:

POST /services/apexrest/getContacts HTTP/1.1
Host: something.my.salesforce.com
Content-Type: text/json
Authorization: Bearer <session-id>
Content-Length: <calculated-size>

{ "emails": [ "email1@xyz.com", "email2@abc.com", ... ] }

You can theoretically retrieve up to 50,000 contacts this way. Of course, if this is just a one-shot, you might not want to waste your time with this, but if this is a regular thing, it might help you.

Best Answer

Related Solutions

[SalesForce] Bulk match contacts based on email

Related Topic