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

# Drillthrough Query

> Reference for the `DTQuery` query type in a DEE order, used to run a drillthrough extraction with `pivotId`, `locations`, `measures`, and pagination through `firstResult` and `maxResults`.

## JSON structure

```json theme={"languages":{"custom":["/engine/python-sdk/6.2/languages/pycon.tmLanguage.json"]}}
"queries" : [
  {
    "@type": "DTQuery",
    "pivotId": "",
    "context": {
      "key": "value"
    },
    "locations": [
      "a|b|c|d",
      "x|y|z"
    ], 
    "measures": [
      "measure1",
      "measure2"
    ], 
    "isFormatted": true, 
    "firstResult": 0,
    "maxResults": 1000
  }
]
```

## Property details

| Property | Values | Default Value |
| - | - | - |
| pivotId | Name of Cube | |
| context | Map - Context values | |
| locations | List of String locations | |
| measures | List of String - Measure names | |
| isFormatted | Boolean | True |
| firstResult | Integer - index of first result | |
| maxResults | Integer - Maximum number of results | |