Pagination

Pagination on the Transpose SQL Analytics API is straightforward with parameterized queries.

Here is what it looks like in Python using the requests package to get all Ethereum NFT sales within a certain time range:

import requests url = 'https://api.transpose.io/sql' sql_query = """SELECT * FROM ethereum.nft_sales WHERE (timestamp, log_index) > ('{{timestamp}}', {{log_index}}) ORDER BY timestamp, log_index LIMIT 1000;""" headers = { 'Content-Type': 'application/json', 'X-API-KEY': 'BtRVYj7dgnYUcr1gSSfWhmrTShIb8RBG' } # initialize start and end timestamps start_timestamp = '2023-01-01T00:00:00Z' end_timestamp = '2023-01-01T01:00:00Z' log_index = -1 # retrieve all pages while True: response = requests.post( url, headers=headers, json={'sql': sql_query, 'parameters': {'timestamp': start_timestamp, 'log_index': log_index}}, ) results = response.json()['results'] print(('Recieved {} results where timestamp > {} and timestamp <= {}').format(len(results), start_timestamp, results[-1]['timestamp'])) if results[-1]['timestamp'] >= end_timestamp: break start_timestamp = results[-1]['timestamp'] log_index = results[-1]['log_index']

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.