search

rdrr-io / rdrr-issues

rdrr.io issues
34 stars 7 forks source link

Cannot read csv file from google drive url #74

Open bdplum opened 3 years ago

bdplum commented 3 years ago

The file permissions are set to anyone with a link can view. The following code works when I run it from my machine id <- "1q6FYPScMCzeyrewxZn86GvZ2tAwVPQBP" data.test <- read.csv(sprintf("https://docs.google.com/uc?id=%s&export=download", id)) data.test

But when I run the code through rdrr.io () I get the following error text

Error in file(file, "rt") : cannot open the connection to 'https://docs.google.com/uc?id=1q6FYPScMCzeyrewxZn86GvZ2tAwVPQBP&export=download' Calls: read.csv -> read.table -> file In addition: Warning message: In file(file, "rt") : URL 'https://docs.google.com/uc?id=1q6FYPScMCzeyrewxZn86GvZ2tAwVPQBP&export=download': status was 'Couldn't resolve host name' Execution halted

matthiasbirkich commented 1 year ago

Dear bdplum, dear ihowson,

I also tried to get txt, csv or xls files to read by the browser version of R, which is very good and helpful! Thank you for that great work. I guess, that it will not work to read any file into the memory or a temp-file on the „\work“ directory. Is that true?

best regards Matthias