Need to download csv file from tableau web server

[jatavravi100]

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

[Kurt_Bremser]

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.

[jatavravi100]

And what about selecting the tableau server?

[jatavravi100]

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;

[Kurt_Bremser]

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.