How to use API token in PROC HTTP: climate data

Gigiwen — Wed, 07 Jun 2023 08:47:57 GMT

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?

Re: How to use API token in PROC HTTP: climate data

ChrisHemedinger — Wed, 07 Jun 2023 11:54:00 GMT

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;

topic Re: How to use API token in PROC HTTP: climate data in SAS Programming

How to use API token in PROC HTTP: climate data

Re: How to use API token in PROC HTTP: climate data