title: Azure LogAnalytics Parse JSON Array
body: <p>I am ingesting some custom logs to Azure LogAnalytics. One of the columns contains nested json objects. I would like to return each nested object to a separate column value.</p>
  
  <p>Was trying the mvexpand statement but have not had any luck.</p>
  
  <pre><code>customLog_CL
  | extend test = parsejson(target_s)
  | mvexpand test
  </code></pre>
  
  <p>The column data looks like below.</p>
  
  <pre><code>[ { "id": "00phb49dl40lBsasC0h7", "type": "PolicyEntity", "alternateId": "unknown", "displayName": "Default Policy", "detailEntry": "@{policyType=hello}" }, { "id": "0pri9mxp9vSc4lpiU0h7", "type": "PolicyRule", "alternateId": "00phb49dl40lBsasC0h7", "displayName": "All Users Login", "detailEntry": null } ]
  </code></pre>