zakkisyedDegen Tips
    Updated 2024-04-02
    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