Retrieves an item from a database table. Supports filtering, ordering, pagination, and field selection.
?order=field.direction
(e.g., ?order=created_at.desc,name.asc
)?limit=10&offset=20
?name=eq.John
, ?price=gt.10
, etc.?select=id,name,email
to return only specific fieldsitem 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)
Database item