Count Query Results

curl --request POST \
  --url https://app.superleap.com/api/v1/reports/count \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "query": "<string>",
  "slug": "<string>"
}
'

import requests

url = "https://app.superleap.com/api/v1/reports/count"

payload = {
    "query": "<string>",
    "slug": "<string>"
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

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

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({query: '<string>', slug: '<string>'})
};

fetch('https://app.superleap.com/api/v1/reports/count', 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://app.superleap.com/api/v1/reports/count",
  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' => '<string>',
    'slug' => '<string>'
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$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://app.superleap.com/api/v1/reports/count"

	payload := strings.NewReader("{\n  \"query\": \"<string>\",\n  \"slug\": \"<string>\"\n}")

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

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

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

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

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://app.superleap.com/api/v1/reports/count")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"query\": \"<string>\",\n  \"slug\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://app.superleap.com/api/v1/reports/count")

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

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"query\": \"<string>\",\n  \"slug\": \"<string>\"\n}"

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

POST

api

reports

count

Count Query Results

curl --request POST \
  --url https://app.superleap.com/api/v1/reports/count \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "query": "<string>",
  "slug": "<string>"
}
'

import requests

url = "https://app.superleap.com/api/v1/reports/count"

payload = {
    "query": "<string>",
    "slug": "<string>"
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

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

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({query: '<string>', slug: '<string>'})
};

fetch('https://app.superleap.com/api/v1/reports/count', 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://app.superleap.com/api/v1/reports/count",
  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' => '<string>',
    'slug' => '<string>'
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$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://app.superleap.com/api/v1/reports/count"

	payload := strings.NewReader("{\n  \"query\": \"<string>\",\n  \"slug\": \"<string>\"\n}")

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

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

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

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

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://app.superleap.com/api/v1/reports/count")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"query\": \"<string>\",\n  \"slug\": \"<string>\"\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://app.superleap.com/api/v1/reports/count")

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

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"query\": \"<string>\",\n  \"slug\": \"<string>\"\n}"

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

Overview

Companion endpoint to Execute: instead of returning records, it returns how many rows the query produces. The count respects the query’s LIMIT, and execution stops as soon as the limit is reached - which makes capped counting on very large objects fast. Use it for:

Tile counts - SELECT DISTINCT id ... LIMIT 100001 returns in a fraction of the time of a full COUNT(DISTINCT id) aggregate when the cap is reached. If the result equals the limit, display it as “1,00,000+”; if it is below the limit, it is already the exact count.
Existence / threshold checks - “are there at least N matching records?” without scanning everything.

The request body, authentication, and query rules are identical to Execute, including the relationship guidance (use DISTINCT id whenever a virtual relation appears in the query, since the join can return one row per child).

Request Body

string

required

Raw PostgreSQL SELECT query. Include a LIMIT - it caps both the scan and the returned count.

string

required

Base CRM object slug matching the query’s top-level FROM.

Example Request

curl --location 'https://<domain>.superleap.com/api/v1/reports/count' \
  --header 'Content-Type: application/json' \
  --header 'Authorization: Bearer SUPERSECRETREDACTEDKEY' \
  --data @- <<'JSON'
{
  "query": "SELECT DISTINCT id FROM lead WHERE associated_opportunities.stage = 'Open' LIMIT 100001",
  "slug": "lead"
}
JSON

Example Response

{
  "success": true,
  "data": {
    "count": 100001
  }
}

Here the count equals the limit, so the true total is at least 100,001 - render it as a capped value (“1,00,000+”) or follow up with an exact aggregate if needed.

Fetch Object Data APIs

Record Management APIs

Analytics Query APIs

Appflow APIs

Airbyte APIs

Count Query Results

Overview

Request Body

Example Request

Example Response

​Overview

​Request Body

​Example Request

​Example Response

Overview

Request Body

Example Request

Example Response