---
title: "Get record counts"
method: GET
path: "/sheets/{sheetId}/counts"
tags: ["sheets"]
---

# Get record counts

`GET /sheets/{sheetId}/counts`

Returns counts of records from a sheet

## Path parameters

- `sheetId` string, required — Sheet ID

## Query parameters

- `versionId` string
- `sinceVersionId` string — Version ID
- `commitId` string — Commit ID
- `sinceCommitId` string — Commit ID
- `filter` 'valid' | 'error' | 'all' | 'none' — Options to filter records
- `filterField` string — Use this to narrow the valid/error filter results to a specific field
- `searchValue` string — Search for the given value, returning matching rows. For exact matches, wrap the value in double quotes ("Bob"). To search for null values, send empty double quotes ("")
- `searchField` string — Use this to narrow the searchValue results to a specific field
- `byField` boolean
- `q` string

## Headers

- `Authorization` string, required
- `X-Disable-Hooks` 'true', required

## Response `200`

Response with status 200

- TypeSheetsRecordCountsResponse
  - `data` TypeSheetsRecordCountsResponseData, required
    - `counts` TypeRecordsRecordCounts, required
      - `total` integer, required
      - `valid` integer, required
      - `error` integer, required
      - `errorsByField` object
      - `byField` object — Counts for valid, error, and total records grouped by field key
    - `success` boolean, required

---

[API](https://skmtc.net/flatfile/apis/api-reference.md) · [All operations](https://skmtc.net/flatfile/apis/api-reference/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/flatfile/api-reference/versions/9d3a9979cd96/schema)