How to use API token in PROC HTTP: climate data

[Gigiwen]

I've read some articles on the forum but did not find the solution. My key problem is in understanding the technical specification provided on the following webpage and how to embed into SAS code:

https://www.ncdc.noaa.gov/cdo-web/webservices/v2#gettingStarted

In particular, it says the usage of token is:

curl -H "token:<token>" "url"
$.ajax({ url:<url>, data:{<data>}, headers:{ token:<token> } })

I've requested the token. Tried the following code:

%let mytoken =BgGrhHFjqqfXkZugQhzPSsBSEanFm; *API token;
filename trial temp;
proc http 
out= trial verbose
method="GET" 
url= "https://www.ncei.noaa.gov/cdo-web/api/v2/location?datasetid=GHCND"; 
Headers
"Authorization" = "Bearer &mytoken.";
run; 

It tuns out "400 Bad request."

Any help? or guidance? 

[ChrisHemedinger · Accepted solution]

A couple of changes needed. According to the doc, the header should include "token: <your token>" -- it's not an OAuth style "Authorization: Bearer <token>".

Second, the endpoint is "locations", not "location".

%let token=your-token-value;
filename resp temp;
proc http
 method="GET"
 out=resp
 url="https://www.ncei.noaa.gov/cdo-web/api/v2/locations?datasetid=GHCND";
 headers 
  "token" = "&token.";
run;

libname data JSON fileref=resp;

proc print data=data.results;
run;