I've a list of email ids and I want to match it against contacts in Salesforce. I'm planning to do use SOQL like -
Select Id, Name from Contact where email IN ('firstname.lastname@example.org, email@example.com')
I will be executing tis SOQL using REST API. What's the limit of emails that I can send in
IN clause. My list is going to be pretty big, around 5000 emails.
I understand that based on limit, I can split the list and make multiple queries for each batch. I'm concerned about hitting REST Api limits this way. Is there a better way to do this, like creating a custom API or thing like that?