Upsert SObject Record
sf_upsert_recordCreate or update Salesforce records using an External ID for matching, inserting new records when no match exists and updating when it does.
Instructions
Creates or updates a Salesforce record using an External ID field for matching. If a record with the given external ID value exists, it is updated; otherwise a new record is created.
objectApiName: the SObject API name (e.g. 'Account', 'Contact') externalIdField: the External ID field API name used for matching (e.g. 'Legacy_Id__c') externalIdValue: the value to match on fields: the field values to set on the record
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fields | Yes | Field key-value pairs to set/update | |
| objectApiName | Yes | SObject API name, e.g. 'Account' | |
| externalIdField | Yes | External ID field API name, e.g. 'My_External_Id__c' | |
| externalIdValue | Yes | Value of the external ID to match on |