Query - Execute

Reference

Service:: Application Insights

API Version:: v1

Execute an Analytics query
Executes an Analytics query for data. Here is an example for using POST with an Analytics query.

POST https://api.applicationinsights.io/v1/apps/{appId}/query

URI Parameters

Name	In	Required	Type	Description
appId	path	True	string	ID of the application. This is Application ID from the API Access settings blade in the Azure portal.

Request Body

Name	Required	Type	Description
query	True	string	The query to execute.
applications		string[]	A list of Application IDs for cross-application queries.
timespan		string	Optional. The timespan over which to query data. This is an ISO8601 time period value. This timespan is applied in addition to any that are specified in the query expression.

Responses

Name	Type	Description
200 OK	queryResults	Successful response
Other Status Codes	errorResponse	An error response object.

Security

oauth2

Connect to Azure Application Insights API

Type: oauth2
Flow: implicit
Authorization URL: https://login.microsoftonline.com/common/oauth2/authorize?resource=https%3A%2F%2Fapi.applicationinsights.io

Scopes

Name	Description
user_impersonation	impersonate your user account

Examples

queryPost

Sample Request

HTTP

POST https://api.applicationinsights.io/v1/apps/34adfa4f-cedf-4dc0-ba29-b6d1a69ab345/query

{
  "timespan": "PT12H",
  "query": "requests | summarize count() by bin(timestamp, 1h)"
}

Sample Response

Status code:: 200

x-ms-request-id: 58a37988-2c05-427a-891f-5e0e1266fcc5
x-ms-correlation-request-id: 58a37988-2c05-427a-891f-5e0e1266fcc5

Response Body

{
  "tables": [
    {
      "name": "PrimaryResult",
      "columns": [
        {
          "name": "timestamp",
          "type": "datetime"
        },
        {
          "name": "count_",
          "type": "long"
        }
      ],
      "rows": [
        [
          "2018-02-02T05:00:00Z",
          "255"
        ],
        [
          "2018-02-01T17:00:00Z",
          "148"
        ],
        [
          "2018-02-01T18:00:00Z",
          "453"
        ],
        [
          "2018-02-01T19:00:00Z",
          "404"
        ],
        [
          "2018-02-01T20:00:00Z",
          "403"
        ],
        [
          "2018-02-01T21:00:00Z",
          "405"
        ],
        [
          "2018-02-01T22:00:00Z",
          "438"
        ],
        [
          "2018-02-01T23:00:00Z",
          "403"
        ],
        [
          "2018-02-02T00:00:00Z",
          "423"
        ],
        [
          "2018-02-02T01:00:00Z",
          "403"
        ],
        [
          "2018-02-02T02:00:00Z",
          "425"
        ],
        [
          "2018-02-02T03:00:00Z",
          "437"
        ],
        [
          "2018-02-02T04:00:00Z",
          "420"
        ]
      ]
    }
  ]
}

Definitions

Name	Description
column	A table column.
errorDetail	Error details.
errorInfo	The code and message for an error.
errorResponse	Error details.
queryBody	The Analytics query. Learn more about the Analytics query syntax
queryResults	A query response.
table	A query response table.

column

A table column.

Name	Type	Description
name	string	The name of this column.
type	string	The data type of this column.

errorDetail

Error details.

Name	Type	Description
additionalProperties	object
code	string	The error's code.
message	string	A human readable error message.
resources	string[]	Indicates resources which were responsible for the error.
target	string	Indicates which property in the request is responsible for the error.
value	string	Indicates which value in 'target' is responsible for the error.

errorInfo

The code and message for an error.

Name	Type	Description
additionalProperties	object
code	string	A machine readable error code.
details	errorDetail[]	error details.
innererror	errorInfo	The code and message for an error. Inner error details if they exist.
message	string	A human readable error message.

errorResponse