Extracting Cryptoquant data via JSON API

[jitb]

Hi,

Has anyone used proc http to extract data from the Cryptoquant site using their JSON API? I am completely new to this procedure and would like to know of some use cases, if possible. Thank you!

[sbxkoenk]

Hello,

I haven't done that, but it should be easy.

Start from here :

Reading data with the SAS JSON libname engine
By Chris Hemedinger on The SAS Dummy December 2, 2016
https://blogs.sas.com/content/sasdummy/2016/12/02/json-libname-engine-sas

with Simple JSON example: Who is in space right now?

Koen

[jitb]

Thank you, Koen. I will review this article.
Thanks again for giving me a start. I will post once I make some headway.

Jit

[jitb · Accepted solution]

I was able to form the correct code to access the cryptoquant data. Here is a sample of the code to get a list of all their API Endpoints. A token ID is required to access the data.

filename out temp ;
%let access_token = <Enter token id here> ;

************* DISCOVERY: Endpoints ****************************;

proc http OAUTH_BEARER="&access_token"
url="https://api.cryptoquant.com/v1/discovery/endpoints"
method="get"
out=out;

run;

libname crypto json fileref=out;

proc datasets lib=crypto; quit;
proc contents data=crypto.alldata; run;

**********************************************************;

[ademkalyir]

Many thanks!

[ademkalyir]

If you're looking into extracting Cryptoquant data via JSON API, I highly recommend checking out stakingy platform. It's a fantastic resource for tracking the best apy stablecoins and optimizing your crypto investments. With the volatile nature of the market, finding stable assets with high yields is crucial for maximizing returns. Stakingy provides comprehensive data on various stablecoins, allowing you to make informed decisions and leverage opportunities for passive income. Don't miss out on exploring this valuable tool to enhance your crypto portfolio.