Retrieving data from the kobo rest api

[Michael Bukachi]

How do I retrieve data for a form using the rest API in a different format, say csv or xls. The json format returned is quite difficult parse since each form might have different keys for the data field.

I noticed that on  the toolbox website, one could export as xls and was wondering if similar functionality was available via the API

[Punya Sapkota]

Dear Michael,

If you are interested to use R, here are the functions and working examples that download CSV data from KoBo using API and save it as xlsx.

https://github.com/ppsapkota/kobohrtoolbox/blob/master/R/r_func_ps_kobo_utils.R

https://github.com/ppsapkota/kobohrtoolbox/blob/master/R/00_1_r_ps_kobo_export_data.R

Best regards,

Punya

[ABOUDOU Rachidi]

Dear all,

I am using stata. It is very difficult for me to have database in stata format with labels and codes. Do we have a simple way to convert database from kobo to stata format with labels and codes?

Thanks in advance

ABOUDOU Rachidi, (Msc) Agricultural Economist, 

 

--
You received this message because you are subscribed to the Google Groups "KoBoToolbox Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to kobo-users+...@googlegroups.com.
To post to this group, send email to kobo-...@googlegroups.com.
Visit this group at https://groups.google.com/group/kobo-users.
For more options, visit https://groups.google.com/d/optout.

[Michael Bukachi]

Figured it out from your code. A call to the following url 'https://kc.kobotoolbox.org/api/v1/data/formid.xls' returns an excel document.