| description |
|---|
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.
{% embed url="https://www.loom.com/share/da2957d686804f8ca4e1dac4c5688411?sid=57459c86-f36d-41a2-9d3b-60c37ef1b9d4" %}
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.
SELECT * FROM table(ethereum_mainnet.tf_latest_contract_events_decoded(<address>))If you're already writing SQL at Flipside you already have access to the power of LiveQuery.
| Seaport: Real-time Orders | Retrieve the latest Seaport Orders directly from an Ethereum Node. | seaport-real-time-orders.md | |
| WETH Pool Balances | Retrieve the real-time WETH balance for the top WETH pools by volume over the past 1 week. | weth-pool-balances.md | |
| Query TheGraph | Retrieve the TVL for the top 500 UniswapV3 Pools on Polygon using LiveQuery and TheGraph | general-evm-node-queries.md |
Check out more examples here:
{% content-ref url="add-ons/examples/" %} examples {% endcontent-ref %}
{% hint style="info" %} 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. {% endhint %}
{% content-ref url="add-ons/quicknode-setup-guide.md" %} quicknode-setup-guide.md {% endcontent-ref %}
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.
{% hint style="danger" %} 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. {% endhint %}