# Pagination

> Part of the NocoDB documentation (APIs). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.

URL: https://nocodb.com/docs/apis/pagination
Last updated: 2026-10-21

Page through NocoDB REST API results: follow the next and prev URLs of v3 record lists, and use limit, offset and pageInfo for the base list.

NocoDB API list requests return one page of results at a time. Record lists and the base list page in different ways.

## Paging records

The v3 record and link endpoints return `next` and `prev` URLs beside `records`. Follow `next` until it is `null`.

A page after the last record is not an error. The response has an empty `records` list and a `null` `next`. Its `prev` points at the last page that has records, or at page 1 when the result set is empty. The base list above is different: there, an `offset` past the end returns an error.

## Paging the base list

`GET /api/v3/meta/workspaces/{workspaceId}/bases` returns every base in the workspace. To get one page instead, send `limit` with the number of bases you want, and `offset` with the number to skip. NocoDB ignores `offset` when you send no `limit`.

Each response has a `pageInfo` object beside `list`. `totalRows` counts every base that you can see in the workspace. `pageSize` is the page size that NocoDB applied. It is smaller than your `limit` when the deployment caps it, so page with `pageSize` and not with the `limit` that you sent. A self-hosted deployment sets this cap with [`NC_DB_QUERY_LIMIT_MAX`](/docs/self-hosting/environment-variables#product-configuration).

An `offset` at or above `totalRows` returns an error, not an empty page.

## Related

* [Query Parameters](/docs/apis/query-parameters)
* [Filtering](/docs/apis/filtering)

---

## Related pages

- [NocoDB API Quickstart](https://nocodb.com/docs/apis.md): Make your first NocoDB REST API request: create an API token, find your project and table IDs, then list the records of a table with the v3 Data API.
- [Authentication](https://nocodb.com/docs/apis/authentication.md): Authenticate NocoDB REST API requests with an API token, sent in the xc-token header or as a Bearer token, and explore endpoints in the Swagger UI.
- [Find IDs](https://nocodb.com/docs/apis/ids.md): Find the workspace, base, table, view, field, record, user and data source IDs that NocoDB REST API endpoints need, and the prefix of each ID.
- [Filtering](https://nocodb.com/docs/apis/filtering.md): Filter NocoDB REST API results with the where query parameter: comparison operators, date sub-operators, logical operators and the quoted v3 syntax.
- [Query Parameters](https://nocodb.com/docs/apis/query-parameters.md): Query parameters of NocoDB REST API list requests: where, limit, offset, sort, fields and shuffle, with their aliases, defaults and example values.
- [Errors and Rate Limits](https://nocodb.com/docs/apis/errors.md): NocoDB REST API errors and rate limits: the JSON error body, what each HTTP status code means, request IDs, and how to handle a 429 response.
- [Upload Files](https://nocodb.com/docs/apis/upload-files.md): Upload local files to a NocoDB Attachment field with the REST API: code samples in JavaScript, Bash, TypeScript, Python, Ruby and Java, for one file or a batch.
- [Delete Records by ID](https://nocodb.com/docs/apis/delete-records.md): Delete NocoDB records, or unlink linked records, by sending the record ids in a records query parameter when a client or proxy removes the DELETE body.