Authentication
SameX-API-Key header as other Platform APIs.
Query rows
GET /platform/v1/db/{table}
Filters
Add query parameters with operators:| Operator | Example | Description |
|---|---|---|
| eq | status=eq.active | Equals |
| gt | age=gt.18 | Greater than |
| gte | age=gte.18 | Greater or equal |
| lt | price=lt.100 | Less than |
| lte | price=lte.100 | Less or equal |
| like | name=like.%john% | Pattern match |
| in | status=in.(active,pending) | In list |
| is.null | deleted_at=is.null | Is null |
Select columns
?select=id,name,email
Order
?order=created_at.desc
Pagination
?limit=20&offset=40
Example
Get single row
GET /platform/v1/db/{table}/{id}
Insert rows
POST /platform/v1/db/{table}
Update rows
PATCH /platform/v1/db/{table}?{filters}
Updates all rows matching filters.
Upsert
PUT /platform/v1/db/{table}?{filters}
Delete rows
DELETE /platform/v1/db/{table}?{filters}
Deletes all rows matching filters.