SQL Query

POST /gateway/v1/onchain/sql

Blockchain SQL Query

cURL

curl --request POST \
  --url https://api.asksurf.ai/gateway/v1/onchain/sql \
  --header 'Content-Type: application/json' \
  --data '
{
  "sql": "SELECT transaction_hash, from_address, value FROM agent.ethereum_transactions LIMIT 5",
  "max_rows": 1000
}
'

200

{
  "data": [
    {}
  ],
  "meta": {
    "cached": true,
    "credits_used": 123,
    "limit": 123,
    "offset": 123,
    "total": 123
  },
  "$schema": "https://example.com/schemas/DataResponseOnchainRow.json"
}

Body

application/json

sql · string · required

SQL query to execute against the blockchain data warehouse

Example:

"SELECT transaction_hash, from_address, value FROM agent.ethereum_transactions LIMIT 5"

max_rows · integer<int64> · default: 1000

Maximum number of rows to return

Required range: 1 <= x <= 10000

Example:

1000

Response

200

application/json

OK

data · object[] | null · required

Show child attributes

meta · object · required

Show child attributes

$schema · string<uri> · read-only

A URL to the JSON Schema for this object.

Example:

"https://example.com/schemas/DataResponseOnchainRow.json"