Data Query

{
  "attribution": [
    {
      "text": "Translated by Google",
      "url": "https://translate.google.com"
    }
  ],
  "price_usd": 0.5,
  "provenance": {
    "attempts": 1,
    "elapsed_ms": 340,
    "providers_used": [
      "coinbase-advanced-trade-public"
    ],
    "steps": [
      {
        "ms": 312,
        "ok": true,
        "provider": "coinbase-advanced-trade-public",
        "reason": "provider_timeout",
        "step": "quote"
      }
    ]
  },
  "receipt_id": "rcpt_9f1c2b3a4d5e6f70",
  "receipt_url": "/work/receipts/rcpt_9f1c2b3a4d5e6f70",
  "result": {
    "cache_hit": false,
    "columns": [
      "name",
      "n"
    ],
    "gib_processed": 0.012,
    "row_count": 5,
    "rows": [
      {
        "n": 4942431,
        "name": "James"
      }
    ],
    "sql": "SELECT name, SUM(number) AS n FROM `bigquery-public-data.usa_names.usa_1910_2013` GROUP BY name ORDER BY n DESC LIMIT 5",
    "total_rows": 5,
    "truncated": false
  },
  "status": "ok",
  "worker": "data.query"
}

# bash or zsh: see the payment challenge. Nothing is charged.
curl -sS -g -i -X POST 'https://hubvibe-io.com/work/data/query' \
  -H 'content-type: application/json' \
  --data-raw '{"sql":"SELECT name, SUM(number) AS n FROM `bigquery-public-data.usa_names.usa_1910_2013` GROUP BY name ORDER BY n DESC LIMIT 5"}'

# x402 v2 sends the challenge base64-encoded in the PAYMENT-REQUIRED header (v1 sends it in the body).
# To read the header:
curl -sS -g -o /dev/null -D - -X POST 'https://hubvibe-io.com/work/data/query' \
  -H 'content-type: application/json' \
  --data-raw '{"sql":"SELECT name, SUM(number) AS n FROM `bigquery-public-data.usa_names.usa_1910_2013` GROUP BY name ORDER BY n DESC LIMIT 5"}' \
  | grep -i '^payment-required:' | cut -d' ' -f2 | tr -d '\r' | base64 --decode

// npm i @x402/fetch @x402/evm viem
import { wrapFetchWithPayment, x402Client } from "@x402/fetch";
import { registerExactEvmScheme } from "@x402/evm/exact/client";
import { privateKeyToAccount } from "viem/accounts";

// Pays at most $0.5 per call.
const client = new x402Client().setSpendControls({ maxAmountPerPayment: "$0.5" });
registerExactEvmScheme(client, { signer: privateKeyToAccount(process.env.EVM_PRIVATE_KEY) });
const pay = wrapFetchWithPayment(fetch, client);

// Not sure it's safe to pay? ToolVet checks it first for $0.005. Pay for that from a separate
// client: this one is capped at $0.5 per payment. GET https://toolvet.app/api/v1/check?url=https%3A%2F%2Fhubvibe-io.com%2Fwork%2Fdata%2Fquery&method=POST
const res = await pay("https://hubvibe-io.com/work/data/query", {
  method: "POST",
  headers: { "content-type": "application/json" },
  body: JSON.stringify({
    "sql": "SELECT name, SUM(number) AS n FROM `bigquery-public-data.usa_names.usa_1910_2013` GROUP BY name ORDER BY n DESC LIMIT 5"
  }),
});
console.log(res.status, await res.text());

# pip install "x402[requests,evm]"
import os
from eth_account import Account
from x402 import x402ClientSync
from x402.http.clients import x402_requests
from x402.mechanisms.evm import EthAccountSigner
from x402.mechanisms.evm.exact.register import register_exact_evm_client

# Pays at most $0.5 per call.
client = x402ClientSync().set_spend_controls({"max_amount_per_payment": "$0.5"})
register_exact_evm_client(client, EthAccountSigner(Account.from_key(os.environ["EVM_PRIVATE_KEY"])))

with x402_requests(client) as session:
    res = session.post(
        "https://hubvibe-io.com/work/data/query",
        json={
            "sql": "SELECT name, SUM(number) AS n FROM `bigquery-public-data.usa_names.usa_1910_2013` GROUP BY name ORDER BY n DESC LIMIT 5",
        },
    )
    print(res.status_code, res.text)