Using API to obtain to excel with variable labels

Byabasheija · February 7, 2020, 11:25am

I have entered data in kobo and would like to export to excel using the API route but I want the variable names to be replaced with the labels since they have a different notation at entry on the server. How can I get the values entered with their labels through this?

iker.montes · February 10, 2020, 9:41am

I do al follows:
You need to change the sharing settings of your form for this to work ( caution with sensitive data)

Then I use:
https://kc.humanitarianresponse.info/“USERNAME”/reports/“FOMR ID”/export.csv

to obtains the lables in the default languague…
of if the lang you need is called "::English (en)"

https://kc.humanitarianresponse.info/“USERNAME”/reports/“FOMR ID”/export.csv?lang=English (en)

then query with Power query or PowerBi