Download SOQL Bulk Job Results

This activity helps the user to download the results of a SOQL bulk job from a Salesforce account, retrieving the queried data in CSV format.

Properties

Configuration

Each activity requires a connection with Salesforce authentication. Once you select the respective project name where Salesforce has been authenticated, the activity will automatically retrieve the available connections for that project.

Below are the properties available after the project has been integrated:

Salesforce: * This parameter indicates the account name associated with the integration.

Input

Job Id: *Specifies to provide the unique Job ID from which details need to be retrieved. It accepts values in the “String” datatype and provides multiple options for selecting the ID:

1. Open in Expression Editor: Enter the Job ID manually in “string” format or use a variable which contains the ID. 
2. Clear Values: Removes existing values and allows you to enter a new one.

Download Location: Specifies the system path where the results should be downloaded, and it accepts values in “String” datatype.

File Name: Specify the name of the file to be downloaded and it accepts values in “String” datatype.

Overwrite: Enables overwriting of existing files with the same name in the specified location. By default, this option is not selected.

MISC

Display Name: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Download Status: *It helps to return the status of the file that has been downloaded with the results from the job execution in “Boolean” datatype.

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.