HTTP API
Query web3 data with SQL via the HTTP API
Last updated
Query web3 data with SQL via the HTTP API
Last updated
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.
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
The SQL query should be sent in the body of the request as plain text
Name | Type | Description |
---|---|---|
Name | Type | Description |
---|---|---|
POST
https://data.spiceai.io/v1/firesql
The SQL query should be sent in the body of the request as plain text
Name | Type | Description |
---|---|---|
Name | Type | Description |
---|---|---|
api_key
String
The API Key for your Spice app
Content-Type*
String
text/plain
X-API-KEY
String
The API Key for your Spice app
api_key
String
The API Key for your Spice app
Content-Type*
String
text/plain
X-API-KEY
String
The API Key for your Spice app