How to use API password and API key

[eramirez]

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

[AhmedAl_Attar]

Hi @eramirez 

Have a look at these three papers

• REST at Ease with SAS®: How to Use SAS to Get Your REST
• The ABCs of PROC HTTP
• REST Just Got Easy with SAS® and PROC HTTP

They should have what you are looking for and more

[eramirez]

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

[ChrisHemedinger]

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;