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?
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:
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