flipsidecrypto⚡️ LQ / Blockpour 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
›
⌄
-- Blockpour 🤝 Flipside LiveQuery Function Guide
-------------------------------------------------------------------------
-- The Blockpour LiveQuery integration enables you to retrieve Blockpour's
-- curated API data directly in SQL.
-- -----------------------------------------------------------------
-- 🚨 WARNING 🚨
-- To run these examples you must associate your Blockpour API Key
-- with your Flipside Account here:
-- https://flipsidecrypto.xyz/livequery/blockpour
-- ======================================================================
--
-- ⚡️ Blockpour Functions
-- schema: `blockpour_utils`
-- docs: https://blockpour.readme.io/reference/getting-started-1
--
-- ======================================================================
--
-- #️⃣ blockpour_utils.get
-- Issue a GET request to the BlockPour API
--
-- example: Use the Token API to retrieve token metadata for USDC
-- (https://gateway.credmark.com/api/#/Token%20API)
SELECT
blockpour_utils.get('/v1/tokens/1/0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', {
'blockNumber': 17767007
}) as resp
--
-- #️⃣ blockpour_utils.post
-- Issue a POST request to the Credmark API
--
-- example: Use the Token API to run a Credmark Model
Run a query to Download Data