Query Rows

Authorizations

Authorization

string

headerrequired

An API key to authenticate requests

Query Parameters

limit

integer

default: 100

Number of rows to retrieve per page.

page

integer

default: 1

The page number for paginated results.

query_id

integer

default: 0

The scroll query ID for paginated results.

Body

application/json

smartlist_id

string

ID of the SmartList to apply custom filters

filters

object[]

List of filter criteria to apply to the query

filters.column_id

string

filters.name

string

filters.value

string

filters.operator

enum<string>

Available options:

equal,

not_equal,

empty,

not_empty,

contain,

not_contain,

is_any,

is_none_of

Response

200 - application/json

rows

object[]

rows.id

string

required

ID of the row

rows.columns

object

required

Data values for each column in the row

rows.created_datetime

string

Date and time the Row was created

rows.updated_datetime

string

Date and time the Row was last updated, if any

table

object

table.id

string

required

ID of the Table

table.columns

object[]

required

List of column names in the table

table.columns.id

string

required

ID of the column

table.columns.name

string

required

Name of the column

table.columns.type

enum<string>

required

Type of the column

Available options:

TEXT,

NUMBER,

DATE,

PHONE NUMBER,

EMAIL,

URL,

SELECT,

MULTI SELECT

table.created_datetime

string

Date and time the table was created

table.updated_datetime

string

Date and time the table was last updated, if any

smartlist

object

smartlist.id

string

required

Smartlist ID

smartlist.created_datetime

string

Date and time the smartlist was created

smartlist.updated_datetime

string

Date and time the smartlist was last updated, if any

API Documentation

OTP

Texts

Mails

List

Airtime

Webhook

Authorizations

Query Parameters

Body

Response