Articles in this section

Salesforce Bulk API 2.0 Guide

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

    " "

User experience differences

  • 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.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.