Parameterized Queries

The SQL Analytics API supports paramaterized SQL queries. This allows you to define parameters in the SQL directly to iterate over ranges and results. Parameters are wrapped in double brackets within the SQL and passed in the parameters mapping in the json request body. Your parameter name must match the key. For example:

SQL Query

SELECT * FROM ethereum.nfts WHERE contract_address = '{{contract_address}}' LIMIT 10;

PythonNodecURL

import requests url = "https://api.transpose.io/sql" sql_query = """SELECT * FROM ethereum.nfts WHERE contract_address = '{{contract_address}}' LIMIT 10;""" headers = { 'Content-Type': 'application/json', 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG', } response = requests.post(url, headers=headers, json={ 'sql': sql_query, 'parameters': { 'contract_address': '0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D' } }, ) 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.nfts WHERE contract_address = '{{contract_address}}' LIMIT 10;", parameters: { contract_address: '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' } }); 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.nfts WHERE contract_address = '\''{{contract_address}}'\'' LIMIT 10;", "parameters": {"contract_address": "0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D"}}' \
     --url 'https://api.transpose.io/sql' \
     --header 'Content-Type: application/json' \
     --header 'x-api-key: BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' \