Using the Kobo REST API (https://kc.kobotoolbox.org/api/v1/)

[jonathanjo]

… just a note that the https://[kpi-url]/submissions/ endpoint apparently doesn’t exist, returning HTTP 404 and The requested URL /submissions/ was not found on this server..

I confess it’s not clear to me at all if it’s even possible to get the data out with the “new” API.

User @roaima has a helpful post about how to get it with the v1 API, correcting the errors of the documentation:

Filtering API query results by date

Well. I’ve been digging some more, and in the interests of sharing my now working results, here is what I’ve found. There is an outstanding documentation bug reported well over two years ago at https://github.com/kobotoolbox/kobocat/issues/150, such that the operators are actually $gt rather than gt$, etc. The date field shown in the example is a red-herring. Rather, the field to be compared must exist in the dataset. I’ve been using _submission_time. The query must be URL-encoded. Here…