Kobotoolbox XLS value to Power Bi label through API connection with Json format

[mt_pin24]

Hello everyone,

I faced the issues of API connection with Json format. How can I convert the xls value of kobotoolbox to Power Bi label.

Thank you in advance if anyone in this community can help me.

[Kal_Lam]

Welcome back to the community, @mt_pin24! Have you tried this approach discussed previously?

API Export to Excel Drops Hyperlinks to Photos

@mark_ej, we will be updating our support document very soon. Till then, maybe you could follow the steps outlined below: Step 1: Open your survey project and then make some downloads (by specifying a name to the Save selection as ...) as shown in the image below: [image] Step 2: Now in a new tab, use the following API: https://[kpi]/api/v2/assets/{asset_uid}/export-settings/ Here, kpi refers to kobo.humanitarianresponse.info if you are using the humanitarian server else kf.kobotoolbox.o…