Question 41234 in PHP Question posted in
Official manual can be found here.

salesforce api build query with array as parameter (IN condition instead of OR) – PHP

I have a list of emails and I have to check which of these emails already corresponds to a salesforce account and, for these, I have to get the Id to store in my system. The list is in a form of a php array and the api call is made via curl.

I’m able to perform the request if the call has all the emails in an OR condition:

$query = "query/?q="; $sql = "SELECT+Id,+Email+FROM+Account+WHERE+Email='[email protected]'+OR+Email='[email protected]'"; $url = $domain . $api . $query . $sql;

But my email list is very long so what I’d like to do is performing something like this:

"SELECT Id, Email FROM Account WHERE Email IN (" . $emails . ")"

Of course, this is SQL language, but is there a way to do this on salesforce? I tried using the same language but it doesn’t work:

$sql = "SELECT+Id,+Email+FROM+Account+WHERE+Email+IN+(" . $emails . ")";

the code above returns an error like "bind variables only allowed in apex code – malformed query"

so, is there a way to perform a query with the IN condition instead of OR ?

Tags:

2

Answers


  1. 0

    There’s a shortcut but it’s not as great as you’d hope.

    You need to write your query as

    SELECT Id, Email
FROM Account
WHERE Email IN ('[email protected]', '[email protected]', '[email protected]')

    SOQL via API doesn’t offer bind variables / prepared statements you’d expect from "normal" dialect. (It absolutely is possible and easy in Apex, the server-side language… "just" not over the API). And the query’s total length has to be under 100K.

    If this is unacceptable – Apex developer could expose for you a REST (or SOAP) service and you could pass the list of emails to it, get results back. It’d be limited to 50K records returned and 6 MB heap size (~RAM) consumed, whichever’s lower.

    Login or Signup to reply.
  2. 0

    Do you know how to get these Ids using another query?
    You are able to make subquery inside WHERE clause. Something like this:

    SELECT Id, Email FROM Account WHERE id IN (SELECT AccountId FROM Contact WHERE ...)
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search