Transpose · Example Payload

Sql Query Response

Example response from the SQL Analytics API for a top NFT collections query

BlockchainNFTCryptocurrencyWeb3EthereumToken TransfersSmart ContractsHistorical DataDeFiDEX

Sql Query Response is an example object payload from Transpose, with 4 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

descriptionstatusheadersbody

Example Payload

Raw ↑ 
{
  "description": "Example response from the SQL Analytics API for a top NFT collections query",
  "status": 200,
  "headers": {
    "X-Credits-Charged": 50,
    "Content-Type": "application/json"
  },
  "body": {
    "status": "ok",
    "columns": ["contract_address", "sale_count", "total_volume"],
    "results": [
      {
        "contract_address": "0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D",
        "sale_count": 12450,
        "total_volume": 85432.75
      },
      {
        "contract_address": "0xb47e3cd837dDF8e4c57F05d70Ab865de6e193BBB",
        "sale_count": 8920,
        "total_volume": 62100.20
      },
      {
        "contract_address": "0x60E4d786628Fea6478F785A6d7e704777c86a7c6",
        "sale_count": 7630,
        "total_volume": 45876.50
      }
    ]
  }
}

Work with this as data

Every example here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for examples

4 MCP tools reach this
  • find_examplesBrowse and filter every example in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools

Call it yourself

curl for this page
This example 
curl "https://apis.io/api/v1/examples/sql-query-response"
All examples 
curl "https://apis.io/api/v1/examples?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.