flipsidecrypto⚡️ LQ / Solscan LiveQuery Function Guide
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Solscan 🤝 Flipside LiveQuery Function Guide
-------------------------------------------------------------------------
-- The Solscan LiveQuery integration enables you to interact with
-- any Solscan API endpoint directly in SQL.
-- -----------------------------------------------------------------
-- 🚨 WARNING 🚨
-- To run these examples you must associate your Solscan API Key
-- with your Flipside Account here:
-- https://flipsidecrypto.xyz/livequery/solscan
-- ======================================================================
--
-- ⚡️ Solscan Functions
-- schema: `solscan`
-- public function docs: https://public-api.solscan.io/docs/#/
-- pro function docs: https://pro-api.solscan.io/pro-api-docs/v1.0
--
-- ======================================================================
--
-- #️⃣ solscan.public_api_get('url', 'query args')
-- Issue a 'GET' request to the public solscan api
--
-- examples:
--
SELECT solscan.public_api_get('/block/last', {'limit': 10}) as resp
--
-- #️⃣ solscan.pro_api_get('url', 'query args')
-- Issue a 'GET' request to the pro solscan api
-- 🚨 your api key must be permissioned to use the pro api
--
-- examples:
--
SELECT solscan.pro_api_get('/v1.0/nft/collection/list', {}) as resp
Run a query to Download Data