Data Cloud SQL Query (Classic)

POST /dw/query

cURL

cURL

curl --request POST \
  --url https://api.chainbase.com/api/v1/dw/query \
  --header 'Content-Type: <content-type>' \
  --header 'X-API-KEY: <x-api-key>' \
  --data '
{
  "query": "select number, transactions_count from ethereum.blocks order by number desc limit 3000;"
}
'

import requests

url = "https://api.chainbase.com/api/v1/dw/query"

payload = { "query": "select number, transactions_count from ethereum.blocks order by number desc limit 3000;" }
headers = {
    "X-API-KEY": "<x-api-key>",
    "Content-Type": "<content-type>"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {'X-API-KEY': '<x-api-key>', 'Content-Type': '<content-type>'},
  body: JSON.stringify({
    query: 'select number, transactions_count from ethereum.blocks order by number desc limit 3000;'
  })
};

fetch('https://api.chainbase.com/api/v1/dw/query', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.chainbase.com/api/v1/dw/query",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'query' => 'select number, transactions_count from ethereum.blocks order by number desc limit 3000;'
  ]),
  CURLOPT_HTTPHEADER => [
    "Content-Type: <content-type>",
    "X-API-KEY: <x-api-key>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.chainbase.com/api/v1/dw/query"

	payload := strings.NewReader("{\n  \"query\": \"select number, transactions_count from ethereum.blocks order by number desc limit 3000;\"\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("X-API-KEY", "<x-api-key>")
	req.Header.Add("Content-Type", "<content-type>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://api.chainbase.com/api/v1/dw/query")
  .header("X-API-KEY", "<x-api-key>")
  .header("Content-Type", "<content-type>")
  .body("{\n  \"query\": \"select number, transactions_count from ethereum.blocks order by number desc limit 3000;\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.chainbase.com/api/v1/dw/query")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["X-API-KEY"] = '<x-api-key>'
request["Content-Type"] = '<content-type>'
request.body = "{\n  \"query\": \"select number, transactions_count from ethereum.blocks order by number desc limit 3000;\"\n}"

response = http.request(request)
puts response.read_body

400

{
  "message": "sql is empty",
  "code": 1001,
  "data": []
}

Example

Query the hashes of the last 3,000 blocks in Ethereum and the number of transactions in each block:

curl -X "POST" "https://api.chainbase.online/v1/dw/query" \
     -H 'X-API-KEY: YOUR-API-KEY ' \
     -H 'Content-Type: application/json; charset=utf-8' \
     -d $'{
  "query": "select number, transactions_count from ethereum.blocks order by number desc limit 3000;"
}'

If there are more than 1000 rows, you need to paginate through thetask_id and page to get all the results:

curl -X "POST" "https://api.chainbase.online/v1/dw/query" \
     -H 'X-API-KEY: YOUR-API-KEY ' \
     -H 'Content-Type: application/json; charset=utf-8' \
     -d $'{
       "task_id": "xxxxxxxxxxxxxxxxxxxxx",
       "page": 2
}'

🚧 Note

1. When quey_id is passed in, the content of query will be ignored
2. The executed request generates a task_id, which is valid for 1 hour
3. A maximum of 100,000 pieces of data are allowed to be obtained from the request, and 1,000 results are paginated per page

Headers

X-API-KEY · string · required

Content-Type · string · required

Example:

"application/json"

Body

application/json

query · string

Example:

"select number, transactions_count from ethereum.blocks order by number desc limit 3000;"

Response

200

OK