A tiny RCurl headache ;)

[This article was first published on Stats raving mad » R, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

As more and more data go online (plus we love Google Drive) we are forced to connect to our data over the net. We mostly do this via RCurl (but we could do this using RGoogleDocs as well).In that case all that is required to get the data into R is the two lines of code

require(RCurl)
myCsv<-getURL("https://docs.google.com/spreadsheet/pub?key=0AiD-
XfJ7BS9udG90TG9RZUQ2ZFZXMTRRNVZYU0Uxb1E&output=csv")

However, it's possible you end up with a message like this...All in all the point is that the data load *failed*.

Error in function (type, msg, asError = TRUE)  : 
  SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed

In that case the solution is to add the ssl.verifypeer = FALSE to the getURL function to override the default behavior of R.

myCsv<-getURL("https://docs.google.com/spreadsheet/pub?key=0AiD-
XfJ7BS9udG90TG9RZUQ2ZFZXMTRRNVZYU0Uxb1E&output=csv", ssl.verifypeer = FALSE)

Note: The above holds for RGoogleDocs too, given that the package depends on RCurl for the heavy lifting.



To leave a comment for the author, please follow the link and comment on their blog: Stats raving mad » R.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)