HTTP API
Query web3 data with SQL via the HTTP API
Blockchain and contract data may be queried by posting SQL to the
/v0.1/sql API.- 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
/v0.1/sql
Perform a SQL query
cURL
Javascript
curl --request POST \
--url https://data.spiceai.io/v0.1/sql \
--header 'Content-Type: text/plain' \
--header 'X-API-Key: [api-key]' \
--data 'select count(number) from eth.recent_blocks'
const API_KEY = "[api-key]";
const query = `
select count(number) as num_blocks
from eth.recent_blocks
`;
const res = await fetch("https://data.spiceai.io/v0.1/sql", {
method: "POST",
headers: {
"Content-Type": "text/plain",
"X-API-Key": API_KEY,
},
body: query,
});
console.log(await res.json());
Last modified 5mo ago