Export Database View data
Starts an asynchronous CSV export of the saved View output to an authorized Storage destination. Export queries may filter, project, sort, and page the output but cannot redefine joins, CTEs, or raw where clauses.
Authorizations
Bearer JWT token or API Key (sk-*).
Path Parameters
Query Parameters
Number of rows to skip before pagination starts. Parsed from a query-string integer.
x >= 00
Maximum number of rows to return. Parsed from a query-string integer. Most QueryWrapper-backed list endpoints default to 100 when omitted.
0 <= x <= 10000100
Include the total count in the response envelope. Accepts boolean query values such as true or false.
true
QueryWrapper filter tree as a JSON string or bracket-style query object. Supports and/or/not groups and field predicates with ops such as eq, ne, gt, gte, lt, lte, like, notLike, ilike, notILike, in, notIn, any, isNull, isNotNull, between, contains, containedBy, arrayHas, arrayHasAny, arrayHasAll, arrayContainedBy, jsonArrayHas, jsonArrayHasAny, jsonArrayHasAll, startsWith, endsWith, true, and false. Field names are logical wrapper fields; relation fields use dot paths such as groups.groupId when exposed by the endpoint wrapper.
"{\"and\":[{\"field\":\"name\",\"op\":\"ilike\",\"value\":\"Ops\"},{\"field\":\"deletedAt\",\"op\":\"isNull\"}]}"
QueryWrapper sort definition as a JSON string, indexed array query object, array, or legacy CSV. JSON object values should be ASC or DESC. CSV supports descending fields with a leading dash, for example name,-lastUpdateAt.
"{\"name\":\"ASC\",\"lastUpdateAt\":\"DESC\"}"
Optional QueryWrapper DISTINCT ON logical fields as a JSON array string, indexed array query object, array, or legacy CSV. The wrapper rewrites selected distinct fields into distinct select items.
"category,global"
Optional QueryWrapper field projection as a JSON array string, indexed array query object, array, or legacy CSV. String fields must be allowlisted logical wrapper fields. Advanced select items may use field, fn, raw, cast, coalesce, or case expressions when the endpoint enables dynamic projection.
"[\"databaseId\",\"name\",{\"fn\":\"COUNT\",\"args\":[\"users.userId\"],\"as\":\"userCount\",\"filterType\":\"number\"}]"
Optional QueryWrapper join definitions as a JSON string or bracket-style query object. This is only honored by endpoints that explicitly enable dynamic joins, such as dynamic database data reads. Each join has table, alias, type (left or inner), and an on condition.
"[{\"table\":\"groups_users\",\"alias\":\"gu\",\"type\":\"left\",\"on\":{\"left\":\"gu.groupsGroupId\",\"op\":\"=\",\"right\":\"g.groupId\"}}]"
Optional QueryWrapper groupBy logical fields as a JSON array string, indexed array query object, array, or legacy CSV. Only honored when the endpoint enables dynamic grouping or already has grouped defaults.
"[\"category\",\"global\"]"
Optional QueryWrapper cast mapping as a JSON string or bracket-style query object. Keys are selected aliases or logical fields; values are database definition types such as TEXT, INTEGER, BIGINT, NUMERIC, BOOLEAN, DATE, TIMESTAMP, TIMESTAMPTZ, JSON, JSONB, or UUID where supported.
"{\"userCount\":\"INTEGER\"}"
Optional QueryWrapper CTE definitions as a JSON string or bracket-style query object. Only honored by endpoints that explicitly enable dynamic CTEs.
"[{\"name\":\"active_groups\",\"query\":{\"from\":{\"table\":\"groups\",\"alias\":\"g\",\"definition\":[]}}}]"
Enable QueryWrapper debug output for the request, including compiled SQL, bound params, and bounded EXPLAIN plans when the underlying query service supports it.
false
Legacy dynamic database join map as a JSON string or bracket-style query object. Keys are related logical database names or database IDs. Values must be [rootColumn, joinedColumn, joinType], where joinType is left or inner. Prefer the newer joins array for new integrations.
"{\"orders\":[\"customerId\",\"customerId\",\"left\"]}"
Export file retention. Omit for the destination default, set null for no expiration, or provide exactly one of ttlSeconds and expiresAt.
CSV field delimiter. Defaults to a comma and must contain fewer than 10 characters.
"|"
CSV boolean representation.
emoji, number, boolean "boolean"
Write null values as empty CSV fields instead of the string null.
true
Base64-encode JSON and JSONB values in the CSV output.
false
Optional storage destination. Omit to retain the private per-user export namespace, use ROOT for the explorer root, or provide an accessible explorer folder storageEntryId.
"ROOT"
Dedicated CSV export file name. Path separators are not allowed. Omit to generate a database-and-timestamp name.
"contracts-full.csv"
Whether the exported storage entry is restricted. Defaults to true. Restricted ancestors still apply when exporting into a folder.
false