API to GET Kobo submissions using 'label' rather than value

User Support API
, ,
1

I am using the API to return submitted forms from Kobo from: https://kf.kobotoolbox.org/assets/xxx/submissions/

My question is how do I return the actual text form response (called ‘label’ in the API) rather that the ‘Value’ in the Kobo form (called ‘name’ in the API) These ‘Values’ are numbers and I cannot interpret them.

I see there are some lookup values (list_name, $kuid) but I’m hoping there is an easy way to just retrieve the text rather than having to write code to loop through all the JSON

image
image826×353 19.1 KB

2

After making your data public:
Settings–> Sharing–>
image

USE THIS GENERAL STRUCTURE:

Default Language:

https://kc.humanitarianresponse.info/“USER_ACCOUNT”/reports/“FORM_ID”/export.csv

Or other instance…

EXAMPLE of FORM_ID_IN_KOBOTOOLBOX: a5n9jp9qxyiKPfRNYq7KAt

If “english” is one of your languages… https://kc.humanitarianresponse.info/ USERNAME /reports/ FORM_ID_IN_KOBOTOOLBOX /export.csv ?lang=english

3 Likes
4

https://kc.humanitarianresponse.info/USERNAME** /reports/ FORM_ID_IN_KOBOTOOLBOX/export.csv?lang=english
and
https://kc.humanitarianresponse.info/api/v1/data/URLxls
Are all giving me the “404” NOT FOUND error.
Please how can I fix this?
Many thanks

5

Welcome back to the community, @nepctahni360! You should be able to do it as outlined in the post discussed previously: