How Can I Use the Fivetran REST API To Enable the Syncing of Formula Fields?

Question

How can I use the Fivetran REST API to enable the syncing of formula fields?

Environment

• Connector: Salesforce
• REST API

Answer

To allow existing Salesforce connectors to sync calculated or formula fields using the REST API, send a PATCH request to the Modify a Connector endpoint with the sync_formula_fields parameter set to true.

IMPORTANT: Our incremental sync may not extract all records affected by formula field changes. See our Salesforce formula field sync limitations for more information. As a result, we only recommend directly syncing formula fields if our Salesforce Formula Utils dbt or Salesforce Quickstart packages don't apply to your use case.