Note
To create a Salesforce export, see Export data from Salesforce. While creating an export, select Bulk API 2.0. It manages high-volume data from Salesforce.
When you create or update Salesforce export to Bulk API 2.0, note that Bulk API 2.0 does not support the below:
-
Compound fields in SOQL queries. Ensure to query the individual components of compound fields. Example: Address Compound Fields, Geolocation Compound Fields.
-
Attribute fields. Use REST API to use attribute fields.
-
Aggregate functions. Example: Sum(), Count(), ALL(), queries with GROUP BY, LIMIT, ORDER BY, OFFSET, or TYPEOF clauses.
-
Parent-to-child relationship queries are not supported. However, child-to-parent relationship queries are supported.
-
Attachments and Blob fields
-
There are certain data type differences in Bulk API 2.0 compared to REST API that might affect import mapping.
API type
REST
Bulk API 2.0
Currency
100
100.0
datetime
2024-04-16T19:00:00.000+0000
2024-04-16T19:00:00.000Z
Percent
10
10.0
Number
23
"23.0"
Roll-Up Summary
0
"0.0"
Empty field values
null
" "
-
The Salesforce connector in Bulk API 2.0 does not support preview.
-
To add fields (using dropdown values) to the import or lookup criteria/mappings, you should either populate mock output data in the export or initially map the fields using the REST API and then update the export to Bulk API 2.0.