2

I am using Application Insights Log-Explorer query window to visualize the below query. Inside the field customDimensions.RemotePC I am string a json payload.

When I try to index the stored json via propery-indexing, i get the value as null. I tried to access it as array that turns null as well.

Could you please help me to access the FirstName property in below diagram.

enter image description here

John Gardner
  • 24,225
  • 5
  • 58
  • 76
Raghav
  • 2,890
  • 7
  • 36
  • 56
  • I've tried to reproduce it, but I couldn't. Could you please post output of `traces | project test = '{"a": 1}' | project tst = parse_json(test) | extend tst.a`. In my case, `tst_a` column has value of `1` in every row – geobreze Apr 29 '21 at 13:18
  • see similar: https://stackoverflow.com/questions/46164988/application-insights-extract-nested-customdimensions/46166100#46166100 – John Gardner Apr 30 '21 at 18:21

1 Answers1

6

Try this:

| extend todynamic(tostring(rpc)).FirstName

I believe that the issue is that rpc is string (although it looks as json). Thus you need to "cast" it to dynamic. You first need to tell the compiler though that this is a string value.

Avnera
  • 7,088
  • 9
  • 14