API v2 exports to R

[bonushenricus]

Greetings
i have a connection problem between R and kobo data.
The data in kobo has many repeats
so it is useful for me to export on my dashboard, in order to have a suitable csv for the particular case
and connect through the API
but I don’t understand how to use the form https: / YOUR_DOMAIN / exports /
where should I enter the token and the formID?
Thanks

[Kal_Lam]

@bonushenricus, sharing with you this previous post which should be helpful:

Retrieving data from the kobo rest api

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. 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 …

[bonushenricus]

Greetings
it’s a question of R I think
I can not understand
if I try

> library(httr) 
> rawdata <- GET("https://kf.kobotoolbox.org/api/v2/assets/am4K8tNeceqiaNbFqMimju/data/?format=csv", add_headers("Authorization : Token [my Token]"))`

does not work

[Josh]

Hi @bonushenricus, maybe try amending your add_headers(...) to:

add_headers("Authorization" = "Token [my Token]")