We are consuming the Expensify Preview connector.

We would like to have the functionality to add custom report field values to the report extract.

The custom field selectors are synchronized to the table today - policy_report_field - but the connector does not get the values of these into the report today.

I would propose either the connector dynamically picks up custom report fields and adds to the API call export_report_template (ttl file) using something along the lines: 

select distinct 'report.customField.' || replace(Name,' ','_') from source_fivetran_prod.expensify_prod.policy_report_field

Or have the ability in the connector advanced config to add 0 to many custom fields. In our case we specifically need to add "Department", "Purpose" and "Project Code", which could be entered something like "Department;Purpose;Project Code" and added to the ttl as

report.customField.Department

report.customField.Purpose

report.customField.Project_Code

thank you,

James