XLS data download using new KoBo API

Hi,

I am writing to know a solution to download data from KoBo using new API and R (or Python). Using the methods explained in https://github.com/tinok/kobo_api, I converted these code to R-script process. I am able to create exports, get the list of exports and get the lastest export for the deployed project. My R-script codes are available at https://github.com/ppsapkota/kobohr_apitoolbox.

My problem is that I am not able to download data from the export URL that is generated. When I have the export url (CSV or XLSX), it returns an error message ‘Private storage access denied” even if I pass username and password. With the same process I used, I can download other XLSX files from the web. Any help would be appreciated.

Best regards,
Punya

2 Likes

Hi all,
Is there anything new on this ? any endpoint or a way to use the new API to download xlsx files.
Thanks

It will be appreciated if anyone has a solution. to punya’s question. Anybody?

Hi @mowdou,

Have you tried out as suggested in the support article Pulling your data into Excel Power Query. It should be helpful!

GOOD DAY!

Thank you @Kal_Lam; for the tip, and it worked. However, what I was looking for is a way to actually pull in the survey questions into Power Query as column names. I want to see the questions because I want to know what the data inputted is for otherwise if I get the code name generated in Kobo during form design such as Q1, g1, or whatever; I can’t tell until I go to the questionnaire to see what Q1 correspond to what question…

I usually do this:
ALSO EXPLAINED IN A VIDEO TUTORIAL: HERE
The turorial is for POWERBI but POWERQUERY is the same.
Go to settings–>Sharing and click in “Anyone can view submissions made to this form” ( cautions with sensitive data)
Then, if you have no language specified (Default language), create your query to the following WEB:
https://kc.humanitarianresponse.info/“USERNAME”/reports/“ID_STRING”/export.csv

if you have defined othe languages (EX: “::english”) in your form:
https://kc.humanitarianresponse.info/“USERNAME”/reports/“ID_STRING”/export.csv?lang=english

Where “USERNAME” is: your account name
and “ID_String” is the +20 caract name of your form…when you click on it would be something like :“aPnv9qNPKT5HG4e8i9rR9n”

EXAMPLE: https://kobo.humanitarianresponse.info/#/forms/aPnv9qNPKT5HG4e8i9rR9n/landing


This metod gives you the answers and data in “Readable” language , instead of the names.
Does it help?

1 Like

Hi @nca_hum_div,

Thank you for sharing your knowledge and experience with the entire community! Expect the same in the upcoming days too!

GOOD DAY!

1 Like