How can we improve Application Insights?

String comparison within JSON objects

I am logging entire JSON objects and I would like to query the API based on attributes of these objects. For instance I am logging request headers to the database and when I query the API I want to query something like:

traces | extend properties = customDimensions.req_headers
| where properties.["connection"] == "keep-alive"
| project timestamp, properties

Right now I am getting 0 results with that query. It is possible to click a small "+" button next to my "connection" field of the JSON object which adds exactly the line
| where properties.["connection"] == "keep-alive"
to my query so I presume that this feature is going to be implemented in the release version? Is it going to work with more nested Strings as well? For instance properties.["myObject"].["otherObject"].["attribute1"]. Such a feature would be very handy.

4 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Iain commented  ·   ·  Flag as inappropriate

        This is effectively asking to use App Insights as a general-purpose Document Database, with automatic indexing on arbitrary properties. Right?

        'It is possible to click a small "+" button next to.......'

        It is no longer possible. You can still unfold JSON documents in the UI, but the button does not appear next to the properties within them.

      Feedback and Knowledge Base