Basic database APIs (client side)
Get all items
Retrieves an item from a database table. Supports filtering, ordering, pagination, and field selection.
- Ordering: Use
?order=field.direction
(e.g.,?order=created_at.desc,name.asc
) - Pagination: Use
?limit=10&offset=20
- Filtering: Use operators like
?name=eq.John
,?price=gt.10
, etc. - Field Selection: Use
?select=id,name,email
to return only specific fields
GET
Query Parameters
item id
order by field and direction (asc or desc) (e.g. ?order=created_at.desc,name.asc)
maximum number of results to return
number of results to skip
comma-separated list of fields to return (e.g. ?select=name,email,created_at)
Response
200
application/json
Database item