Transpose · Example Payload

Sql Query Request

Example SQL Analytics API request querying top NFT collections by sales volume

BlockchainNFTCryptocurrencyWeb3EthereumToken TransfersSmart ContractsHistorical DataDeFiDEX

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

Top-level fields

descriptionmethodurlheadersbody

Example Payload

{
  "description": "Example SQL Analytics API request querying top NFT collections by sales volume",
  "method": "POST",
  "url": "https://api.transpose.io/sql",
  "headers": {
    "X-API-KEY": "YOUR_API_KEY",
    "Content-Type": "application/json"
  },
  "body": {
    "sql": "SELECT contract_address, COUNT(*) AS sale_count, SUM(CAST(price AS FLOAT)) AS total_volume FROM ethereum.nft_sales WHERE timestamp >= '2023-01-01' AND timestamp < '2024-01-01' GROUP BY contract_address ORDER BY total_volume DESC LIMIT 10;"
  }
}

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-request"

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.