Re: API data extraction issue

vijayagoggi · Posted 07-10-2023 12:16 AM

I have tested API in postman then i got data.But same API i have tested in SAS EG with below code i am getting "<html><head><title>Error</title></head><body>Invalid Username/Password !</body></html>" this error. Please help me to resolve this issue

filename indarea "D:\D DRIVE\D drive Data\indarea.json";

filename indarea1 "D:\D DRIVE\D drive Data\indarea1.json";

proc http url="******"

AUTH_BASIC

in='{"primaryKeys":["21102" "03-Jul-2023" "03-Jul-2023"]}

method="POST"

ct='application/json'

WEBUSERNAME= "****"

WEBPASSWORD="***"

out=indarea;

run;

Kurt_Bremser · Posted 07-10-2023 02:27 AM

Your IN= option misses a closing single quote.

Whenever you get an ERROR or WARNING, or have other issues with your code, post the complete (all code and messages) log of the failing step by copy/pasting it into a window opened with this button:

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

vijayagoggi · Posted 07-10-2023 09:34 AM

Actually i have given single quotation also but getting this error "<html><head><title>Error</title></head><body>Invalid Username/Password !</body></html>"

vijayagoggi · Posted 07-10-2023 09:40 AM

filename indarea "D:\D DRIVE\D drive Data\indarea.json";

proc http url="******"

AUTH_BASIC

in='{"primaryKeys":["21102" "03-Jul-2023" "03-Jul-2023"]}'

method="POST"

ct='application/json'

WEBUSERNAME= "***"

WEBPASSWORD="***"

out=indarea;

run;

AlanC · Posted 07-10-2023 09:43 AM

If your webusername or password contains an '&' it may be resolving as a macro variable. Try putting them values in single quotes.

https://github.com/savian-net

API data extraction issue