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

Community

Connector Improvement: Dates are unavailable for the financial_fee_component events

Answered
Becir Isakovic User

  • The issue that I'm facing with is to get the date for certain financial fee component. For example if you run this query, you will get what was the financial fee component but the problem is that I'm creating the monthly report on different types of fee components. But I cannot find the date, when I investigate the schema, it seems that the linked_to_id from the financial_fee_component table corresponds to the financial_service_fee_event _fivetran_id if for example the type for certain financial_fee_component is service_fee_event, that can be joined with the financial_event_group but stil I cannot get the date when certain fee component occured. Can you please assist.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Sandeep Preetam Saila Fivetranner

    Hi Becir,

    Apologies for the extremely delayed response, and thank you for your detailed explanation of the issue.

    You're absolutely right—at present, the financial_fee_component table doesn't include a posted_date or direct timestamp. While it can be joined to the financial_service_fee_event table using linked_to_id, that table also doesn’t currently expose a specific date field. The broader financial_event_group table contains date ranges, but those don’t provide the level of granularity you're looking for.

    That said, we’ve revisited the API documentation, and it looks like we may be able to support a date field for fee components after all. We’re now evaluating this internally and will keep you updated as we make progress.

    Thanks again for your patience, and apologies once more for the long delay.

    Best,
    Sandeep
    Technical Product Owner