---
title: "GET /datainsights/v1.1/explore"
method: GET
path: "/datainsights/v1.1/explore"
tags: ["Explore"]
---

# GET /datainsights/v1.1/explore

`GET /datainsights/v1.1/explore`

## Query parameters

- `question` string, required
- `dataset_id` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9, required

## Headers

- `X-PROPERTY-ID` integer, required

## Response `200`

OK

- Explore
  - `data` ReportData
    - `headers` unknown[], required — Column headers that list columns names. The order of headers is the same as those specified in the request through the columns property. The number of headers is the number of columns.
      - unknown
    - `index` array[], required — List of index distinct names
      - string[]
    - `group_rows` string[], required — List of CDF names of group rows
    - `group_columns` string[], required — List of CDF names of group columns
    - `periods` string[] — List of names of the periods being compared
    - `records` object, required — Dictionary of records of column value combinations and metric values in the report
    - `subtotals` object, required — Dictionary of subtotals in the report
    - `totals` object, required — Dictionary of totals in the report
    - `type` string, required — Type of the report generated
    - `comparisons` string[] — List of names of the comparisons being made
    - `aggregated_count` integer — Number of rows included in aggregations in the report
  - `summary` ReportSummary
    - `total` integer, required — Total records on the report
    - `metrics` object, required — Dictionary of metric columns
  - `meta` ExploreMeta
    - `dataset_id` integer, required
    - `filters` ReportFilters
      - `and` ReportFilter[]
        - `and` ReportFilter[]
        - `or` ReportFilter[]
        - `cdf` ReportCDF
          - `type` 'default' | 'custom' — Report cdf type
          - `column` string, required — Report cdf name
          - `multi_level_id` 1 | 2 | 3 | 4 — Multi-level where CDF is located
        - `operator` 'begins' | 'not_begins' | 'ends' | 'not_ends' | 'contains' | 'not_contains' | 'list_contains' | 'not_list_contains' | 'is_null' | 'is_not_null' | 'is_empty' | 'is_not_empty' | 'equals' | 'not_equals' | 'greater_than' | 'less_than' | 'less_than_or_equal' | 'greater_than_or_equal' — Filter operator value
        - `value` unknown
      - `or` ReportFilter[]
        - `and` ReportFilter[]
        - `or` ReportFilter[]
        - `cdf` ReportCDF
          - `type` 'default' | 'custom' — Report cdf type
          - `column` string, required — Report cdf name
          - `multi_level_id` 1 | 2 | 3 | 4 — Multi-level where CDF is located
        - `operator` 'begins' | 'not_begins' | 'ends' | 'not_ends' | 'contains' | 'not_contains' | 'list_contains' | 'not_list_contains' | 'is_null' | 'is_not_null' | 'is_empty' | 'is_not_empty' | 'equals' | 'not_equals' | 'greater_than' | 'less_than' | 'less_than_or_equal' | 'greater_than_or_equal' — Filter operator value
        - `value` unknown
    - `sort` ReportSort[]
      - `cdf` ReportCDF, required
        - `type` 'default' | 'custom' — Report cdf type
        - `column` string, required — Report cdf name
        - `multi_level_id` 1 | 2 | 3 | 4 — Multi-level where CDF is located
      - `direction` 'asc' | 'desc', required — Report sort direction
    - `columns` ReportColumns[]
      - `cdf` ReportCDF, required
        - `type` 'default' | 'custom' — Report cdf type
        - `column` string, required — Report cdf name
        - `multi_level_id` 1 | 2 | 3 | 4 — Multi-level where CDF is located
      - `metrics` string[] — Report column metrics
    - `group_rows` ReportGroup[], nullable
      - `cdf` ReportCDF, required
        - `type` 'default' | 'custom' — Report cdf type
        - `column` string, required — Report cdf name
        - `multi_level_id` 1 | 2 | 3 | 4 — Multi-level where CDF is located
      - `modifier` 'second' | 'minute' | 'hour' | 'day' | 'month' | 'year' | 'week' | 'weekday' | 'd' | 'm' | 'time_hour' | 'time_minute' | 'time_second' — Report group modifier
    - `settings` ReportSettings
      - `details` boolean, required — Report details
      - `totals` boolean, required — Report totals
      - `transpose` boolean — Transpose Report

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `404` — Not Found
- `500` — Internal Server Error

---

[API](https://skmtc.net/cloudbeds/apis/cloudbeds-api.md) · [All operations](https://skmtc.net/cloudbeds/apis/cloudbeds-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cloudbeds/cloudbeds-api/revisions/2faa857793e8/schema)