+ Start a Discussion
maxoutmaxout 

Data loader and the ID field

Just finish a test.

After a record is deleted from the force, the same record cant be upserted mapping with ID, error saying 'record deleted'.

It seems like upsert only works for fields in a record, but not the record itself.

A separate insert does work, but a new ID is created.

This means ID cant be inserted into force. Right or not?

 

Keeping the ID might be needed when rebuilding a set of data.

 

A related post:

http://boards.developerforce.com/t5/General-Development/Can-I-use-the-ID-field-as-the-external-id-field-for-upserts-on/m-p/72368

Ankit AroraAnkit Arora

This error is coming because when you delete the record it goes in recycling bin for 45 days. We can undelete the record also, and Id remains the same. So you can not do upsert on record Id which is deleted till 45 days of its deletion.

 

 

Thanks
Ankit Arora