Missing custom field ProjectStatus on Job table (Business Central)
Connector name: Microsoft Dynamics 365 Business Central
Table name: job (BC table Job, 167)
Column name: ProjectStatus (field no. 60024, Code[20])
API documentation link: n/a (custom field from the per-tenant extension "Minerva Imaging Customization")
Additional details:
The field ProjectStatus is shown on the Job card and Job List in BC, but it does not appear in the job table in Fivetran, also after reloading the schema. All columns in the schema are selected. Other custom fields from the same extension are synced fine (e.g. full_framework_agreement_value, parent_project_no), so I expect this field was added to the extension later. Could you add it to the job table, or tell me what is needed on our side (e.g. exposing it on an API page) for it to be synced?
Table name: job (BC table Job, 167)
Column name: ProjectStatus (field no. 60024, Code[20])
API documentation link: n/a (custom field from the per-tenant extension "Minerva Imaging Customization")
Additional details:
The field ProjectStatus is shown on the Job card and Job List in BC, but it does not appear in the job table in Fivetran, also after reloading the schema. All columns in the schema are selected. Other custom fields from the same extension are synced fine (e.g. full_framework_agreement_value, parent_project_no), so I expect this field was added to the extension later. Could you add it to the job table, or tell me what is needed on our side (e.g. exposing it on an API page) for it to be synced?
Please sign in to leave a comment.
Comments
0 comments