How to read a CSV in R from HTTP with AUTH

Question

I'm trying to read a CSV with R from a URL that has auth, I do have the password and everything I just need to know what to add to the command, btw my password does include the @ char so it messed up my scheme [1]

This is the command I'm trying:

products <- read.csv("http://username:pass@[email protected]/api/products_by_date.csv?start_date=2011-04-01&end_date=2011-04-01", head=TRUE)

My output is:

Error in file(file, "rt") : cannot open the connection
In addition: Warning message:
In file(file, "rt") : unable to resolve 'username'

[1] scheme://username:password@domain:port/path?query_string#fragment_id

Greg · Accepted Answer · 2011-05-10 18:56:23Z

6

you can try getURL in the RCurl package, which has the functionality to authenticate HTTP requests. see ?getURL for an example.

answered May 10, 2011 at 18:56

Greg

11.8k5 gold badges43 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read a CSV in R from HTTP with AUTH

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related