Importing ODK Central's OData Feed

[Anthony J. DeMattee]

Is there a way to import ODK Central's OData Feed into Stata? https://docs.getodk.org/central-api-odata-endpoints/

There are packages for Excel, Power BI or Tableau, R, and Python, but nothing for Stata. I'm trying to think of a simple way to do this because my current solution is inelegant:

1. Setup Excel Power Query to import OData into XLS
2. Use Refresh to update XLS worksheet with latest OData
3. Save XLS
4. Use Stata -import excel- to pull XLS data into Stata.

The above works, but I'd rather save steps if possible. Thanks in advance for your help!

[George Ford]

maybe?

https://github.com/PovertyAction/odkmeta

[Anthony J. DeMattee]

Good tip, George, but it's not exactly what I need. -odkmeta- uses the static survey and choicesworksheets of XLSForm to make the static data usable--e.g., imports value labels, attaches labels to variables,

What I'm trying to do is pull live data from the OData API like MSFT, Tableau, R, and Python can do as described here https://docs.getodk.org/central-api-odata-endpoints/.