I'm sending a query to SalesForce (using the SOAP API) that includes an IN clause, however, I keep getting a MALFORMED_QUERY error. Could someone point me in the right direction of what the query syntax is when using the IN clause? I've tried the following without success (the ids are made up in these examples):
SELECT Id FROM Lead WHERE Id IN {'000000000000000','111111111111111'}
SELECT Id FROM Lead WHERE Id IN '0000000000000','111111111111111'
Thanks.
5 answers
You're close
select id from lead where id in ('00Q3000000zLxkFEAS', '00Q3000000eODvUEAW')