Query Operators
Filter and sort your data with advanced query operators.
Filter Operators
| Operator | Description | Example |
|---|---|---|
$eq | Equal | name[$eq]=John |
$ne | Not equal | status[$ne]=deleted |
$gt | Greater than | age[$gt]=18 |
$gte | Greater or equal | age[$gte]=18 |
$lt | Less than | price[$lt]=100 |
$lte | Less or equal | price[$lte]=100 |
$in | In array | status[$in]=active,pending |
$nin | Not in array | role[$nin]=admin,super |
$contains | Contains (ILIKE) | name[$contains]=john |
$startsWith | Starts with | email[$startsWith]=john |
$endsWith | Ends with | email[$endsWith]=@gmail.com |
Pagination
GET /data/users?limit=10&pageToken=eyJ2IjoiMjAyNC0wMS0wMSJ9
Response:
{
"documents": [...],
"nextPageToken": "eyJ2IjoiMjAyNC0wMS0xMCJ9",
"hasMore": true
}Ordering
GET /data/users?orderBy=created_at&orderDir=desc