Getting Started with Transpose SQL

If you're brand new to Transpose, we recommend checking our our Quick Start Guide.

Quickstart Guide

Get started with both our REST and SQL Analytics APIs in less than 5 minutes.

Get started in three easy steps

1. Sign up for a free key through our webapp at app.transpose.io

2. Create a new POST request, and include your API key in the header as X-API-KEY.

3. Submit a valid SQL query in the body of the POST request to our SQL endpoint as sql. Note that all of our table names are namespaced to a specific chain (i.e. ethereum.nft_sales).

SQL Query

SELECT * FROM ethereum.nft_sales ORDER BY timestamp DESC LIMIT 10;

PythonNodecURL

import requests url = "https://api.transpose.io/sql" sql_query = """SELECT * FROM ethereum.nft_sales ORDER BY timestamp DESC LIMIT 10;""" headers = { 'Content-Type': 'application/json', 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG', } response = requests.post(url, headers=headers, json={ 'sql': sql_query, }, ) print(response.text) print('Credits charged:', response.headers.get('X-Credits-Charged', None))

const https = require('https'); var postData = JSON.stringify({ sql: "SELECT * FROM ethereum.nft_sales ORDER BY timestamp DESC LIMIT 10;" }); var options = { hostname: 'api.transpose.io', path: '/sql', method: 'POST', headers: { 'Content-Type': 'application/json', 'Content-Length': postData.length, 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' } }; var req = https.request(options, (res) => { console.log('Credits charged:', res.headers['x-credits-charged']); res.on('data', (d) => { process.stdout.write(d); }); }); req.on('error', (e) => { console.error(e); }); req.write(postData); req.end();

curl --request POST \
     --data '{"sql": "SELECT * FROM ethereum.nft_sales ORDER BY timestamp DESC LIMIT 10;"}' \
     --url 'https://api.transpose.io/sql' \
     --header 'Content-Type: application/json' \
     --header 'x-api-key: BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' \

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.