Fetch Statements Reporting

curl --request GET \
  --url https://api.qobra.co/v2/reporting/{table_id}/statements \
  --header 'X-API-Key: <api-key>'

const options = {method: 'GET', headers: {'X-API-Key': '<api-key>'}};

fetch('https://api.qobra.co/v2/reporting/{table_id}/statements', 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.qobra.co/v2/reporting/{table_id}/statements",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "X-API-Key: <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"
	"net/http"
	"io"
)

func main() {

	url := "https://api.qobra.co/v2/reporting/{table_id}/statements"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("X-API-Key", "<api-key>")

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

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

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://api.qobra.co/v2/reporting/{table_id}/statements")

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

request = Net::HTTP::Get.new(url)
request["X-API-Key"] = '<api-key>'

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

{
  "data": [
    {
      "standard.id": "65a1b2c3d4e5f6g7h8i9j0k1",
      "standard.user": {
        "id": "507f191e810c19729de860ea",
        "email": "sarah.johnson@company.com"
      },
      "standard.date": "2024-01-01",
      "standard.total_commission": {
        "value": 8500,
        "currency": "USD"
      },
      "standard.status": "paid",
      "custom.quota_attainment": 0.92,
      "custom.tier": "Accelerator"
    },
    {
      "standard.id": "65a1b2c3d4e5f6g7h8i9j0k2",
      "standard.user": {
        "id": "507f191e810c19729de860eb",
        "email": "michael.chen@company.com"
      },
      "standard.date": "2024-01-01",
      "standard.total_commission": {
        "value": 12750,
        "currency": "USD"
      },
      "standard.status": "validated",
      "custom.quota_attainment": 1.15,
      "custom.tier": "Overachievement"
    }
  ],
  "meta": {
    "next_start_id": "65a1b2c3d4e5f6g7h8i9j999",
    "has_more": true,
    "next_url": "https://api.qobra.co/v2/reporting/507f1f77bcf86cd799439011/statements?start_id=65a1b2c3d4e5f6g7h8i9j999&limit=1000"
  }
}

{
  "count": 1,
  "errors": [
    {
      "error": "ValidationError",
      "resource": "start_id",
      "description": "Can't parse value for param 'start_id' : Value error, Invalid ObjectId"
    }
  ]
}

{
  "message": "You're trying to access resource you're not authorized to.",
  "type": "UnauthorizedError"
}

{
  "message": "We couldn't find the requested resource",
  "resource": "ObjectModel",
  "type": "NotFoundError"
}

GET

reporting

{table_id}

statements

Fetch Statements Reporting

curl --request GET \
  --url https://api.qobra.co/v2/reporting/{table_id}/statements \
  --header 'X-API-Key: <api-key>'

const options = {method: 'GET', headers: {'X-API-Key': '<api-key>'}};

fetch('https://api.qobra.co/v2/reporting/{table_id}/statements', 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.qobra.co/v2/reporting/{table_id}/statements",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "X-API-Key: <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"
	"net/http"
	"io"
)

func main() {

	url := "https://api.qobra.co/v2/reporting/{table_id}/statements"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("X-API-Key", "<api-key>")

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

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

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://api.qobra.co/v2/reporting/{table_id}/statements")

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

request = Net::HTTP::Get.new(url)
request["X-API-Key"] = '<api-key>'

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

{
  "data": [
    {
      "standard.id": "65a1b2c3d4e5f6g7h8i9j0k1",
      "standard.user": {
        "id": "507f191e810c19729de860ea",
        "email": "sarah.johnson@company.com"
      },
      "standard.date": "2024-01-01",
      "standard.total_commission": {
        "value": 8500,
        "currency": "USD"
      },
      "standard.status": "paid",
      "custom.quota_attainment": 0.92,
      "custom.tier": "Accelerator"
    },
    {
      "standard.id": "65a1b2c3d4e5f6g7h8i9j0k2",
      "standard.user": {
        "id": "507f191e810c19729de860eb",
        "email": "michael.chen@company.com"
      },
      "standard.date": "2024-01-01",
      "standard.total_commission": {
        "value": 12750,
        "currency": "USD"
      },
      "standard.status": "validated",
      "custom.quota_attainment": 1.15,
      "custom.tier": "Overachievement"
    }
  ],
  "meta": {
    "next_start_id": "65a1b2c3d4e5f6g7h8i9j999",
    "has_more": true,
    "next_url": "https://api.qobra.co/v2/reporting/507f1f77bcf86cd799439011/statements?start_id=65a1b2c3d4e5f6g7h8i9j999&limit=1000"
  }
}

{
  "count": 1,
  "errors": [
    {
      "error": "ValidationError",
      "resource": "start_id",
      "description": "Can't parse value for param 'start_id' : Value error, Invalid ObjectId"
    }
  ]
}

{
  "message": "You're trying to access resource you're not authorized to.",
  "type": "UnauthorizedError"
}

{
  "message": "We couldn't find the requested resource",
  "resource": "ObjectModel",
  "type": "NotFoundError"
}

Overview

This endpoint extracts commission statement records from a statement reporting data structure. Statements represent the final calculated commissions — what each person earned in each period. Use this endpoint for:

Payroll integration (sending commissions to payroll systems)
Commission reports and dashboards
Earnings history analysis
Compliance and audit trails

Statements = Results. This endpoint gives you the output of Qobra’s commission calculations, not the underlying deals/activities.

Pagination

This endpoint uses ID-based pagination for consistent performance with large datasets.

Basic Pagination Pattern

url = f"https://api.qobra.co/v2/reporting/{table_id}/statements"
params = {"limit": 2000}

while True:
    response = requests.get(url, headers=headers, params=params)
    result = response.json()

    # Process records
    for record in result["data"]:
        process(record)

    # Check if more pages exist
    if not result["meta"]["has_more"]:
        break

    # Use next_url for next page
    url = result["meta"]["next_url"]

Use next_url for simplicity: The API returns a pre-constructed next_url in the response meta—just follow it instead of manually building the next request.

Filtering by modification date

Use last_modified_after to implement incremental sync (only fetch new/updated records).

Incremental sync pattern

from datetime import datetime, timezone

def incremental_sync(table_id: str, api_key: str):
    # Load last sync time from your database
    last_sync = get_last_sync_time()  # e.g., 2024-01-14T00:00:00Z

    url = f"https://api.qobra.co/v2/reporting/{table_id}/statements"
    headers = {"X-API-Key": api_key}
    params = {
        "limit": 2000,
        "last_modified_after": last_sync.isoformat()
    }

    new_records = []

    while True:
        response = requests.get(url, headers=headers, params=params)
        result = response.json()

        new_records.extend(result["data"])

        if not result["meta"]["has_more"]:
            break

        url = result["meta"]["next_url"]

    # Save current time as last sync
    save_last_sync_time(datetime.now(timezone.utc))

    return new_records

# Usage: Daily incremental sync
new_statements = incremental_sync(table_id, api_key)
print(f"Found {len(new_statements)} new/updated statements since last sync")

Benefits:

✅ 10-100x faster than full extracts
✅ Reduces API load
✅ Keeps your data warehouse up-to-date with minimal overhead

Performance & best practices

Use ID-based pagination

Always use next_url for large datasets (10K+).

url = result["meta"]["next_url"]

Implement incremental sync

Use last_modified_after for daily/hourly updates.

params = {"last_modified_after": last_sync}

Use Limit 2000

Optimal balance between network overhead and response time.

params = {"limit": 2000}

Authorizations

X-API-Key

string

header

required

Your Qobra API key. Generate it from Settings > API Keys in Qobra.

Path Parameters

table_id

string<ObjectId>

required

ID of a statement reporting structure (from /v2/data-structures)

Query Parameters

start_id

string<ObjectId>

Start after this record ID (for ID-based pagination, recommended)

limit

integer

default:2000

Number of records per page (1-2000)

Required range: 1 <= x <= 2000

last_modified_after

string<date-time>

ISO 8601 datetime - Only return records modified after this date (for incremental sync)

last_modified_before

string<date-time>

ISO 8601 datetime - Only return records modified before this date

Response

Successfully retrieved statement records. Returns an array of commission statements with pagination metadata for navigating through large datasets.

data

object[]

required

List of statement records

Show child attributes

Inbound data integrations

Outbound data integrations

Public API Documentation

Authentication

Fetch Statements Reporting

Overview

Filtering by modification date

Incremental sync pattern

Performance & best practices

Use ID-based pagination

Implement incremental sync

Use Limit 2000

Authorizations

Path Parameters

Query Parameters

Response

​Overview

​Pagination

​Basic Pagination Pattern

​Filtering by modification date

​Incremental sync pattern

​Performance & best practices

Use ID-based pagination

Implement incremental sync

Use Limit 2000

Authorizations

Path Parameters

Query Parameters

Response

Overview

Pagination

Basic Pagination Pattern

Filtering by modification date

Incremental sync pattern

Performance & best practices