---
title: "Get filtered data row count"
method: POST
path: "/dataset/{handle}/count/rows"
tags: ["filter"]
---

# Get filtered data row count

`POST /dataset/{handle}/count/rows`

Returns the number of rows matching certain criteria. The request object has many fields controlling which rows are returned. For basic filtering the only one that needs to be specified is the filterModel field. For more on constructing filters, see the Filter Model Detail Guide.

## Path parameters

- `handle` string, required

## Request body

- StructsRequestAgGrid
  - `AllowUnstableOrder` boolean — API may set true to allow unstable result order for faster performance on large files
  - `FieldTypes` string[] — if the app work with pivot mode the system should check type of field by ex. int, float, string
  - `endRow` integer
  - `filterModel` object
  - `groupKeys` unknown[]
    - unknown
  - `pivotCols` StructsColumnVO[]
    - `aggFunc` string
    - `displayName` string
    - `field` string
    - `groupFunc` string
    - `id` string
  - `pivotMode` boolean
  - `rowGroupCols` StructsColumnVO[]
    - `aggFunc` string
    - `displayName` string
    - `field` string
    - `groupFunc` string
    - `id` string
  - `sortModel` StructsSortEntry[]
    - `colId` string
    - `pivotFieldGroupId` string — if pivot mode is enabled it can be sorted by pivot field group id (the column headers in pivot mode)
    - `sort` string
  - `startRow` integer
  - `ungroupedAggregations` StructsColumnVO[]
    - `aggFunc` string
    - `displayName` string
    - `field` string
    - `groupFunc` string
    - `id` string
  - `valueCols` StructsColumnVO[]
    - `aggFunc` string
    - `displayName` string
    - `field` string
    - `groupFunc` string
    - `id` string

## Response `200`

OK

- integer

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `403` — Forbidden
- `500` — Internal Server Error

---

[API](https://skmtc.net/freshdesk/apis/gigasheet-api.md) · [All operations](https://skmtc.net/freshdesk/apis/gigasheet-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/freshdesk/gigasheet-api/revisions/d1e5cbb24557/schema)