---
title: "POST /api/dataset"
method: POST
path: "/api/dataset"
tags: ["/api/dataset"]
---

# POST /api/dataset

`POST /api/dataset`

Execute a query and retrieve the results in the usual format. The query will not use the cache.

## Request body

- object
  - `database` integer, nullable

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