---
title: "List Row Counts"
method: GET
path: "/ingestion/row-counts"
tags: ["Data Management"]
---

# List Row Counts

`GET /ingestion/row-counts`

## Request

- Base URL: `https://api.withterminal.com/tsp/v1`
- URL: `https://api.withterminal.com/tsp/v1/ingestion/row-counts`
- Auth: HTTP bearer

Retrieve row counts by model for a connection. Omit groupBy for totals over the date range, use groupBy=day for daily rows, use groupBy=vehicle for per-vehicle totals, or combine both (for example groupBy=day,vehicle) for per-day, per-vehicle rows.

## Query parameters

- `startDate` string, date, required
- `endDate` string, date, required
- `groupBy` 'day' | 'vehicle' | 'day,vehicle' | 'vehicle,day': Used to control the aggregation of row counts. Use 'day' for daily rows, 'vehicle' for per-vehicle totals over the range, or combine both keys for per-day, per-vehicle rows. Omit this field for totals over the full date range.
- `vehicleIds` string
- `models` string, required
- `cursor` string, cursor
- `limit` integer

## Headers

- `X-Application-Id` string
- `Connection-Token` string, required

## Response `200`

OK

- object
  - `results` RowCountEntry[], required
    - `model` 'VehicleLocation' | 'VehicleStatLog' | 'Trip' | 'SafetyEvent' | 'HOSLog' | 'HOSDailyLog' | 'VehicleUtilizationDay' | 'FaultCodeEvent' | 'IFTAVehicleMonth', required: Common model name used for row count aggregation.
    - `date` string, date: UTC date for the aggregation window when groupBy=day.
    - `count` integer, required
    - `vehicle` string, ulid: Unique identifier for the vehicle in Terminal.
  - `next` string, cursor: Cursor used for pagination.

## Other responses

- `400`: Bad Request
- `401`: Unauthorized
- `403`: Forbidden
- `410`: Gone
- `429`: Too Many Requests
- `500`: Internal Server Error
- `501`: Not Implemented
- `504`: Gateway Timeout Error

## Changes

- **2026-11-03** `71081936e1bd`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/withterminal/apis/terminal-telematics-api/changes/ingestion/row-counts/get.md)

---

[API](https://skmtc.dev/withterminal/apis/terminal-telematics-api.md) - [All operations](https://skmtc.dev/withterminal/apis/terminal-telematics-api/llms.txt) - [OpenAPI document](https://skmtc.dev/withterminal/apis/terminal-telematics-api/revisions/a9f825034fd3?raw)