arraysjsonparsingkqlappinsights

How could I parse the json array in Kusto?


How could I parse the json array in Kusto?

Here is what I tried:

customEvents
| where name == "myname"
| project a = parse_json(customDimensions.Content)
| extend b = a[0].Section;

enter image description here

But as you can see the b still remains empty and never gets initialized to the Section value. While, according to the KQL documentation it should work.


Solution

  • Have you tried using "Extend Column"?

    enter image description here