Tutorial V2.41 (Lightning)

  1. Home
  2. Docs
  3. Tutorial V2.41 (Lightning)
  4. 27. What is an external Id and how to use it to handle correct data update with an interface?

27. What is an external Id and how to use it to handle correct data update with an interface?

This tutorial explains what is an external Id  and how do we set it. It also describes where to set it.

1 What is an External Id?

  • External Id is a unique key or primary key that is difference from Salesforce Id which is  created by user in order to insert, upsert, delete and update records in Salesforce.
  • External Id cannot be duplicated.
  • You can select fields of a sObject e.g Account which as external Id to be used as composite key in an interface.

2 The detail of External Id
This section will describe in detail more about external Id and will demonstrate how and where you can set it. You have to remember that external Id could be one field or combined fields in the sObject. Specified more external fields (even mapping in salesforce) means combine key; integration will find record in salesforce based on those fields. The following contents will show how and where to set the external Id:

3. How and where to set the external Id

This part will skip the creation of interface and assume you already have one. The demonstration is mainly about how to set an external Id. You can set external Id in three ways:
– Set the check box “Ext Id” in Mapping Editor
– Choosing or inputting external Id in field “Salesforce External Id”

Inbound interface

To set external Id in Mapping Editor
– Enter Interface page detail

– Scroll down to “Mapping” section then you will see the Data Mapping editor

– Check box on Ext Id

To choose or input external Id in field “Salesforce External Id”

– Enter interface page detail and scroll down to section “Inbound Setup”

Outbound interface

For outbound interface, you can set external Id in Mapping Editor like inbound interface. However, you can choose or input an external Id in field “Salesforce External Id”. The steps to set external Id is similar to inbound interface.
To set external Id in Mapping Editor
– Enter Interface page detail
– Scroll down to “Mapping” section then you will see the Data Mapping editor

– Check box on Ext Id

Was this article helpful to you? Yes No

How can we help?