Uploading data from excel to an existing KoBo form

I am trying to upload some data from excel to an existing kobo form.

I am trying using R, and simplified script for the test project is as follows -


url ← “https://kobo.unhcr.org/api/v2/assets/6a1c035d-a4f9-4e13-80c2-d9ca40c9acdb/data/


data ← list(
Name = “String Test Value”,
Age = 3,
Sex = “M”,
Country = “IRN”

json_data ← toJSON(data, auto_unbox = TRUE)

response ← POST(url,
body = json_data,
“Authorization” = paste(“Token”, “my_token”),
“Content-Type” = “application/json”

Check the status of the POST request


would appreciate if anyone have done it in R/SQL/SSIS would be great!

@zahirr, maybe this post discussed previously should help you solve your issue (it uses the POSTMAN approach):

I solved it using A python app.
I managed to migrate 1800 records from xlsx file to KOBo.