I have a file that has around 300 records that needs to be processed daily. Each record has a custom Id and other attributes that need to be updated. My original approach was to lookup each record individually to find the Salesforce Id and then do the update. It appears that I'm running into api limits with this approach.

Second thought was to lookup multiple records at once using something like:

SELECT Id, ThirdParty_ID FROM Lead WHERE ThirdParty_ID IN ('ID10124' , 'ID10359' , 'ID10548')
 
I'd like to know the most efficient way / best practices to lookup multiple records using the web service api to limit my api calls?
 
Thanks,
Matt

I have a file that has around 300 records that needs to be processed daily. Each record has a custom Id and other attributes that need to be updated. My original approach was to lookup each record individually to find the Salesforce Id and then do the update. It appears that I'm running into api limits with this approach.

Second thought was to lookup multiple records at once using something like:

SELECT Id, ThirdParty_ID FROM Lead WHERE ThirdParty_ID IN ('ID10124' , 'ID10359' , 'ID10548')
 
I'd like to know the most efficient way / best practices to lookup multiple records using the web service api to limit my api calls?
 
Thanks,
Matt