Auto-Number not available as external ID in Data Loader?
|Knowledge Article Number||000004514|
I have an Auto Number field that is set as an External ID. However, when I use the upsert option in the Data Loader, it cannot be used as an external ID for matching records.
Users can use AutoNumbers as ExternalID fields, but the Data Loader does not support them for use with Upsert. The Upsert command is used to insert or update depending on if the external ID is found in the system. AutoNumbers cannot be used in upsert if the externalID field value already exists. If it does not exist, the upsert call will fail because you are trying to insert a field that cannot be created.
A workaround can be to develop your own API integration. Alternatively, the field type can be switched to Text for the time of the update and then back to Auto number again.