ODK Central retrieving all submission using REST API

Development
1

Hi there! I am new to ODK Central and am trying to use the API to retrieve all the submissions in JSON format, but am stacked and don't know how to proceed. Check this URL example
https://xxx/v1/projects/2/forms/vform/submissions
This API returns the following rather than return the contents of the submission

[{"instanceId":"uuid:e5bc7904-2a80-4595-9a03-433972ceda05","submitterId":7,"deviceId":"collect:6yUWDJZPufjx4MRO","createdAt":"2022-05-11T09:11:01.558Z","updatedAt":null,"reviewState":null},{"instanceId":"uuid:e0472ead-bfd3-46c1-b7da-691b731428f0","submitterId":7,"deviceId":"collect:6yUWDJZPufjx4MRO","createdAt":"2022-05-10T13:47:38.753Z","updatedAt":"2022-05-11T07:57:53.400Z","reviewState":"approved"},{"instanceId":"uuid:8f87793d-25b2-4f8c-826e-540d36eae138","submitterId":7,"deviceId":"collect:6yUWDJZPufjx4MRO","createdAt":"2022-05-10T12:29:22.633Z","updatedAt":"2022-05-11T07:58:13.476Z","reviewState":"approved"}]

But I can download the submissions in CSV format if the url is like this https://xxx/v1/projects/2/forms/vform/submissions.csv

Please help

2

You just forgot to ask for a csv export of the submissions :

Adding .csv.zip to you url should work.

1 Like