Hi,
I am reading records from a CSV file and I need to check whether each record already exists in Salesforce.
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.
Is there a way to perform this lookup for all CSV records in a single step using a bulk operation or any other approach?
Or do I have to iterate through each CSV row and execute a separate Salesforce search for each record?
The CSV may contain a large number of records, so I would like to avoid processing them one by one if possible.
Thanks!
