I'm trying to import a SharePoint list that has a url such as:
"http://companyname.sharepoint.com/item1/item2/list.aspx"
Currently the code I'm using is:
res <- GET("http://companyname.sharepoint.com/item1/item2/list.aspx",
authenticate(username, password, type="any"))
http_status(res)
I can't pull the data because the output from http_status throws a 403 Forbidden:
$category
[1] "Client error"$reason
[1] "Forbidden"$message
[1] "Client error: (403) Forbidden"
Anyone have any experience with this and how to achieve reading the data into R. I cannot map the SharePoint to a local drive because this is going to be a job run on a server.