Data Loader Guide
jNote: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.
Data Loader Behavior with Bulk API Enabled
Enabling the Bulk API in Data Loader lets you load or delete a large number of records
faster than using the default SOAP-based API. However, there are some differences in behavior in
Data Loader when you enable the Bulk API. One important difference is that it allows you to
execute a hard delete if you have the permission and license.
| Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Performance, Unlimited, and Developer editions |
The following settings are not available on the page in Data Loader when the Use Bulk API option is selected:
| Setting | Description |
|---|---|
| Insert null values | This option enables Data Loader to insert blank mapped values as null values during data operations when the Bulk API is disabled. Empty field values are ignored when you update records using the Bulk API. To set a field value to null when the Use Bulk API option is selected, use a field value of #N/A. |
| Allow field truncation | This option directs Data Loader to truncate data for certain field types when the Bulk API is disabled. A load operation fails for the row if a value is specified that is too large for the field when the Use Bulk API option is selected. |