⚡️ LQ / Covalent LiveQuery Function Guide

flipsidecrypto⚡️ LQ / Covalent LiveQuery Function Guide

-- Covalent 🤝 Flipside LiveQuery Function Guide

-------------------------------------------------------------------------

-- The Covalent LiveQuery integration enables you to interact with

-- any Covalent API endpoint directly in SQL.

-- -----------------------------------------------------------------

-- 🚨 WARNING 🚨

-- To run these examples you must associate your Covalent API Key

-- with your Flipside Account here:

-- https://flipsidecrypto.xyz/livequery/covalent

-- ======================================================================

-- ⚡️ Covalent Functions

-- schema: `covalent`

-- function docs: https://www.covalenthq.com/docs/api/guide/overview/

-- ======================================================================

-- #️⃣ covalent.get('url', 'query args')

-- Issue a GET request to a Covalent Endpoint

-- examples:

SELECT covalent.get('/v1/1/block_v2/5000000/', {}) as resp;

-- #️⃣ covalent.post('url', 'body')

-- Issue a POST request to Covalent Endpoint

-- example

SELECT

covalent.post('/some/path/here', {

'foo': 'bar'

Run a query to Download Data