topic Re: How to use API password and API key in SAS Programming

How to use API password and API key

eramirez — Fri, 19 Sep 2025 20:38:34 GMT

Hi,

I'm using the json libname engine with proc http to get data from a secure website. I have the basic code working fine and I have a username and password to access the website, but now I have an API password and API key that I have to use now and can't find any documentation on how to incorporate it.

filename out "C:\temp";

%let url =https://
%put url = &url;

proc http
url="&url"
method="get" out=out
WEBUSERNAME="&user"
WEBPASSWORD="&PW"
AUTH_BASIC;
run;

libname test JSON fileref=out;
filename mymap "C:\temp\test.map";
........

where do I add in the API password and API key or do I need the API password?

sorry if this is basic, but I searched and found a lot of stuff for tokens, which are different than keys from what I read. I read you can add the key to the URL or you can specify it in headers statement. I feel like I'm close just nothing seems to be working.

if you can direct me to any documentation that would be great also.

thanks

Enrique

Re: How to use API password and API key

AhmedAl_Attar — Sat, 20 Sep 2025 02:13:38 GMT

Hi @eramirez

Have a look at these three papers

They should have what you are looking for and more

Re: How to use API password and API key

ChrisHemedinger — Mon, 22 Sep 2025 13:22:55 GMT

If your API uses OAuth2 style tokens, you can use the special oath_bearer= option on PROC HTTP with your token. It's basically shorthand for "Authorization: Bearer your-oauth-token" in the HTTP header.

Ex:

proc http url= "your-api-call" method="GET" out=resp oauth_bearer="&access_token"; run;

For other token styles that use HTTP headers, use the HEADERS statement in PROC HTTP. It uses a name-value pair syntax like this:

proc http url="https://your-api-query" method="GET" out=resp ; headers "Authorization"="Bearer &authtoken." "session-key"="&sessionkey." ; run;

Re: How to use API password and API key

eramirez — Tue, 23 Sep 2025 21:02:50 GMT

Thank you for the references, I did know of one of them already, but the other two seem promising.