eferAPI_Usage
Updated 2024-07-03
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
›
⌄
with raw as (
SELECT
livequery.live.udf_api(
'POST',
'https://api.thegraph.com/subgraphs/name/messari/uniswap-v3-polygon',
{'Content-Type': 'application/json'},
{'query':'{\n liquidityPools(first: 200, orderBy: totalValueLockedUSD, orderDirection: desc) {
\n id\n totalLiquidity\n name\n
inputTokens { \n id \n symbol \n }}\n}',
'variables':{}
},
''
) as rawoutput
)
select
value:id as pool_address,
value:name as pool_name,
value:inputTokens[0]:id as token0_address,
value:inputTokens[1]:id as token1_address,
value:inputTokens[0]:symbol as token0_symbol,
value:inputTokens[1]:symbol as token1_symbol
from raw, lateral flatten(input => parse_json(rawoutput:data:data:liquidityPools));
QueryRunArchived: QueryRun has been archived