Salesforce: How Can I Distinguish Between Bulk API and REST API Calls?

Use Case/Scenario:

You have read our documentation on the methods Fivetran uses to ingest data from Salesforce.

You want to understand how many API calls Fivetran is making to Salesforce across the Bulk and REST APIs. 

Fivetran Recommendation:

• Query the ‘URI’ column in the ‘fivetran_api_calls’ table in the Salesforce schema
• Use the following parameters to distinguish between the endpoints:
  • Bulk API
    • where URI LIKE '%jobs%'
  • REST API
    • where URI LIKE '%query%'

If data on the REST API appears misleading, you can refine your query:

• where URI LIKE '%queryAll%'

Considerations:

• Given Fivetran only uses the Bulk API for historic syncs, you may not see any Bulk API calls appear in the ‘fivetran_api_calls’ table; this is expected functionality