Bulk import records into a Salesforce object from a CSV file. Uses Bulk API 2.0.
Description for data import bulk
You can use this command to import millions of records into the object from a file in comma-separated values (CSV) format.
All the records in the CSV file must be for the same Salesforce object. Specify the object with the --sobject flag.
Bulk imports can take a while, depending on how many records are in the CSV file. If the command times out, the command displays the job ID. To see the status and get the results of the job, run "sf data import resume" and pass the job ID to the --job-id flag.
For information and examples about how to prepare your CSV files, see "Prepare Data to Ingest" in the "Bulk API 2.0 and Bulk API Developer Guide" (https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/datafiles_prepare_data.htm).
Flags
| Flag Name (Long) | Flag Name (Short) | Description |
|---|---|---|
| <code>‑‑api‑version</code> | N/A | Type: Value<br><br>Override the api version used for api requests made by this command |
| <code>‑‑column‑delimiter</code> | N/A | Type: Value<br>Valid Values: BACKQUOTE, CARET, COMMA, PIPE, SEMICOLON, TAB<br><br>Column delimiter used in the CSV file. |
| <code>‑‑file</code> | <code>‑f</code> | Type: Value<br>Required<br><br>CSV file that contains the Salesforce object records you want to import. |
| <code>‑‑flags‑dir</code> | N/A | Type: Value<br><br>Import flag values from a directory. |
| <code>‑‑json</code> | N/A | Type: Boolean<br><br>Format output as json. |
| <code>‑‑line‑ending</code> | N/A | Type: Value<br>Valid Values: CRLF, LF<br><br>Line ending used in the CSV file. Default value on Windows is CRLF; on macOS and Linux it's LF. |
| <code>‑‑sobject</code> | <code>‑s</code> | Type: Value<br>Required<br><br>API name of the Salesforce object, either standard or custom, into which you're importing records. |
| <code>‑‑target‑org</code> | <code>‑o</code> | Type: Value<br>Required<br><br>Username or alias of the target org. Not required if the target-org configuration variable is already set. |
| <code>‑‑wait</code> | <code>‑w</code> | Type: Value<br><br>Time to wait for the command to finish, in minutes. |
Examples for data import bulk
Import Account records from a CSV-formatted file into an org with alias "my-scratch"; if the import doesn't complete in 10 minutes, the command ends and displays a job ID:
sf data import bulk --file accounts.csv --sobject Account --wait 10 --target-org my-scratch