---
title: "Count a table's records per value, as the builder"
description: "How many rows sit under each value of one column, ordered the way that column sorts."
canonical: "https://gtable.app/docs/builder-api/data/records-groups"
updated: "2026-10-05"
---

# Count a table's records per value, as the builder

`GET https://studio.gtable.app/v1/apps/{appId}/tables/{tableId}/records/groups`

How many rows sit under each value of one column, ordered the way that column sorts.

`fieldId` takes the field's id or exact name; an unknown one is refused, listing the table's fields.

Requires the `records:read` scope. Operation `apps.records.groups`. MCP tool `apps_records_groups`. CLI, once published: `gtable apps records groups`.

## Path parameters

| Name      | Type   | Required | Description |
| --------- | ------ | -------- | ----------- |
| `appId`   | string | yes      |             |
| `tableId` | string | yes      |             |

## Query parameters

| Name      | Type    | Required | Description            |
| --------- | ------- | -------- | ---------------------- |
| `viewId`  | string  | no       | Up to 64 characters.   |
| `search`  | string  | no       | Up to 200 characters.  |
| `filter`  | string  | no       | Up to 4000 characters. |
| `sorts`   | string  | no       | Up to 1000 characters. |
| `where`   | string  | no       | Up to 4000 characters. |
| `fieldId` | string  | yes      | Up to 200 characters.  |
| `limit`   | integer | no       |                        |