---
title: "POST /api/dataset/{export-format}"
method: POST
path: "/api/dataset/{export-format}"
tags: ["/api/dataset"]
---

# POST /api/dataset/{export-format}

`POST /api/dataset/{export-format}`

Execute a query and download the result data as a file in the specified format.

## Path parameters

- `export-format` 'csv' | 'api' | 'xlsx' | 'json', required — Schema for valid export formats for downloading query results.

## Request body

- object
  - `format_rows` boolean, required
  - `pivot_results` boolean, required
  - `query` object, required
  - `visualization_settings` object, required

## Response `2XX`

Successful response

- MetabaseQueryProcessorSchemaQueryResult — Schema for query execution results returned by the Query Processor.
  - `average_execution_time` integer, nullable
  - `cached` string, nullable
  - `context` unknown
  - `data` MetabaseQueryProcessorSchemaQueryResultData — Schema for the :data key of query results.
    - `cols` MetabaseQueryProcessorSchemaResultMetadataColumn[], required — unresolved $ref
    - `download_perms` string
    - `format-rows?` boolean
    - `insights` object[]
    - `is_sandboxed` boolean
    - `native_form` object
    - `results_metadata` object
      - `columns` MetabaseQueryProcessorSchemaResultMetadataColumn[], required — unresolved $ref
    - `results_timezone` string
    - `rows` array[], required
      - unknown[]
        - unknown
  - `database_id` integer — Valid Database ID
  - `error` string
  - `error_type` string
  - `json_query` object
  - `row_count` integer, required
  - `running_time` integer
  - `started_at` string
  - `status` 'completed' | 'failed', required

## Other responses

- `4XX` — Client error response
- `5XX` — Server error response

---

[API](https://skmtc.dev/metabase/apis/metabase-api.md) · [All operations](https://skmtc.dev/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/metabase/metabase-api/revisions/e879e0319b12/schema)