# Query Parameters

> 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/query-parameters
Last updated: 2026-10-21

Query parameters of NocoDB REST API list requests: where, limit, offset, sort, fields and shuffle, with their aliases, defaults and example values.

These query parameters control which rows a NocoDB API list request returns, and in which order. Each parameter also has a short alias.

## Query params

| **Name**                                           | **Alias**                                      | **Use case**                                                    | **Default value** | **Example value**                                                                                                                                                                                         |
| -------------------------------------------------- | ---------------------------------------------- | --------------------------------------------------------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [where](/docs/apis/filtering#comparison-operators) | [w](/docs/apis/filtering#comparison-operators) | Complicated where conditions                                    |                   | `(colName,eq,colValue)~or(colName2,gt,colValue2)` <br />[Usage: Comparison operators](/docs/apis/filtering#comparison-operators) <br />[Usage: Logical operators](/docs/apis/filtering#logical-operators) |
| limit                                              | l                                              | Number of rows to get (SQL limit value)                         | 10                | 20                                                                                                                                                                                                        |
| offset                                             | o                                              | Offset for pagination (SQL offset value)                        | 0                 | 20                                                                                                                                                                                                        |
| sort                                               | s                                              | Sort by column name. For a descending sort, use `-` as a prefix |                   | column\_name                                                                                                                                                                                              |
| fields                                             | f                                              | Required column names in result                                 | \*                | column\_name1,column\_name2                                                                                                                                                                               |
| shuffle                                            | r                                              | Shuffle the result for pagination                               | 0                 | 1 (Only 0 or 1. NocoDB reads other values as 0)                                                                                                                                                           |

## Related

* [Filtering](/docs/apis/filtering)
* [Pagination](/docs/apis/pagination)

---

## 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.
- [Pagination](https://nocodb.com/docs/apis/pagination.md): 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.
- [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.