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.
Comments
Please sign in to leave a comment.