An External Id is a custom field that has "External Id" attribute checked. Its used to contain unique record identifiers from a system outside of Salesforce. Salesforce allows us to mark only custom field with data type Text , Number or Email as External Id. Note: External Id is not case-sensitive. Considerations: External Id is an attribute that can be added to a custom field to indicate that it should be indexed and treated as an Id. Its a user-defined cross-referenced field. It can be created for custom field type(Text, Number and Email only). Each object can have up to 25 External Ids. Benefits: It helps improve report and API SOQL performance. It can be used with UPSERT DML operation to seamlessly integrate apps with other system. No need to know Salesforce Record Id to load data. Very convenient for data integrations and migrations. The import wizard will detect existing records in Salesforce that have the same External Id. It becomes searchable in the s...
Nice to meet you
ReplyDelete