Upsert by External Id
A 2-step recipe with Salesforce. We can help you get access.
Recipe · 2 steps
Upsert by External Id
with Salesforce
Upsert a Salesforce SObject record by an external id field.
- Upsert the record by external id field and value. Salesforce creates a new record when no match exists and updates the existing record when one does.
- Retrieve the upserted record back by the same SObject type and external id field to confirm the persisted field values.
What you'll need to have ready
- sobjectApiName: The API name of the Salesforce SObject type (e.g. Account, Contact, MyCustomObject__c).
- externalIdField: The API name of the external id field to match on (e.g. External_Id__c).
- externalIdValue: The value of the external id field used to match a record.
- fields: Map of field API name to value to write to the matched or created record.
For your developer
Arazzo workflow salesforce:upsert-by-external-id, 2 operations: SObjectRowsbyExternalID → SObjectRowsbyExternalID. Specs on APIs.io.