---
title: "Get rows for a table"
method: GET
path: "/cms/hubdb/2026-03/tables/{tableIdOrName}/rows"
tags: ["Rows"]
---

# Get rows for a table

`GET /cms/hubdb/2026-03/tables/{tableIdOrName}/rows`

Returns a set of rows in the published version of the specified table. Row results can be filtered and sorted. Filtering and sorting options will be sent as query parameters to the API request. For example, by adding the query parameters `column1__gt=5&sort=-column1`, API returns the rows with values for column `column1` greater than 5 and in the descending order of `column1` values. Refer to the [overview section](https://developers.hubspot.com/docs/api/cms/hubdb#filtering-and-sorting-table-rows) for detailed filtering and sorting options.
**Note:** This endpoint can be accessed without any authentication, if the table is set to be allowed for public access.

## Path parameters

- `tableIdOrName` string, required

## Query parameters

- `after` string
- `archived` boolean
- `limit` integer
- `offset` integer
- `properties` string[]
- `sort` string[]

## Response `200`

successful operation

- union
  - object
    - `paging` BoundedPaging
      - `next` BoundedNextPage
        - `link` string — A URL that can be used to retrieve the next set of results.
        - `offset` integer, required — The offset value indicating the starting point for the next set of results.
    - `results` HubDbTableRowV3Wrapper[], required — unresolved $ref
    - `total` integer, required — The total number of rows available in the collection.
    - `type` 'RANDOM_ACCESS', required — Indicates the type of response, which is 'RANDOM_ACCESS' by default.
  - object
    - `paging` Paging
      - `next` NextPage — Specifies the paging information needed to retrieve the next set of results in a paginated API response
        - `after` string, required — A paging cursor token for retrieving subsequent pages.
        - `link` string — A URL that can be used to retrieve the next page results.
      - `prev` PreviousPage — specifies the paging information needed to retrieve the previous set of results in a paginated API response
        - `before` string, required — A paging cursor token for retrieving previous pages.
        - `link` string — A URL that can be used to retrieve the previous pages' results.
    - `results` HubDbTableRowV3Wrapper[], required — unresolved $ref
    - `total` integer, required — The total number of rows available in the collection.
    - `type` 'STREAMING', required — Indicates the type of response, which is 'STREAMING' by default.

## Other responses

- `default` — An error occurred.

---

[API](https://skmtc.net/hubspot/apis/cms-hubdb.md) · [All operations](https://skmtc.net/hubspot/apis/cms-hubdb/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/hubspot/cms-hubdb/revisions/18fde1f09597/schema)