Split nested JSON

[D.Demarest]

I have a field named "ModifiedProperties" and it has values like this below, I cant for the life of me figure out how XQL splits these up, Splunk uses SPAN or MVexpand and it works like a champ but i cant figure out what function does the same thing in XQL.  THANK YOU! 

[

  {

    "Name": "StrongAuthenticationRequirement",

    "NewValue": "[]",

    "OldValue": "[\r\n  {\r\n    \"RelyingParty\": \"*\",\r\n    \"State\": 0,\r\n    \"RememberDevicesNotIssuedBefore\": \"2017-10-13T16:59:21+00:00\",\r\n    \"ConfigStore\": null\r\n  }\r\n]"

  },

  {

    "Name": "Included Updated Properties",

    "NewValue": "StrongAuthenticationRequirement",

    "OldValue": ""

  },

  {

    "Name": "TargetId.UserType",

    "NewValue": "Member",

    "OldValue": ""

  }

]

[Fm12345]

Which key are you trying to extract?

For e.g: we can extract name key from all jsons within the array as below.

alter namearr=arraymap (modifiedproperties,"@element"->Name)

|Arrayexpand namearr.

This way we will get the Name key expanded.