You are here: Use an External ID to upsert records, Studio for Salesforce

Create a script for upserting records

Upsert means update a record or, if the record does not exist in the system of records, create a new record in the system. It is a way to combine the Create and Update actions into one script, with one data file.

If you are creating records for data that already exist in another system of record, you can use the same ID number by creating an external ID field for that object.

For example, if you have accounts in SAP and you want to include that account number when you create the record in Salesforce, create an external ID field for the Account object. To create an external ID, see Create an external ID field.

If you do not need an external ID field, log in to Salesforce and choose an object.