topic Re: proc http Authorization error in batch mode in SAS Programming

proc http Authorization error in batch mode

KK-321 — Sun, 11 Aug 2024 08:04:33 GMT

I'm trying to get a list of the file names in a directory (&path) from azure. The following code works well in an interactive SAS session but encountering a "400 Bad Request" error in batch mode.
In the output.xml file, I get this message: <?xml version="1.0" encoding="utf-8"?><Error><Code>InvalidAuthenticationInfo</Code><Message>Authentication information is not given in the correct format. Check the value of Authorization header.
Why the azure_token is not working in the batch mode? Can someone please give some possible solutions?

Here is the code:

filename json_in temp;

data _null_;

file in;

run;

filename resp "X:\output.xml";

proc http

method="GET"

url= "&pathx.?restype=directory&include=timestamps&comp=list"

in=in

out=resp;

headers

"x-ms-file-extended-info" = "true"

"x-ms-version" = "2022-11-02"

"x-ms-file-request-intent" = "backup"

"Authorization" = "Bearer &azure_token.";

run;

Re: proc http Authorization error in batch mode

ChrisNZ — Sun, 11 Aug 2024 09:26:19 GMT

I suspect the batch job runs under a different userid that can't access Azure.

Re: proc http Authorization error in batch mode

KK-321 — Sun, 11 Aug 2024 10:04:01 GMT

The SAS session and batch are run on the same machine. Is it possible they are under different user ids? Do you know where and how can I find this id?

Re: proc http Authorization error in batch mode

ChrisNZ — Sun, 11 Aug 2024 10:14:25 GMT

Look how is the batch job is scheduled.

You can write &sysuserid to the log to see what user is used.

Re: proc http Authorization error in batch mode

Kurt_Bremser — Sun, 11 Aug 2024 12:33:42 GMT

Add

%put xxx&azure_token.xxx;

to your code and inspect/compare the logs.

Re: proc http Authorization error in batch mode

KK-321 — Mon, 12 Aug 2024 00:01:53 GMT

In SAS session, the token looks ok, but in batch mode, the macro is not resolved because of 400 bad request. The log shows xxxxxx.

Re: proc http Authorization error in batch mode

Kurt_Bremser — Mon, 12 Aug 2024 05:34:51 GMT

The fact that it is not resolved is the cause for the 400 error. Look where the macro variable is defined in your interactive session.

Re: proc http Authorization error in batch mode

ballardw — Mon, 12 Aug 2024 14:42:23 GMT

I don't see a variable &path. I do see &pathx

 url= "&pathx.?restype=directory&include=timestamps&comp=list"

I also do not see where &path or &pathx is set. So without that bit of info I would say that is the likely problem: the macro variable with the path is not assigned, or assigned incorrectly in batch mode.

Where is the LOG created when you run this? I see several things that SAS might complain about as undefined macro variables that are URL elements.