> ## Documentation Index
> Fetch the complete documentation index at: https://docs.revoengine.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.



## OpenAPI

````yaml /api-reference/openapi.json get /api/v1/databases/views/{databaseViewId}/exportData
openapi: 3.0.0
info:
  title: RevoEngine Platform API
  description: Official RevoEngine Platform API documentation.
  version: 1.3.0
  contact:
    name: Support
    email: support@revoengine.com
  termsOfService: https://docs.revoengine.com/tos
servers:
  - url: https://api.revoengine.com
    description: Production
security: []
tags:
  - name: Accounts
    description: Users, service accounts, API keys, status, and platform access.
    externalDocs:
      description: Identity and access guide
      url: https://docs.revoengine.com/operate/identity-and-access
  - name: Activity
    description: Snapshot-backed activity and version history.
    externalDocs:
      description: Observability guide
      url: https://docs.revoengine.com/operate/observability
  - name: Agent Memory
    description: Administrative access to durable Agent memory.
    externalDocs:
      description: Agent memory and workspaces guide
      url: https://docs.revoengine.com/ai/memory-and-workspaces
  - name: Agent Plugins
    description: Agent plugin definitions, synchronization, testing, and lifecycle.
    externalDocs:
      description: Agent plugins guide
      url: https://docs.revoengine.com/ai/plugins
  - name: Agents
    description: >-
      Agent definitions, runs, sessions, inboxes, memory, tools, workspaces, and
      lifecycle.
    externalDocs:
      description: Autonomous Agents guide
      url: https://docs.revoengine.com/ai/agents
  - name: Assistant
    description: >-
      Assistant threads, messages, responses, goals, reports, sharing,
      attachments, and control.
    externalDocs:
      description: Assistant guide
      url: https://docs.revoengine.com/ai/assistant
  - name: Automation
    description: >-
      Jobs, templates, schedules, events, webhooks, execution history, and
      lifecycle.
    externalDocs:
      description: Automation guide
      url: https://docs.revoengine.com/operate/automation
  - name: Chat
    description: Collaborative chat threads, messages, reactions, uploads, and attachments.
    externalDocs:
      description: Team Chat guide
      url: https://docs.revoengine.com/operate/chat
  - name: Component deployments
    description: >-
      Custom Node.js runtime deployment attempts, readiness, activation, and
      rollback.
    externalDocs:
      description: Custom Node.js guide
      url: https://docs.revoengine.com/build/custom-nodejs
  - name: Components
    description: Components, elements, versions, validation, activation, and lifecycle.
    externalDocs:
      description: Components guide
      url: https://docs.revoengine.com/build/components
  - name: Config
    description: Instance configuration, usage, logs, and cache administration.
    externalDocs:
      description: Instance settings guide
      url: https://docs.revoengine.com/platform/instance-settings
  - name: Database Cache
    description: Instance Database cache values and statistics.
    externalDocs:
      description: Database Cache guide
      url: https://docs.revoengine.com/operate/database-cache
  - name: Database Views
    description: Database Views, previews, refreshes, exports, and controlled data actions.
    externalDocs:
      description: Database Views guide
      url: https://docs.revoengine.com/operate/database-views
  - name: Databases
    description: Database definitions, data, audits, exports, cloning, and lifecycle.
    externalDocs:
      description: Databases guide
      url: https://docs.revoengine.com/operate/databases
  - name: Endpoints
    description: >-
      Endpoint definitions, activation, validation, generated OpenAPI, and
      statistics.
    externalDocs:
      description: Endpoints guide
      url: https://docs.revoengine.com/operate/endpoints
  - name: Files
    description: Compatibility file listing, preview, download, and deletion operations.
    externalDocs:
      description: Files compatibility guide
      url: https://docs.revoengine.com/operate/files
  - name: Groups
    description: Groups, membership, avatars, and lifecycle.
    externalDocs:
      description: Groups guide
      url: https://docs.revoengine.com/operate/groups
  - name: Me
    description: Current user profile, keys, avatar, and session information.
    externalDocs:
      description: Authentication guide
      url: https://docs.revoengine.com/developers/authentication
  - name: Preferences
    description: User and instance preference values.
    externalDocs:
      description: Platform UI guide
      url: https://docs.revoengine.com/platform/ui-tour
  - name: Role Groups
    description: Role groups, members, assigned roles, and lifecycle.
    externalDocs:
      description: Permissions guide
      url: https://docs.revoengine.com/operate/permissions
  - name: Roles
    description: Available platform roles and role details.
    externalDocs:
      description: Permissions guide
      url: https://docs.revoengine.com/operate/permissions
  - name: Search
    description: Cross-domain search over objects visible to the caller.
    externalDocs:
      description: Search and discovery guide
      url: https://docs.revoengine.com/platform/search
  - name: Secrets
    description: >-
      Secret definitions, revisions, activation, reveal, disable, and
      destruction.
    externalDocs:
      description: Secrets guide
      url: https://docs.revoengine.com/operate/secrets
  - name: Storage
    description: >-
      Storage workspaces, folders, objects, upload sessions, signed access, and
      lifecycle.
    externalDocs:
      description: Storage guide
      url: https://docs.revoengine.com/operate/storage
externalDocs:
  description: Documentation
  url: https://docs.revoengine.com
paths:
  /api/v1/databases/views/{databaseViewId}/exportData:
    get:
      tags:
        - Database Views
      summary: Export Database View data
      description: >-
        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.
      operationId: DatabaseViewController_exportData
      parameters:
        - name: databaseViewId
          required: true
          in: path
          schema:
            type: string
        - name: skip
          required: false
          in: query
          description: >-
            Number of rows to skip before pagination starts. Parsed from a
            query-string integer.
          schema:
            minimum: 0
            example: 0
            type: number
        - name: take
          required: false
          in: query
          description: >-
            Maximum number of rows to return. Parsed from a query-string
            integer. Most QueryWrapper-backed list endpoints default to 100 when
            omitted.
          schema:
            minimum: 0
            maximum: 10000
            example: 100
            type: number
        - name: count
          required: false
          in: query
          description: >-
            Include the total count in the response envelope. Accepts boolean
            query values such as true or false.
          schema:
            type: boolean
            example: true
        - name: filter
          required: false
          in: query
          description: >-
            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.
          schema:
            example: >-
              {"and":[{"field":"name","op":"ilike","value":"Ops"},{"field":"deletedAt","op":"isNull"}]}
            type: string
        - name: sort
          required: false
          in: query
          description: >-
            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.
          schema:
            example: '{"name":"ASC","lastUpdateAt":"DESC"}'
            type: string
        - name: distinct
          required: false
          in: query
          description: >-
            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.
          schema:
            example: category,global
            type: string
        - name: fields
          required: false
          in: query
          description: >-
            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.
          schema:
            example: >-
              ["databaseId","name",{"fn":"COUNT","args":["users.userId"],"as":"userCount","filterType":"number"}]
            type: string
        - name: joins
          required: false
          in: query
          description: >-
            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.
          schema:
            example: >-
              [{"table":"groups_users","alias":"gu","type":"left","on":{"left":"gu.groupsGroupId","op":"=","right":"g.groupId"}}]
            type: string
        - name: groupBy
          required: false
          in: query
          description: >-
            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.
          schema:
            example: '["category","global"]'
            type: string
        - name: cast
          required: false
          in: query
          description: >-
            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.
          schema:
            example: '{"userCount":"INTEGER"}'
            type: string
        - name: with
          required: false
          in: query
          description: >-
            Optional QueryWrapper CTE definitions as a JSON string or
            bracket-style query object. Only honored by endpoints that
            explicitly enable dynamic CTEs.
          schema:
            example: >-
              [{"name":"active_groups","query":{"from":{"table":"groups","alias":"g","definition":[]}}}]
            type: string
        - name: debug
          required: false
          in: query
          description: >-
            Enable QueryWrapper debug output for the request, including compiled
            SQL, bound params, and bounded EXPLAIN plans when the underlying
            query service supports it.
          schema:
            example: false
            type: boolean
        - name: join
          required: false
          in: query
          description: >-
            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.
          schema:
            example: '{"orders":["customerId","customerId","left"]}'
            type: string
        - name: retention
          required: false
          in: query
          description: >-
            Export file retention. Omit for the destination default, set null
            for no expiration, or provide exactly one of ttlSeconds and
            expiresAt.
          schema:
            nullable: true
            example:
              ttlSeconds: 604800
            allOf:
              - $ref: '#/components/schemas/StorageRetentionDto'
        - name: delimiter
          required: false
          in: query
          description: >-
            CSV field delimiter. Defaults to a comma and must contain fewer than
            10 characters.
          schema:
            example: '|'
            type: string
        - name: boolType
          required: false
          in: query
          description: CSV boolean representation.
          schema:
            example: boolean
            type: string
            enum:
              - emoji
              - number
              - boolean
        - name: emptyNull
          required: false
          in: query
          description: Write null values as empty CSV fields instead of the string null.
          schema:
            type: boolean
            example: true
        - name: encodedJson
          required: false
          in: query
          description: Base64-encode JSON and JSONB values in the CSV output.
          schema:
            example: false
            type: boolean
        - name: storageDestination
          required: false
          in: query
          description: >-
            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.
          schema:
            example: ROOT
            type: string
        - name: fileName
          required: false
          in: query
          description: >-
            Dedicated CSV export file name. Path separators are not allowed.
            Omit to generate a database-and-timestamp name.
          schema:
            example: contracts-full.csv
            type: string
        - name: restricted
          required: false
          in: query
          description: >-
            Whether the exported storage entry is restricted. Defaults to true.
            Restricted ancestors still apply when exporting into a folder.
          schema:
            default: true
            example: false
            type: boolean
      responses:
        '202':
          description: ''
      security:
        - bearer: []
components:
  schemas:
    StorageRetentionDto:
      type: object
      properties:
        ttlSeconds:
          type: number
          description: >-
            Positive lifetime in seconds. The lifetime starts when the file is
            finalized.
          minimum: 1
        expiresAt:
          type: string
          description: Absolute future expiration timestamp in ISO 8601 format.
          example: '2026-08-01T12:00:00.000Z'
  securitySchemes:
    bearer:
      scheme: bearer
      bearerFormat: JWT
      description: Bearer JWT token or API Key (sk-*).
      type: http

````