Missing columns in already existing table "expense_group_configuration" # 382782
Connector name: landed_concur
Table name: expense_group_configuration
API documentation link:
https://us.api.concursolutions.com/api/v3.0/expense/expensegroupconfigurations?user=ALL
Additional details:
Creating feature request based on conversation # 382782:
The expensegroupconfiguration API endpoint does return fields like Name, AttendeeListFormID, AttendeeListFormName, and AttendeeTypes — however, these are not currently synced to any destination table. This is due to how the connector was implemented:
- Name, AttendeeListFormID, AttendeeListFormName — these fields are not mapped in the connector's data model, so they are silently dropped when the API response is parsed.
- AttendeeTypes — this field is present in the model but explicitly excluded from syncing, and the connector does not write it to any destination table.
- There is no expense_group_configuration destination table at all — the endpoint is used only as a passthrough to extract nested data (payment types, policies, and expense types), which are synced to their own tables as mentioned previously
Note: Attendee type data is available in the attendee_type table, but it comes from a separate dedicated endpoint, not from the expense group configuration.
This is a gap in the connector's current implementation, not a data loss issue. Hence, you will have to raise this as a feature request via the Feature Request Portal so that you can have direct communication with our Product team and check the current status of your request.
All columns required those are getting extracted from https://us.api.concursolutions.com/api/v3.0/expense/expensegroupconfigurations?user=ALL. Kindly help to get all column to migrate existing pipeline to fivetran table.
Thanks,
Sonu Kumar
Please sign in to leave a comment.
Comments
0 comments