topic API data extraction issue in SAS Enterprise Guide

API data extraction issue

vijayagoggi — Mon, 10 Jul 2023 04:16:05 GMT

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;

Re: API data extraction issue

Kurt_Bremser — Mon, 10 Jul 2023 06:27:01 GMT

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:

Re: API data extraction issue

vijayagoggi — Mon, 10 Jul 2023 13:34:07 GMT

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

Re: API data extraction issue

vijayagoggi — Mon, 10 Jul 2023 13:40:26 GMT

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;

Re: API data extraction issue

AlanC — Mon, 10 Jul 2023 13:43:14 GMT

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