Loading

Error 'ID Not Specified in an Update Call' When Using Data Loader to Update or Upsert Records

Julkaisupäivä: Jul 24, 2023
Kuvaus

When you attempt to perform an update or upsert operation using Data Loader, you may receive the error:
'ID not specified in an update call'
This error occurs for one of the following reasons:

  • Your CSV file does not include a column containing Salesforce record IDs for the records you want to update.
  • Your CSV file does include an ID column, but it was not mapped to the Salesforce ID field during the Data Loader field mapping step.
Ratkaisu

 

  • Each existing record in Salesforce is assigned a unique Salesforce record ID. In order to update existing records you must include and specify the existing record's IDs in your CSV and map the column containing record Ids to the Id field on the desired object in order for Data Loader. This is necessary for the operation to properly identify existing records for update
  • See Add IDs of existing records to your import file for more information on how to add the required Ids in your file.
  • If you are able to verify that your csv file does contain existing record IDs, please verify that you are mapping the ID column from your csv file to the ID field during the map fields step.
  • If you've selected Upsert but the record ID column is blank because all of the records are new, it is still necessary to map the ID column. Alternatively, choose Insert instead of Upsert so that Data Loader does not perform a check against this column. 
  • ​For additional information on Id fields, see ID Field Type.
 
Knowledge-artikkelin numero

000386242

 
Ladataan
Salesforce Help | Article