Retrieving data from the kobo rest api

Punya_Sapkota · September 12, 2018, 11:46am

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.

github.com

ppsapkota/kobohrtoolbox/blob/master/R/r_func_ps_kobo_utils.R

'-
***********************************************
Developed by: Punya Prasad Sapkota
Last Modified: 23 May 2018
***********************************************
#---USAGE
#--TWO Sections
#Section 1
#-----KoBo data Access using API v1
#-----https://kc.humanitarianresponse.info/api/v1
#Section 2
#-----new KoBo KPI
-'
#--Updated to KPI (new KoBo API download)
#user names and password to be loaded from external authenticate file - this approach to be checked

###--------SECTION 2---KPI---------
#---Upload form in NEW KoBo toolbox--------
#Import your form first (POST to https://kobo.humanitarianresponse.info/imports/)
#which will create a new asset in KPI which you can then deploy

This file has been truncated. show original

github.com

ppsapkota/kobohrtoolbox/blob/master/R/00_1_r_ps_kobo_export_data.R

'----
***********************************
Developed by: Punya Prasad Sapkota
Last modified: 15 July 2018
***********************************
#---USAGE
#-----Exporting CSV data to external XLSX file
#-----Exports data from the multiple forms in the account
----'

source("./R/91_r_ps_kobo_library_init.R")
#----------
##loop through each form and fetch data for individual form and export to CSV
#read list of forms in the KoBo account - list of forms created with 'kobohr_getforms_csv' function
#--EXPORT data to individual csv files
#d_formlist_csv <-read_excel("./Data/ochaturkey1_formlist.xlsx",sheet=1) #TUR
#d_formlist_csv <-read_excel("./Data/syriaregional1_formlist.xlsx",sheet=1) #JOR
#d_formlist_csv <-read_excel("./Data/syriaregional2_formlist.xlsx",sheet=1) #DAM
d_formlist <-read_excel("./Data/syriaregional3_formlist.xlsx",sheet=1) #TurkeyXB MSNA2018

This file has been truncated. show original

Best regards,

Punya

···

On Wednesday, September 12, 2018 at 9:15:39 AM UTC+3, Michael Bukachi wrote:

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