Query Parameters
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 | w | Complicated where conditions | (colName,eq,colValue)~or(colName2,gt,colValue2) Usage: Comparison operators Usage: 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
Last updated on
Latest product updates?See Changelog