Walkthrough for Bulk Insert

This walkthrough guides you through the steps for creating a job to insert new records, uploading data for the job, checking status, and retrieving the results.

Read through all the steps in this walkthrough. You might also want to review the rest of this document to get a quick overview of Bulk API 2.0 calls and concepts.
Familiarize yourself with Workbench. This walkthrough uses Workbench to issue Bulk API 2.0 calls, but you can use any tool or development environment that can make REST requests.

Prepare your CSV formatted data or file.

For this walkthrough, copy the following CSV formatted list of accounts and paste it into the request body as described in Step #3. The first row of the CSV formatted data lists the field names for the object you're working with. Each subsequent row corresponds to a record that you want to insert.

1Name,ShippingCity,NumberOfEmployees,AnnualRevenue,Website,Description
2Garth Halfacre,Milano,2676,912260031,https://ft.com/lacus/at.jsp,"Lorem ipsum dolor sit amet"
3Francesca Braxton,Bodø,141603,896852810,http://webs.com/in/faucibus/orci/luctus/et/ultrices/posuere.json,"consectetur adipiscing elit"
4Angeles Urbain,Aykol,197724,257060529,http://odnoklassniki.ru/sapien.aspx,"sed do eiusmod tempor incididunt ut labore et dolore magna aliqua"
5Madaline Neubert,Xukou,190305,71664061,https://blogs.com/faucibus/orci/luctus/et/ultrices/posuere/cubilia.json,"Ut enim ad minim veniam"
6Shandra Weatherly,Varadero,121802,58284123,http://timesonline.co.uk/eu/magna.html,"quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat"
7Lesli Lebowitz,Hengdaohezi,190944,164329406,http://washingtonpost.com/vestibulum/proin/eu/mi/nulla/ac/enim.png,"Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur"
8Nan Stach,Quintães,80285,684173825,http://amazon.co.uk/potenti/cras/in/purus/eu.png,"Excepteur sint occaecat cupidatat non proident"

You can alternatively create a CSV file that contains the records you want to insert and specify the file using your API client software, such as Postman. The first row of the CSV file lists the field names for the object you're working with. Each subsequent row corresponds to a record that you want to insert.

Create a job.

To do any Bulk API 2.0 task, such as inserting or updating records, you first create a job. The job specifies the type of object, such as Account, that you're loading. The job also specifies the operation you're performing, such as insert or delete. Once you've created a job, you can use the resulting job ID in Bulk API 2.0 requests to close or abort (cancel) the job.
1. In Workbench, log in to your org.
2. Go to Utilities | REST Explorer. Use Bulk API 2.0 to create a job by issuing a POST request with the following details:
  Request Headers:
  1Content-Type: application/json; charset=UTF-8 2Accept: application/json
  URI:
  1/services/data/vXX.X/jobs/ingest/
  Request Body:
  1{ 2 "object" : "Account", 3 "contentType" : "CSV", 4 "operation" : "insert" 5 6}
  If you’re inserting an object other than Account, replace “Account,” in the request body with your object name.
  You should get a response that includes the job ID, with a job state of Open. You'll use the job ID in Bulk API 2.0 calls in the next steps. You’ll also use the URL in the contentUrl field of the response in the next step when you upload your data.
Upload your CSV data.
After creating a job, you're ready to upload your data. You provide record data using the CSV formatted data or file you created earlier.

In Workbench's REST Explorer, use Bulk API 2.0 to create a job data request with the CSV data. Issue a PUT request with the following details:
Request Headers:
1Content-Type: text/csv 2Accept: application/json
URI:
Use the URI provided in the contentUrl field of the response from step 1. The URI has a format similar to the following example.
1/services/data/vXX.X/jobs/ingest/jobId/batches/
Request Body:
1(Content of your CSV file)
For the Request Body, copy and paste the CSV data (as shown in Step #1) into Workbench's Request Body text field. With Bulk API 2.0, you can submit CSV data that does not in total exceed 150 MB in size (after base64 encoding).
You should get a response that includes the job ID still in the Open state. You could cancel the job at this point by using a PATCH to set the job state to Aborted.
Upload complete.
Once you're done submitting data, you can inform Salesforce that the job is ready for processing by closing the job.

In Workbench's REST Explorer, issue a PATCH request with the following details:
Request Headers:
1Content-Type: application/json; charset=UTF-8 2Accept: application/json
URI:
1/services/data/vXX.X/jobs/ingest/jobId/
Request Body:
1{ 2 "state" : "UploadComplete" 3}
Check the job status and results.
To get basic status information on a job, such as the overall job state or the number of records processed, use a GET request with the following details:
Request Headers:
1Content-Type: application/json; charset=UTF-8 2Accept: application/json
URI:
1/services/data/vXX.X/jobs/ingest/jobId/
Once a job has been completed and is in the JobComplete state (or Failed state), you can get details of which job data records were successfully processed by issuing a GET request with the following details:
Request Headers:
1Content-Type: application/json; charset=UTF-8 2Accept: text/csv
1/services/data/vXX.X/jobs/ingest/jobId/successfulResults/
You get a response that contains CSV data, with each row containing a record ID and information on whether that record was successfully processed or not. To get details on records that encountered an error during processing, use a GET request using the failedResults resource instead of the successfulResults resource.

Bulk API 2.0 and Bulk API Developer Guide

Walkthrough for Bulk Insert