This page described how to create a Salesforce Upsert operation using the Jitterbit Connect Salesforce Upsert Wizard.
The Salesforce Upsert activity allows you to update existing or insert new records in a connected Salesforce instance using Jitterbit. An "upsert" is essentially either an update or an insert operation, or both, depending on the data provided.
NOTE: A Salesforce upsert should include an ID field that maps to the selected External ID in Salesforce. If the ID field source record is populated with the Salesforce External ID, the record is updated in Salesforce. IF the ID field is blank, a new record is inserted into Salesforce.
The wizard takes you through a series of screens, gathering the information it requires to create the operation in the current project. It follows these steps:
Select an External ID Field
Select Where Your Source Data Comes From
The source is the location of the data to be used by the operation.
The screens presented vary depending on your answers to these questions.
If you prefer, you can instead add a source later in your development of the project. For details on the different sources, see the documentation on Sources.
Select one of:
Creating A New Source
To create a new Source, select the Create New… option from the dropdown menu. The New Source fields display. For example, when creating a new Local File Source, you will see fields similar to these:
For file sources (Local File, FTP Site, File Share, or Temporary Storage), you need to specify or create a source and then specify or create a file format to use with that source. If the file suffix cannot be used to determine the file type, you will be prompted to confirm the file and the file type.
FTP Site, File Share, or Temporary Storage
Confirm File Type
Select File Format
Review the File Format Structure
Click the Response Option checkbox if you need to interact with the response from Salesforce and want to map information directly from that response:
On the Summary, you can edit the Name given to the wizard and specify whether to use the wizard's Automapper to map the data:
If you chose Select an existing File Format (or created a new one) in the Target screen of the wizard, the transformation mapping appears in your work area.
These advanced options are available for a Salesforce Upsert:
Additional operation options for writing success and failure records are described on the Salesforce Advanced page.