Salesforce Bulk Operation
The Salesforce Bulk Operation activity performs operations such as insert, upsert, update, delete, hard delete on records in batches.
General
On the General tab, you can establish a connection to the Salesforce.com server.
The following table lists the configurations on the General tab of the Salesforce Bulk Operation activity:
Description
On the Description tab, you can enter a short description for the Salesforce Bulk Operation activity.
Advanced
On the Advanced tab, you can configure the following options of the Salesforce Bulk Operation activity.
The following table lists the configurations on the Advanced tab:
Field | Description |
---|---|
Field Mapper |
Field Mapper wizard maps fields from user selected files to Salesforce object fields. Only one-to-one mapping from the provided file field to sObject is allowed. This option is available only for CSV, XML, or JSON file formats. For JSON and XML formats, Mapper refers only the first record in the file for field names. Ensure that the first record has all field names, even if they are empty. |
Batch Size | Batch size is used to perform bulk operation in batches. The default value is 5000. Maximum value allowed is 10000. |
Serial Processing | Select this option if you prefer to process batches serially. By default, Salesforce processes batches in parallel. |
Input
On the Input tab, you can specify input values for the Salesforce Bulk Operation activity.
The following table lists the input elements on the Input tab of the Salesforce Bulk Operation activity:
Output
On the Output tab, you can find the output value.
The following table lists the output elements on the Output tab of the Salesforce Bulk Operation activity:
Fault
On the Fault tab, you can find the error code and error message of the Salesforce Bulk Operation activity. See Error Codes for more information about error codes and corrective actions to take.
Fault | Thrown when.. |
---|---|
SalesforceRestException | There is a problem with REST request, response or any other REST API error. |
SalesforceLoginException | An error occurred when logging in to the Salesforce.com server. |
SalesforceConnectionNotFoundException | An error occurred when the external session ID was not used or the Salesforce connection was not configured correctly. |