zakkisyedDegen Tips
Updated 2024-04-02
9
1
2
3
4
5
6
7
8
9
›
⌄
with dune_data AS (
SELECT live.udf_api(
'https://api.neynar.com/v2/farcaster/cast?identifier=https%3A%2F%2Fwarpcast.com%2Fboeing747%2F0x6340b456api_key=[dune_key]','NEYNAR_API_DOCS'
) AS response
),
flatten_dune_data AS (
SELECT * FROM dune_data, table(flatten(response, ''))
)
SELECT * FROM flatten_dune_data ORDER BY 1 DESC
QueryRunArchived: QueryRun has been archived