How to Determine Whether Fivetran Used the Salesforce REST or Bulk API

Fivetran uses both the Salesforce REST API and the Bulk API to sync Salesforce data. To determine which type of API calls we used, query the FIVETRAN_API_CALLS table in the Salesforce schema in your destination.

To see the list of Bulk API calls, run the following query:

select *
from <salesforce_schema_name>.fivetran_api_call
where URI LIKE '%jobs%'
limit 100;

We use the Bulk API for historical syncs and high-volume incremental syncs. See our REST and Bulk API usage documentation for more information. However, we don't reflect the calls we use for historical syncs in the FIVETRAN_API_CALLS table.

To see the list of REST API calls, run the following query:

select *
from <salesforce_schema_name>.fivetran_api_call
where URI LIKE '%queryAll%'
limit 100;