Its my first time posting here.
I am trying to integrate (connect) ODK Central submissions directly to cloud based SQL server. Note: we are using ODK Central cloud service.
I tried using the OData links to connect either through Python or RStudio then to SQL but it involves manually work to refresh the data.
Questing, is there a direct API to directly pull data from ODK Central Server to SQL server? Just like connecting ODK Central directly to Power BI using OData link (his is what I always do).
Thank you in adavance for your assistance.