topic Re: PROC HTTP in SAS Procedures

PROC HTTP for Polygon.io Stocks API

LOLO12 — Sun, 27 Feb 2022 14:30:47 GMT

I'm trying to import data from this site

https://polygon.io/docs/stocks/getting-started

by SAS viya or SAS Window.

I have tried few codes and was not successful.

Re: PROC HTTP

Reeza — Sat, 26 Feb 2022 02:57:17 GMT

Please include any code you've tried.

Assuming you're doing something like this: https://blogs.sas.com/content/sasdummy/2018/01/16/hide-rest-api-tokens/

Re: PROC HTTP for Polygon.io Stocks API

ChrisHemedinger — Sun, 27 Feb 2022 14:31:04 GMT

I signed up for an API key (free) so I could try this. In SAS it's straightforward. Here's my code using their sample call:

filename resp temp; proc http url="https://api.polygon.io/v2/aggs/ticker/AAPL/range/1/day/2021-07-22/2021-07-22?adjusted=true&sort=asc&limit=120" out=resp oauth_bearer="your-api-key"; run; libname data json fileref=resp; proc print data=data.results; run;

Output:

Instead of the OAUTH_BEARER option (shorthand for the OAuth pattern), you can also use the HEADERS statement:

proc http url="api-call" out=resp; headers "Authorization" = "Bearer your-auth-key"; run;

Re: PROC HTTP for Polygon.io Stocks API

LOLO12 — Wed, 02 Mar 2022 19:50:23 GMT

I tried this code and still not working

proc http
url="https://api.polygon.io/v2/aggs/ticker/AAPL/range/1/day/2021-07-22/2021-07-22?adjusted=true&sort=asc&limit=120"
out=resp;
headers
"Authorization" = "Bearer <token>";
run;

Re: PROC HTTP for Polygon.io Stocks API

Reeza — Wed, 02 Mar 2022 18:28:13 GMT

Delete your token from the message.

Re: PROC HTTP for Polygon.io Stocks API

ChrisHemedinger — Wed, 02 Mar 2022 19:58:34 GMT

Can you make any PROC HTTP calls to the internet in SAS? Try the steps in this blog post. You might need to specify a proxy host.