API ReferenceDatabases

Read rows from database table

Beta
Query rows from a table in the database. Supports filtering, ordering, and pagination using PostgREST-style query parameters. **Filter Syntax:** - `?column=eq.value` - Equal - `?column=neq.value` - Not equal - `?column=gt.value` - Greater than - `?column=gte.value` - Greater than or equal - `?column=lt.value` - Less than - `?column=lte.value` - Less than or equal - `?column=like.*pattern*` - LIKE (case-sensitive) - `?column=ilike.*pattern*` - ILIKE (case-insensitive) - `?column=in.(a,b,c)` - IN list - `?column=is.null` - IS NULL

Authentication

X-API-KEYstring
API Key authentication via header
OR
AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Path parameters

asset_idstringRequired
table_namestringRequired

Query parameters

selectstring or nullOptional

Columns to return (comma-separated, e.g., ‘id,name,email’)

orderstring or nullOptional

Order by clause (e.g., ‘created_at.desc’, ‘name.asc’)

limitintegerOptional1-1000Defaults to 100
Maximum number of rows to return
offsetintegerOptional>=0Defaults to 0
Number of rows to skip

Response

Successful Response
datalist of maps from strings to any
Array of row objects

Errors

400
Bad Request Error
403
Forbidden Error
404
Not Found Error
422
Unprocessable Entity Error
501
Not Implemented Error
503
Service Unavailable Error