RESPONSE | SEQ | KEY | PATH | INDEX | VALUE | THIS | |
|---|---|---|---|---|---|---|---|
1 | {"bytes":665,"data":{"address":null,"audit_links":[],"audit_note":null,"... | 1 | bytes | bytes | 665 | {"bytes":665,"data":{"address":null,"audit_links":[],"audit_note":null,"... | |
2 | {"bytes":665,"data":{"address":null,"audit_links":[],"audit_note":null,"... | 1 | data | data | {"address":null,"audit_links":[],"audit_note":null,"audits":"0","categor... | {"bytes":665,"data":{"address":null,"audit_links":[],"audit_note":null,"... | |
3 | {"bytes":665,"data":{"address":null,"audit_links":[],"audit_note":null,"... | 1 | headers | headers | {"CF-Cache-Status":"EXPIRED","CF-RAY":"930dfcc23acf391a-IAD","Connection... | {"bytes":665,"data":{"address":null,"audit_links":[],"audit_note":null,"... | |
4 | {"bytes":665,"data":{"address":null,"audit_links":[],"audit_note":null,"... | 1 | status_code | status_code | 200 | {"bytes":665,"data":{"address":null,"audit_links":[],"audit_note":null,"... |
piperLiveQuery: Using flatten
Updated 2025-04-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with defillama_data AS (
SELECT live.udf_api(
'https://api.llama.fi/protocol/solana'
) as response
),
flatten_defillama_data AS (
SELECT
*
FROM defillama_data, table(flatten(response, '')))
SELECT *
FROM flatten_defillama_data
ORDER BY 1 DESC
Last run: about 2 months ago
4
17KB
2s