Salesforce - Retry bulk job for failed records from CSV file action

This action retries failed Salesforce jobs in bulk from a CSV file.

This action is synchronous, meaning Workato waits for Salesforce to complete the bulk job processing before moving to the next recipe action.

Use this action after another Salesforce bulk action, such as Upsert records in bulk from CSV file, to resubmit failed records as a new bulk job. Refer to the Salesforce bulk operations guide for more information about bulk operations.

Configured Salesforce bulk retry actionConfigured Salesforce bulk retry action

Input

Input fieldsDescription
CSV content with failed recordsEnter a CSV content with failed records datapill from a previous Salesforce bulk operation action. This informs the action about the previous step's configuration. For example: what the CSV file looks like, what Salesforce object to write to, and how to map the CSV data into Salesforce fields.

Output

Output fieldsDescription
All records successfully processed?Specifies whether all CSV rows across Salesforce bulk jobs were processed successfully.
Number of records succeededThe total number of CSV rows that were successfully processed in Salesforce.
Number of records failedThe total number of CSV rows that encountered issues and were not processed in Salesforce.
Number of retried recordsThe total number of CSV rows that retried processing in Salesforce.
Number of records processedThe total number of CSV rows processed in Salesforce, excluding the header row.
CSV contents with failed recordsCSV file content containing CSV rows that encountered issues and were not processed. Two additional columns are added to this CSV file: sf__Error and sf__Id. Refer to the Salesforce documentation for more information.
CSV content with success recordsCSV file content containing CSV rows that were successfully processed in Salesforce. Two additional columns are added to this CSV file: sf__Created and sf__Id. Refer to the Salesforce documentation for more information.
Failed records report headerHeader information of failed record reports.
Success records report headerHeader information of successful record reports.
Salesforce bulk jobsAn object containing information about each Salesforce bulk job. Refer to the Salesforce bulk jobs section for more information.

Salesforce bulk jobs

Workato splits large CSV files into chunks and processes them as separate Salesforce bulk jobs to comply with Salesforce API size limits. Bulk operations output a Salesforce bulk jobs datatree that contains information about each chunk processed.

Salesforce bulk operation output datatree - list of bulk jobsSalesforce bulk operation output datatree - list of bulk jobs

Workato includes the aggregated results across all bulk jobs at the top of the output, outside of the Salesforce bulk jobs datatree.

Salesforce bulk operation output datatree - aggregated results across bulk jobsSalesforce bulk operation output datatree - aggregated results across bulk jobs

Last updated: