Salesforce Upsert

You can also use the following other transforms to modify your Salesforce database:

• Salesforce Insert: Inserts records directly into your Salesforce database.

• : Updates records directly into your Salesforce database.

Enter the following information in the transform name field:

• Transform name: Specifies the unique name of the Salesforce Upsert transform on the canvas. You can customize the name or leave it as the default.

Enter the connection information in the following transform options:

Enter the insert process settings in the following transform options:

Enter the output information in the following transform option:

Salesforce ID fieldname: Specifies the field to contain the Salesforce ID of the first record in the set of records (batch) you updated and inserted.

You can specify what fields to insert into your Salesforce database through the Fields table. Click Get fields to populate the table with input from the Hop data stream.

The table contains the following columns: