Skip to content
This repository has been archived by the owner on Jun 5, 2023. It is now read-only.

Latest commit

 

History

History
89 lines (47 loc) · 1.8 KB

dataset.md

File metadata and controls

89 lines (47 loc) · 1.8 KB
Raw
title summary
Dataset
/api/dataset endpoints.

Dataset

/api/dataset endpoints.

POST /api/dataset/

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

PARAMS:

  • database value may be nil, or if non-nil, value must be an integer.

  • query

POST /api/dataset/:export-format

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

PARAMS:

  • export-format value must be one of: api, csv, json, xlsx.

  • query value must be a valid JSON string.

  • visualization_settings value must be a valid JSON string.

POST /api/dataset/duration

Get historical query execution duration.

PARAMS:

  • database

  • query

POST /api/dataset/native

Fetch a native version of an MBQL query.

PARAMS:

  • database value must be an integer greater than zero.

  • pretty nullable boolean

  • query

POST /api/dataset/parameter/search/:query

Return parameter values for cards or dashboards that are being edited. Expects a query string at ?query=foo.

PARAMS:

  • query string

  • parameter parameter must be a map with :id and :type keys

  • field_ids nullable sequence of value must be an integer greater than zero.

POST /api/dataset/parameter/values

Return parameter values for cards or dashboards that are being edited.

PARAMS:

  • parameter parameter must be a map with :id and :type keys

  • field_ids nullable sequence of value must be an integer greater than zero.

POST /api/dataset/pivot

Generate a pivoted dataset for an ad-hoc query.

PARAMS:

  • database value may be nil, or if non-nil, value must be an integer.

  • query

<< Back to API index