Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Salesforce Object Filter

Answered
Jacob Maddox User

There is a limitation on some objects in Salesforce (specifically looking at PicklistValueInfo) where the API requires certain filtering. Currently this is not possible with the fivetran connector so we can not replicate this table. Generally there is a workaround using the following system tables: FIVETRAN_PICKLIST_FIELD_VALUE, FIVETRAN_PICKLIST_FIELD and FIVETRAN_DEPENDENT_PICKLIST_RELATION. However, these do not include inactive values which are needed for some historical data.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Sadie Martin Fivetranner

    Hi Jacob,

    Thanks for pointing out the limitation of the FIVETRAN_ system tables when it comes to picklist values. We will explore whether it's possible to sync the PicklistValueInfo table and continue to monitor demand for this. In the meantime, please continue to rely on the system tables wherever possible,

    Best,

    Sadie