https://systematic.workato.com/t5/workato-pros-discussion-board/how-to-search-salesforce-records-in-bulk-from-a-csv-file/m-p/12371#M4738 <P>Hi,</P><P>I am reading records from a CSV file and I need to check whether each record already exists in Salesforce.</P><P>For each row in the CSV, I need to search a Salesforce object (for example, Contact) by a unique field such as Employee ID and retrieve the matching record.</P><P>Is there a way to perform this lookup for all CSV records in a single step using a bulk operation or any other approach?</P><P>Or do I have to iterate through each CSV row and execute a separate Salesforce search for each record?</P><P>The CSV may contain a large number of records, so I would like to avoid processing them one by one if possible.</P><P>Thanks!</P> Sun, 12 Jul 2026 05:01:45 GMT shaked 2026-07-12T05:01:45Z https://systematic.workato.com/t5/workato-pros-discussion-board/how-to-search-salesforce-records-in-bulk-from-a-csv-file/m-p/12371#M4738 <P>Hi,</P><P>I am reading records from a CSV file and I need to check whether each record already exists in Salesforce.</P><P>For each row in the CSV, I need to search a Salesforce object (for example, Contact) by a unique field such as Employee ID and retrieve the matching record.</P><P>Is there a way to perform this lookup for all CSV records in a single step using a bulk operation or any other approach?</P><P>Or do I have to iterate through each CSV row and execute a separate Salesforce search for each record?</P><P>The CSV may contain a large number of records, so I would like to avoid processing them one by one if possible.</P><P>Thanks!</P> Sun, 12 Jul 2026 05:01:45 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/how-to-search-salesforce-records-in-bulk-from-a-csv-file/m-p/12371#M4738 shaked 2026-07-12T05:01:45Z