Cancel a query

• Latest Dynatrace
• Reference
• Published Oct 13, 2026

Cancel a running Dynatrace Grail query and return its result if it already finished, using the Query API request token to identify it.

Overview

For information about the required permissions see the Bucket and table permissions in Grail documentation.

Cancels a running Grail query and returns a list of records if the query already finished.

The response format

If the query was already finished, a response body including the result will be returned. Otherwise the response will contain no body.

The result has three main sections:

Every record has an implicit 'index' according to the position in the 'records' JSON array. The types section has a list of 1..N possible type 'buckets'. Each such bucket has an 'indexRange' which indicates which records will find their field types in which bucket. The index range has two values start & end and can be thought of as [startIndex, endIndex).

A field part of a record with index 'i' will find its corresponding field type by first locating the bucket that satisfies:

startIndex <= i <= endIndex

Once the bucket is found the 'mappings' object has an entry for all the fields that are part of that record with index 'i'.

Since enforcement of a particular schema is absent at ingestion time, it is possible to have records that share the same field name but their values are of a different type. This phenomenon will hence forth be named as a "collision". When a collision does occur, we will create a new type 'bucket' that will have a different index range where the new record field types will be placed. It is guaranteed that every field of every record will have a corresponding type. Clients should always take the included types into account when consuming records!

Authentication

To execute this request, you need a platform token or OAuth access token with one of the following scopes:

To learn how to obtain and use it, see Tokens and authentication.

Parameters

Response

{
  "metadata": {
    "grail": {
      "analysisTimeframe": {
        "end": "2023-03-10T11:02:00.705980000Z",
        "start": "2023-03-10T09:02:00.705980000Z"
      },
      "dqlVersion": "V1_0",
      "executionTimeMilliseconds": 18,
      "locale": "",
      "query": "fetch ...",
      "queryId": "92918dae-c2f9-4c98-b278-dc42adcc5954",
      "timezone": "Z"
    }
  },
  "progress": 100,
  "result": {
    "records": [
      {
        "davis.status": "OPEN",
        "davis.title": "Http monitor global outage",
        "davis.underMaintenance": "false",
        "timestamp": "2022-03-17T08:00:01.231000000Z"
      },
      {
        "davis.status": "OPEN",
        "davis.title": "Http monitor global outage",
        "davis.underMaintenance": "false",
        "timestamp": "2022-03-17T08:00:01.231000000Z"
      },
      {
        "davis.status": "OPEN",
        "davis.title": "Http monitor global outage",
        "davis.underMaintenance": "false",
        "timestamp": "2022-03-17T08:00:01.231000000Z"
      },
      {
        "davis.status": "OPEN",
        "davis.title": "Http monitor global outage",
        "davis.underMaintenance": "false",
        "timestamp": "2022-03-17T08:00:01.231000000Z"
      }
    ],
    "types": [
      {
        "indexRange": [
          0,
          3
        ],
        "mappings": {
          "davis.status": {
            "type": "string"
          },
          "davis.title": {
            "type": "string"
          },
          "davis.underMaintenance": {
            "type": "string"
          },
          "timestamp": {
            "type": "timestamp"
          }
        }
      }
    ]
  },
  "state": "SUCCEEDED"
}