thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Business Platforms & EA · Foundational

Upsert

Operation that updates a record if a matching key exists or inserts a new one otherwise.

Definition

Upserts match on the Salesforce ID or an External ID field. If multiple matches are found the row errors. Upsert is available in Data Loader, the APIs and Apex DML.

Example

upsert accounts ERP_Id__c;

Exam tip

Upsert with an external ID is the standard pattern to sync records without storing Salesforce IDs externally.

Related terms