Kobo API get last submission (descending order)

User Support Data Management
, , , ,
1

Good day, colleagues!

I want to take last 900 submissions but using the following endpoint I got the first 900. Could you help me with the sort or something like that?

https://kobo.humanitarianresponse.info/api/v2/assets/ID/data/?start=0&limit=900

3

@slovak82, you could use sort={"<field name>": <order>} at the end of the URL, where <field name> is the question name as it appears in the API output, and <order> is 1 for ascending and -1 for descending. For example:

https://kf.kobotoolbox.org/api/v2/assets/abcdef@@@@@@ghijkl7890/data.json?sort={"_id": 1}
https://kf.kobotoolbox.org/api/v2/assets/abcdef@@@@@@ghijkl7890/data.json?sort={"_id": -1}
4

thank you so much!

1 Like