Get Started
Query external APIs, combine with Flipside data, directly in SQL
LiveQuery enables you to query any API directly within a Flipside SQL Query, from nodes to your favorite crypto data providers.
This gives you the power to remix data and generate unique insights beyond Flipside's curated data sets as well as leverage real-time updates directly from blockchain nodes.
If you're already writing SQL at Flipside you already have access to the power of LiveQuery.
Examples
Seaport: Real-time Orders
Retrieve the latest Seaport Orders directly from an Ethereum Node.
WETH Pool Balances
Retrieve the real-time WETH balance for the top WETH pools by volume over the past 1 week.
Query TheGraph
Retrieve the TVL for the top 500 UniswapV3 Pools on Polygon using LiveQuery and TheGraph
Check out more examples here:
FunctionsAdd-On Setup Guides
Add-Ons provide a secure means of incorporating your API keys for third-party data sources like blockchain nodes or cryptocurrency data APIs. This functionality enables you to run and share your queries while ensuring your API secrets remain undisclosed to other users.
We're excited to announce that additional third-party cryptocurrency data add-ons are on the horizon! Until then, explore our detailed, step-by-step examples or link your QuickNode account to use LiveQuery for querying blockchain nodes.
Note if you publish a dashboard that contains LiveQuery-powered queries users that refresh your dashboard will trigger queries against the Add-ons you have integrated.
Last updated