Links

HTTP API

Query web3 data with SQL via the HTTP API
Blockchain and contract data may be queried by posting SQL to the /v1/sql API and /v1/firesql API for Firecached data. For documentation on the Spice Firecache see Firecache.
See Tables for a list of tables to query or browse the example queries listed in the menu.

Requirements and limitations

  • An API key is required for all SQL queries.
  • Results are limited to 500 rows. Use the Apache Arrow Flight API to fetch up to 1M rows in a single query or the Async HTTP API to fetch results with paging.
  • Requests are limited to 90 seconds.
post
https://data.spiceai.io
/v1/sql
Perform a SQL query
post
https://data.spiceai.io
/v1/firesql
Perform a Firecache SQL Query
cURL
Javascript
curl --request POST \
--url https://data.spiceai.io/v1/sql \
--header 'Content-Type: text/plain' \
--header 'X-API-Key: [api-key]' \
--data 'select count(number) from eth.recent_blocks'
import { SpiceClient } from '@spiceai/spice';
const main = async () => {
const spiceClient = new SpiceClient('API_KEY');
const table = await spiceClient.query(
'select count(number) as num_blocks from eth.recent_blocks'
);
console.table(table.toArray());
};
Last modified 4mo ago