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.