CODEWITHSUNDEEP
azure-application-insights
Praveen Reddy
Praveen Reddy

Reputation: 7383

Application Insights query property containing space

I have the following event which I would like to query using Analytics in Application Insights

{
    "Description": "Error",
    "EventData": {
       "AccountId": "123",
       "Exception Message": "Data at the root level is invalid.",
       "Error Type": "ExceptionThrown"
     }
}

I am able to query the property which does not contain spaces.

  Events | where Timestamp > ago(30min)
  | project Data.EventData.AccountId

How do I query a property which has spaces. The following query does not work

  Events | where Timestamp > ago(30min)
  | project Data.EventData.[Exception Message]

Upvotes: 0

Views: 1778

Answers (1)

James Davis - MSFT
James Davis - MSFT

Reputation: 1806

The array format accepts quotes.

Events | where Timestamp > ago(30min) | project Data.EventData.["Exception Message"]

Upvotes: 2

Related Questions