What is the problem? Please be detailed.
We are beta-testing ODK Central.
I am trying to pull data using the OData feed into either R (ideally) or excel for downstream analysis.
In R I am using the following script:
url <- "https://odk-survey.lshtm.ac.uk/v1/forms/AIM_Day_1.svc"
r <- GET(url, authenticate("USERNAME", "PASSWORD"))
But the output I get is not the dataset but instead:
So then I tried it more simply in Excel
Data>From Other Sources>OData Feed
Insert correct URL
Insert same username/password used in the R pull attempt
Then I get a 403 forbidden couldn't connect error
What username/password should I be supplying to the OData pulls? I presume my WebUser account that lets me login to central
What ODK tool and version are you using? And on what device and operating system version?
What you have you tried to fix the problem?
Tried both R and excel
Tried different R package but it didn't have option for supplying username/password to the OData pull so it didn't work