Let’s discuss the some of the operations on the Mulesoft Saleforce connector associated with Bulk API v2.

1. Create job bulk api v2: This connector will pick up the payload in CSV format and upload the job while creating a job ID for ya. Your response will have:

{
    "id": "7508b00000cs0QTAAY",
    "operation": "update",
    "object": "Asset",
    "createdById": "0058b00000G13lcAAB",
    "createdDate": "2023-11-07T05:47:51.000+0000",
    "systemModstamp": "2023-11-07T05:47:51.000+0000",
    "state": "Open",
    "concurrencyMode": "Parallel",
    "contentType": "CSV",
    "apiVersion": 58.0,
    "contentUrl": "services/data/v58.0/jobs/ingest/7508b00000cs0QTAAY/batches",
    "lineEnding": "LF",
    "columnDelimiter": "COMMA"
}

2. Get job state bulk api v2: Use this connector to get the job current state of processing for the job. Values include:

• Open — The job has been created, and data can be added to the job.
• UploadComplete — No new data can be added to this job. You can’t edit or save this job, as Salesforce is processing it.
• Aborted — The job has been aborted. You can abort a job if you created it or if you have the “Manage Data Integrations” permission.
• JobComplete — The job was processed by Salesforce.
• Failed — Some records in the job failed. Job data that was successfully processed isn’t rolled back.

{
    "id": "7508b00000cs0QTAAY",
    "operation": "update",
    "object": "Asset",
    "createdById": "0058b00000G13lcAAB",
    "createdDate": "2023-11-07T05:47:51.000+0000",
    "systemModstamp": "2023-11-07T05:48:38.000+0000",
    "state": "JobComplete",
    "concurrencyMode": "Parallel",
    "contentType": "CSV",
    "apiVersion": 58.0,
    "jobType": "V2Ingest",
    "lineEnding": "LF",
    "columnDelimiter": "COMMA",
    "numberRecordsProcessed": 500,
    "numberRecordsFailed": 500,
    "retries": 0,
    "totalProcessingTime": 137,
    "apiActiveProcessingTime": 11,
    "apexProcessingTime": 0
}

3. Retrieve job successful results bulk v 2: Use this connector to get the successful records results. The result will look like

"sf__Id","sf__Created",(CSV payload)

4. Retrieve job failed results bulk v2: Use this connector to get the failed records results. The result will look like

"sf__Id","sf__Error",(CSV payload)

5. Retrieve job unprocessed results bulk v2: Use this connector to get the unprocessed records results. Results are not recorded for batches that exceed the daily batch allocation.The result will look like

(CSV payload that was not processed during the job)- order not maintained

6. Delete job bulk api v2: This connector will ask for JobID. If the current state is UploadComplete, JobComplete, Aborted, or Failed. The job can be deleted.

Return Code 204 for successful job deletion

7. Abort job bulk api v2: Use this if you wish to abort a job while it is in progress. You can abort a job if you created it or if you have the “Manage Data Integrations” permission.

You can also try the operations using the Salesforce Platform API for Bulk API 2.0.  Just fork it onto your user.

Use trailhead exercise Platform API Basics-Bulk API 2.0 to enhance your knowledge on Bulk API v2.0