Query records: filter AST + sorts + q + keyset cursor (the workhorse)

POST

/api/v1/workspaces/{ws}/databases/{db}/records/query

Authorizations

• bearer

Parameters

Path Parameters

db

required

string

Request Body^required

Media typeapplication/json

object

filter

Any of:

object

object

field

required

string

>= 1 characters

op

required

string

Allowed values: eq neq contains gt gte lt lte before after within has has_none is_empty not_empty

value

disabled

boolean

pinned

boolean

label

string

<= 120 characters

icon

string

<= 40 characters

object

object

and

required

Array<object> recursive

object

object

or

required

Array<object> recursive

sorts

Array<object>

default: <= 3 items

object

field

required

string

>= 1 characters

direction

string

default: asc

Allowed values: asc desc

nulls

string

Allowed values: first last

q

string

<= 200 characters

limit

integer

default: 50 >= 1 <= 200

cursor

string

Responses

201