title: Azure Log Analytics parse json
body: <p>I have a query which results in a few columns but one of the columns, I am parsing JSON to retrieve the object value but there are multiple entries in it I want each entry in JSON to retrieve in a loop and display.</p>
  <p>Below is the query,</p>
  <pre><code>let forEach_table = AzureDiagnostics
  | where Parameters_LOAD_GROUP_s contains 'LOAD(AUTO)';
  let ParentPlId = '';
  let ParentPlName = '';
  let commonKey = '';
  forEach_table
  | where Category == 'PipelineRuns'
  | extend pplId = parse_json(Predecessors_s)[0].PipelineRunId, pplName = parse_json(Predecessors_s)[0].PipelineName
  | extend dbMapName = tostring(parse_json(Parameters_getMetadataList_s)[0].dbMapName)
  | summarize count(runId_g) by Resource, Status = status_s, Name=pipelineName_s, Loadgroup = Parameters_LOAD_GROUP_s, dbMapName, Parameters_LOAD_GROUP_s, Parameters_getMetadataList_s, pipelineName_s, Category, CorrelationId, start_t, end_t, TimeGenerated
  | project ParentPL_ID = ParentPlId, ParentPL_Name = ParentPlName, LoadGroup_Name = Loadgroup, Map_Name = dbMapName, Status,Metadata = Parameters_getMetadataList_s, Category,  CorrelationId, start_t, end_t
  | project-away ParentPL_ID, ParentPL_Name, Category, CorrelationId
  </code></pre>
  <p>here in the above code,</p>
  <pre><code>extend dbMapName = tostring(parse_json(Parameters_getMetadataList_s)[0].dbMapName)
  </code></pre>
  <p>I am retrieving 0th element as default but I would like to retrieve all elements in sequence can somebody suggest me how to achieve this.</p>