We have identified 1500 records were duplicate in one of our object,received these recordIDs from other replication database.Now I want to delete them from Salesforce,before that want to take backup of all of the records data using data loader.I'm using below query to get the data,but getting error message,

Select id,Name,ETL_ID from SesameAccount__c where ID IN('a03i000000DrCDV','a03i000000DrCFZ',........)

I've only record IDs handy,how can I get the data export using IDs.?Please help me here.

1 Answer 1


Someone may have a better solution but here is what I have done before:

  1. Create a custom field on the object say Export__c
  2. Use the original file with the IDs to populate the Export__c field to true
  3. Export the records with the Export__c field as true
  4. Update / do what is needed to those records
  5. Delete the Export__c field (if you feel the need). If keeping it set it to false when you update the records is step 4
  • Eric,where can i copy all the 1500 IDs ? Is it Export__c checkbox ?
    – User1511
    Jul 29, 2016 at 12:56
  • @User1511 - How have you "Identified" the IDs how did you get them. If it is a SF report you can export the data and use the results. In my scenario yes, the Export__c is a checkbox.
    – Eric
    Jul 29, 2016 at 16:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .