Bulk Upserting Rows

Bulk Upserting Rows

Upsert calls SF_TableLoader, which

  • reads each row of the Input table
  • matches the columns to the fields of the Salesforce object
  • attempts to upsert the new object into Salesforce.

You must specify which field to use as the External ID field in the SF_TableLoader call.

SF_TableLoader attempts to upsert all rows of the load table regardless of any existing values in the ID column. In other words, the ID column is ignored on input when doing an Upsert operation.

After execution of the SF_TableLoader procedure, the ID column of the Result table is overwritten with the ID assigned by Salesforce for each successfully upserted row. If the row could not be upserted, the Error column of the Result table contains an error message for the failure.