Salesforce Bulk Query
The Salesforce Bulk Query activity supports SOQL for Bulk API.
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 Query activity:
Field | Module Property? | Description |
---|---|---|
Name | No | The name displayed as the label of the activity in the process. |
Salesforce Connection | Yes | The path to the Salesforce shared resource.
Click the Choose/Create Default Resource icon to select a usable connection for the activity. |
Query Type | Yes | Select a query type from the drop-down list. The default type is Query. If you select Query from the drop-down list, the operation queues a job for retrieving existing records only. If you select QueryAll, the operation queues a job for retrieving all archived and deleted records. |
Format | Yes | Select one of the following format of the file types in which you want to view the Query Results on Salesforce server from the drop-down list: |
Salesforce Query | No | Displays the query to be executed against the specified object. Click
Query Builder to open the wizard to build your query or clear the existing query with
Clear Query.
For more information about the query builder, see Salesforce Query Builder. |
Prepared Statement | No | If you use a prepared parameter '?' in the query, then define the parameter name and its data type in the statement. You can add multiple prepared parameters using the add button. The data type Byte is not supported for the parameters in the query. |
Serial Processing | No | Select this option if you prefer to process batches serially. By default, Salesforce processes batches in parallel. |
Description
On the Description tab, you can enter a short description for the Salesforce Bulk Query activity.
Input
On the Input tab, you can specify input values for the Salesforce Bulk Query activity.
The following table lists the input elements on the Input tab of the Salesforce Bulk Query 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 Query activity:
Fault
On the Fault tab, you can find the error code and error message of the Salesforce Bulk Query 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. |