flipside

    Scroll_API
    eferScroll_API
    Updated 16 hours ago
    SELECT
    'Total 📜' AS "Point Type",
    COALESCE(SUM(value:"points"), 0) AS "Point"
    FROM (
    SELECT livequery.live.udf_api(
    CONCAT(
    'https://kx58j6x5me.execute-api.us-east-1.amazonaws.com/scroll/wallet-points?walletAddress=',
    LOWER('{{Address}}')
    )
    ) AS response
    ), lateral FLATTEN (input => response:data);

    UNION ALL

    SELECT
    COALESCE(value:"bridge_asset", 'Total 📜') AS "Point Type",
    COALESCE(value:"points", '0') AS "Point"
    FROM (
    SELECT livequery.live.udf_api(
    CONCAT(
    'https://kx58j6x5me.execute-api.us-east-1.amazonaws.com/scroll/bridge-balances?walletAddress=',
    LOWER('{{Address}}')
    )
    ) AS response
    ), lateral FLATTEN (input => response:data)
    Last run: about 16 hours agoAuto-refreshes every 24 hours
    Point Type
    Point
    1
    		Total 📜717.988586426
    2
    		USDC7.661556221
    3
    		ETH34.821236528
    4
    		gas-points667.44690783
    5
    		USDT8.058900319
    5
    121B
    3s