# DBAmp: “MISSING\_ARGUMENT:(External ID field name) not specified:--" error when performing Upsert operation with SF\_TableLoader using an External ID **URL:** \ **Category:** Editions\ **Tags:** article, salesforce, dbamp\ **Created:** [December 1, 2023, 9:25pm UTC](https://community.cdata.com/t/dbamp-missing-argument-external-id-field-name-not-specified-error-when-performing-upsert-operation-with-sf-tableloader-using-an-external-id/547 "2023-12-01T21:25:11Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Ismete\_M](https://avatars.discourse-cdn.com/v4/letter/i/f0a364/32.png) [@Ismete\_M](https://community.cdata.com/u/Ismete_M)\ **Post date:** [December 1, 2023, 9:25pm UTC](https://community.cdata.com/t/dbamp-missing-argument-external-id-field-name-not-specified-error-when-performing-upsert-operation-with-sf-tableloader-using-an-external-id/547/1 "2023-12-01T21:25:11Z")
This error is thrown by Salesforce itself when attempting to Upsert an input table that does not always contain a value for the External ID field(in this case External\_ID\_\_c as shown in the example below). When performing Upsert with SF\_TableLoader, it is necessary for the External ID field to contain a valid value. In this case, it should not be empty. If any of the records contains an empty value, the BULK API cannot decide whether that specific record needs to be updated or inserted. The external ID needs to be specified, as the error itself states. API reference on how the upsert operation works: ([https://developer.salesforce.com/docs/atlas.en-us.api\_asynch.meta/api\_asynch/bulk\_api\_2\_0\_upsert.htm?\_ga=2.136492534.793560252.1693256725-1249321776.1673529617](https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/bulk_api_2_0_upsert.htm?_ga=2.136492534.793560252.1693256725-1249321776.1673529617)) **Example query executed that reproduces the issue:** EXEC SF\_TableLoader ‘Upsert:BULKAPI, Parallel, Batchsize(500)’, ‘SALESFORCE’,‘Account\_Upsert’,‘External\_ID\_\_c’ **Account\_Upsert input table example:** ![bfc89735-6123-4de0-8d00-d1dee23e44e6.png](https://us1.discourse-cdn.com/cdata/optimized/1X/396b7e8a4055e800519903881edc042c45823dff_2_690x48.png) **Account\_Upsert\_Result table:** ![4e819940-b51b-44d0-85b3-e91a45041378.png](https://us1.discourse-cdn.com/cdata/original/2X/f/fe8aa82e34efbc1ff68a9d050bff54e95d1ac3ec.png) Please reach out to [support@cdata.com](mailto:support@cdata.com) if you have any questions.