Forefront Takeffect1 copy
    Updated 2023-11-22
    -- forked from effect1 @ https://flipsidecrypto.xyz/edit/queries/f46034c9-41f3-4728-8801-8649af6356f0

    with

    base as (
    SELECT livequery.live.udf_api(
    'GET',
    'https://api.nearblocks.io/v1/nfts/ncon23.keypom.near/holders?page=1&per_page=25&order=desc',
    {'accept': 'application/json'},
    {}
    ) as response

    UNION

    SELECT livequery.live.udf_api(
    'GET',
    'https://api.nearblocks.io/v1/nfts/ncon23.keypom.near/holders?page=2&per_page=25&order=desc',
    {'accept': 'application/json'},
    {}
    ) as response

    UNION

    SELECT livequery.live.udf_api(
    'GET',
    'https://api.nearblocks.io/v1/nfts/ncon23.keypom.near/holders?page=3&per_page=25&order=desc',
    {'accept': 'application/json'},
    {}
    ) as response

    UNION

    SELECT livequery.live.udf_api(
    'GET',
    'https://api.nearblocks.io/v1/nfts/ncon23.keypom.near/holders?page=4&per_page=25&order=desc',
    {'accept': 'application/json'},
    Run a query to Download Data