Proc HTTP

AlonsoSalazar — Mon, 24 Feb 2020 18:51:39 GMT

Our company migrated to SAS EG on Unix. We use proc http to download sharepoint list data but in SAS EG we get 401 UNAUTHORIZED.

Below is my code:

%let xmlfile = track.xml;
filename listout "/home/user/Temporary/&xmlfile" encoding="UTF-8";
filename request temp;
proc http out = listout
url = 'https://mysiteaddress/ReportData/_vti_bin/owssvr.dll?Cmd=Display&List={listid}&View={viewid}&XMLDATA=TRUE'
method = "get"
webusername="***"
webpassword="***"
webauthdomain="RB"
auth_negotiate;
run;
filename xx temp; libname xx xmlv2 "/home/user/Temporary/track.xml" automap=replace xmlmap=xx;
proc copy in=xx out=work; quit;

This code works perfectly fine on PC SAS without the authentication info. I am trying to determine if I am missing something in my code or if there is simply a block on our server.

Re: Proc HTTP

Tom — Mon, 24 Feb 2020 19:01:33 GMT

What software is mysiteaddress running? Is it some Microsoft specific tool like Sharepoint?

Re: Proc HTTP

AlonsoSalazar — Mon, 24 Feb 2020 20:53:54 GMT

That is just the URL to our internal sharepoint site.

Re: Proc HTTP

AlonsoSalazar — Mon, 24 Feb 2020 20:54:31 GMT

It is sharepoint 2010

topic Re: Proc HTTP in New SAS User

Proc HTTP

Re: Proc HTTP

Re: Proc HTTP

Re: Proc HTTP