How Can I Map Destination Table Names to Salesforce Object Names?

Question

How can I map normalized destination table names to their corresponding Salesforce object name?

Environment

Connector: Salesforce

Answer

To map destination table names to Salesforce object names, use the Fivetran REST API Retrieve a Connection Schema Config endpoint: GET https://api.fivetran.com/v1/connections/{connection_id}/schemas.

The response includes each Salesforce object name and its corresponding name_in_destination value.