topic Need to download csv file from tableau web server in SAS Software for Learning Community

Need to download csv file from tableau web server

jatavravi100 — Wed, 04 Jan 2023 11:40:02 GMT

Hi Team,

Can anyone guide me how can I download the csv file from tableau web server in SAS using SAS EG. When I say tableau web server that means while going through that path it asks credentials first and we need to enter server from the drop down.

for example:

https://etb-prod.****.com/#/site/Home/export.csv

in above example link, when it go through site it asks to enter web server name for tableau and then throw an error 400 Bad Request.

Please suggest some code so that i can download the export csv file

Re: Need to download csv file from tableau web server

Kurt_Bremser — Wed, 04 Jan 2023 12:01:03 GMT

The HTTP Procedure has options to supply credentials. After downloading, read the downloaded file. You can use a temporary file reference for this, so downloaded files don't clutter up your system.

Re: Need to download csv file from tableau web server

jatavravi100 — Wed, 04 Jan 2023 12:13:32 GMT

And what about selecting the tableau server?

Re: Need to download csv file from tableau web server

jatavravi100 — Wed, 04 Jan 2023 12:17:30 GMT

I did try the proc http with options webusername and webpassword but every timeI execute it says Bad request.

filename _bcin temp;
proc http
url = "https://etb-prod.****.com/#/site/Home/export.csv"
webusername = '*****'
webpassword='******'
;
run;

Re: Need to download csv file from tableau web server

Kurt_Bremser — Wed, 04 Jan 2023 13:55:04 GMT

The URL contains the server name. If you need to go through a proxy, the HTTP procedure documentation tells you how to do that.

We can only supply code for websites which are publicly accessible; if you need to keep parts of the access (servername, credentials) private, your best bet is to get in touch with SAS technical support, as they have an automatic NDA while supporting you.