Stringify Numbers

Some languages, such as Javascript, have no native support for 256-bit integers.

To work around this, you can pass the boolean stringify_numbers option as a parameter to your SQL-endpoint request. This returns all numeric objects (integers and floats) as their string representation.

SQL Query

SELECT token_id FROM ethereum.nfts LIMIT 1

PythonNodecURL

import requests url = "https://api.transpose.io/sql" sql_query = """SELECT token_id FROM ethereum.nfts LIMIT 1""" headers = { 'Content-Type': 'application/json', 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG', } response = requests.post(url, headers=headers, json={ 'sql': sql_query, 'options': { 'stringify_numbers': True } }, ) print(response.text) print('Credits charged:', response.headers.get('X-Credits-Charged', None))

const https = require('https'); var postData = JSON.stringify({ sql: "SELECT token_id FROM ethereum.nfts LIMIT 1", options: { stringify_numbers: true } }); 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 token_id FROM ethereum.nfts LIMIT 1", "options": {"stringify_numbers": true}}' \
     --url 'https://api.transpose.io/sql' \
     --header 'Content-Type: application/json' \
     --header 'x-api-key: BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' \

SQL Query

SELECT token_id FROM ethereum.nfts LIMIT 1

PythonNodecURL

import requests url = "https://api.transpose.io/sql" sql_query = """SELECT token_id FROM ethereum.nfts LIMIT 1""" headers = { 'Content-Type': 'application/json', 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG', } response = requests.post(url, headers=headers, json={ 'sql': sql_query, 'options': { 'stringify_numbers': False } }, ) print(response.text) print('Credits charged:', response.headers.get('X-Credits-Charged', None))

const https = require('https'); var postData = JSON.stringify({ sql: "SELECT token_id FROM ethereum.nfts LIMIT 1", options: { stringify_numbers: false } }); 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 token_id FROM ethereum.nfts LIMIT 1", "options": {"stringify_numbers": false}}' \
     --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.