Data Loader Guide
jNewer Version Available
Data Loader Command-Line Operations
| Available in: Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Performance, Unlimited, Developer, and Database.com Editions |
When running Data Loader in batch mode from the command line, several operations are supported. An operation represents the flow of data between Salesforce and an external data source, such as a CSV file or database. You can use the following operations. Enter values in the process.operation parameter in lowercase
| Operation | Description |
|---|---|
| extract | Uses the Salesforce Object Query Language to export a set of records from Salesforce. The exported data is written to a data source. Soft-deleted records are not included. |
| extract all | Uses SOQL to export a set of records from Salesforce, including existing and soft-deleted records. The exported data is written to a data source. |
| insert | Loads data from a data source into Salesforce as new records. |
| update | Loads data from a data source into Salesforce, and updates existing records with matching ID fields. |
| upsert | Loads data from a data source into Salesforce. Existing records with a matching custom external ID field are updated. Records without matches are inserted as new records. |
| delete | Loads data from a data source into Salesforce, and deletes existing records with matching ID fields. Deleted records are moved to the Recycle Bin. |
| hard delete | Loads data from a data source into Salesforce, and deletes existing records with matching ID fields without first storing them in the Recycle Bin. |