How Can I Determine When Fivetran Used a REST API Call or a Bulk API Call?

Question

Fivetran uses both the Salesforce REST API and the Bulk API to sync Salesforce data. How can I determine when Fivetran used either call to sync data?

Environment

• Connector: Salesforce
• Connector: Salesforce Sandbox

Answer

To see the list of REST API and Bulk API calls we used, go to the FIVETRAN_API_CALLS table in the Salesforce schema in your destination.

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

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

NOTE: 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, use the following query:

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