I'm trying to access a CSV served by one of our web APIs, but it's behind an authentication wall. When I use the traditional Open() statement, I'm told that the resource was not found, and passing the parameters using the https://user:password@website.compassword@website.com results in the same error.
I AM able to open the file with the Web Browser Box() function, which authenticates through a Windows popup, but I don't see a way to extract the data from that Web Browser Box into a JMP data table. Either way, I'd like to authenticate automatically and avoid the popup if possible.
Has anyone else opened files or web services that lie behind a login?
Thanks!
(JMP10, Windows7)