flipsidecrypto⚡️ LQ / Helius LiveQuery Function Guide
999
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
›
⌄
-- Helius 🤝 Flipside LiveQuery Function Guide
-------------------------------------------------------------------------
-- The Helius LiveQuery integration enables you to retreive data from
-- Helius's API directly in Flipside using SQL.
-- #️⃣ Function Schemas:
-- `helius_apis.*` -- query balances, token metadata, apis etc.
-- `helius_das.*` -- query the Digital Asset Standard (DAS) Api
-- -----------------------------------------------------------------
-- 🚨 WARNING 🚨
-- To run these examples you must associate your Helius API Key
-- with your Flipside Account here:
-- https://flipsidecrypto.xyz/livequery/helius
-- ======================================================================
--
-- ⚡️ Helius API Functions
-- schema: `helius_apis`
-- docs: https://docs.helius.xyz/solana-apis
--
-- ======================================================================
--
-- #️⃣ helius_apis.parse_transactions
-- https://docs.helius.xyz/solana-apis/enhanced-transactions-api/parse-transaction-s
--
SELECT
helius_apis.parse_transactions(
'mainnet', -- the network, 'mainnet' or 'devnet'
[
'5u5S6yWN5wJkEDr3hKeqF3Y8nWcyWaZDboEnpfUuAw1zcvbvevs58rEfCpN6VkfxaS4N8RCMkBcyhxBFs3eoL4U4',
'2bWLiRSA8GCh7UNEpiZdgsh2BMxZwKawk8ND4Z3iWrqDZE6JQk69n9WoCU9rKDrgWHw6qV25g8UBMJYddRJRHR9v'
] -- your transactions
) as resp
Run a query to Download Data