Connector Improvement: Update Salesforce fivetran_formula table to include formulaTreatBlankAs
We need access to the formulaTreatBlankAs property from the custom field metadata for formula fields. Currently, there appears to be no method to get that information through a Fivetran connector, it would be helpful if either:
1. The formulaTreatBlankAs property can be added to the fivetran_formula table for Salesforce connections
or
2. The CustomField Metadata object (which contains this field) from the tooling API can be added as a selectable table in the connector schema.
-
Official comment
Hi Jonas,
We recently added support for several tables objects from the Tooling API, but not the CustomField object. I will check with our team about supporting this object as well. I'll keep you posted here.
Best,
Sadie
-
Thanks Sadie!
I think the most preferable option here would be to add CustomField Metadata as a replicable table (or set of tables) since there are other properties like summarizedField and summaryFilterItems that would very helpful to have as well https://developer.salesforce.com/docs/atlas.en-us.254.0.api_meta.meta/api_meta/customfield.htm and https://developer.salesforce.com/docs/atlas.en-us.254.0.api_meta.meta/api_meta/customfield.htm#filteritem
Please sign in to leave a comment.
Comments
2 comments