Get Successful, Failed, and Unprocessed Records with the Bulk Operations

For every bulk operation, the Salesforce REST application creates a job ID. Once you receive the reference bulk job ID in the final batch response, you can get the details of the records using the Get Successful Records, Get Failed Records, and Get Unprocessed Records operations available under the Bulk operation.

This use case provides an overview of how to request all the details of the successful records for the respective job.

This use case uses the following bulk operation:

• Get Successful Records: Requests all the details of the successful records for the respective job.

You can also request all details about the failed or unprocessed records using the following operations:

• Get Failed Records: Requests all the details of the failed records for the respective job.
• Get Unprocessed Records: Requests all the details of the unprocessed records for the respective job.

1. Create an application integration.
2. Drag the REST Adapter into the integration canvas.
3. Configure the REST Adapter.
4. Drag a Salesforce REST Adapter and configure it with the required bulk operation.
   1. On the Basic Info page, provide a name.
   2. On the Action page, select Perform Bulk Data Operations.
   3. On the Operations page, select Bulk, then select the required operation (for this example, Get Successful Records) in the Select an Operation field.
   4. Review your selections on the Summary page.
5. In the mapper for the Salesforce REST Adapter invoke connection, map the source jobid element to the target Job Id element.
   
   

   

   
   
6. Drag an FTP Adapter into the integration canvas.
7. Configure the FTP Adapter as follows:
   1. On the Basic Info page, provide a name.
   2. On the Operations page, select Write File from the Select Operation list.
   3. Select Binary from the Select a Transfer Mode list.
   4. Provide the output directory and file name pattern (.csv).
   5. On the Schema page, select No.
   6. On the Summary page, review your selections.
8. In the mapper for the FTP Adapter invoke connection, map the source Dir Path element to the target File Reference element.
   
   

   

   
   
9. Specify the tracking variable.
   1. Click Business Identifiers .
   2. Drag the required variable to use for the tracking reference (for this example, Input1 is selected).
10. Activate the integration.
    When complete, the integration looks as follows.