Create Bulk Upload Job

This activity allows the user to create a bulk upload job in Salesforce, enabling the insertion, updating, or deleting of large volumes of records.

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

Select Object: Specifies the Salesforce object on which the operation will be performed. You can either select an option from the drop-down menu or enter the value manually using the available options below,

1. Open in Expression Editor: Enter the object manually in “string” format or use a variable which contains the object
2. Force Refresh: Refreshes the selected account.
3. Clear Values: Clears the existing value and prompts to enter new value.
4. Deactivate Use Variable: Clears the assigned variable and enables selection from the drop-down.

CSV File: *Specifies the file path of the CSV containing the data. It accepts values in the String datatype.

1. Open in Expression Editor: Enter the CSV file path manually in “string” format or use a variable which contains the path. 
2. Clear Values: Clears the existing value and prompts to enter new value.
3. Browse: Allows to browse and select the file path from the system folder manually. 

CRUD Operation: Specifies to select the type of operation to be performed on the Salesforce object. Below are the options, 

Insert: Adds new records to the specified Salesforce object.
Update: Modifies existing records based on the provided identifiers.
Upsert: Inserts new records or updates existing ones if a matching identifier is found.
Delete: Removes specified records from the Salesforce object.

Column Delimiter: Specifies which delimiter option should be used from the provided csv file during the execution. Below are the options, 

Comma
Backquote
Caret
Pipe
Semicolon

Line Ending: Specifies the type of line break used in the CSV file to separate records during the execution. Below are the options,

LF (Line Feed): Uses \n as the line break.
CRLF (Carriage Return + Line Feed): Uses \r\n as the line break. 

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

JOB ID: *It helps to return the JOB ID as the result of the execution in “String” 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.