Connector Improvement: Ordway Subscription Versions
AnsweredThe Ordway connector cannot retrieve versions before the initial sync is started. The subscription plan table needs to be updated to allow all versions to sync using the prior version parameter. Without this update you cannot do accurate historical reporting.
Context:
After further research, I've found the connector does not support the necessary parameters to replicate previous versions for subscriptions. The subscription_plan table uses the List Subscriptions endpoint which does not have the prior_versions parameter to retrieve this data.
Currently, the connector can only replicate versions starting from the connectors creation and first sync. In order to capture previous versions for subscriptions, the prior_versions parameter needs to be applied to the API cURL which only the GET subscription endpoint supports. To retrieve the older versions, we'd have to run a request for each subscription separately.
To introduce this to the connector would require creating a new subscription_plan table design and/or create a new separate table (i.e subscription_versions). This would also cause increased incremental sync times if needed to call the api for each subscription.
-
Official comment
Hi Ally,
Thanks for the detailed inputs. This is something that makes sense to have in the connector. We have added this to the team's backlog and will keep you posted as we progress on this.
Please sign in to leave a comment.
Comments
1 comment