Using API to obtain to excel with variable labels

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:“USERNAME”/reports/“FOMR ID”/export.csv

to obtains the lables in the default languague…
of if the lang you need is called "::English (en)"“USERNAME”/reports/“FOMR ID”/export.csv?lang=English (en)

then query with Power query or PowerBi

1 Like