What does external ID mean in Salesforce?

When importing custom objects, solutions, or person accounts, you can use external IDs to prevent duplicate records from being created as a result of the import operation. An external ID is a custom field that has the “External ID” attribute, meaning that it contains unique record identifiers from a system outside of Salesforce. When you select this option, the import wizard will detect existing records in Salesforce that have the same external ID. Note that this operation is not case-sensitive – for example, “ABC” will be matched with “abc”. However, there is an exception: if the custom field has the separate “Unique” attribute and the case-sensitive option for that attribute is selected, uppercase and lowercase letters will not be considered identical.

The fields with below data types can only be external Id

1. Number
2. Text
3. Email

When a field is made as an external Id, the field will be automatically indexed. Additionally, if you have an external ID field, the field becomes searchable in the sidebar search. You also can use the upsert API call with the external ID to refer to records.

• This reply was modified 6 years, 2 months ago by  Forcetalks.