title: Accessing values in JSON array
body: <p>I am following the instruction in the documentation for how to access JSON values in CloudWatch Insights where the recomendation is as follows </p>
  
  <pre><code>JSON arrays are flattened into a list of field names and values. For example, to specify the value of instanceId for the first item in requestParameters.instancesSet, use requestParameters.instancesSet.items.0.instanceId.
  </code></pre>
  
  <p>ref
  <a href="https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/CWL_AnalyzeLogData-discoverable-fields.html" rel="nofollow noreferrer">https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/CWL_AnalyzeLogData-discoverable-fields.html</a></p>
  
  <p>I am trying the following and getting nothing in return. The intellisense autofills up to <code>processList.0</code> but no further</p>
  
  <pre><code>fields processList.0.vss
  | sort @timestamp desc
  | limit 1
  </code></pre>
  
  <p>The JSON I am woking with is </p>
  
  <pre><code>"processList": [
          {
              "vss": xxxxx,
              "name": "aurora",
              "tgid": xxxx,
              "vmlimit": "unlimited",
              "parentID": 1,
              "memoryUsedPc": 16.01,
              "cpuUsedPc": 0.01,
              "id": xxxxx,
              "rss": xxxxx
          },
          {
              "vss": xxxx,
              "name": "aurora",
              "tgid": xxxxxx,
              "vmlimit": "unlimited",
              "parentID": 1,
              "memoryUsedPc": 16.01,
              "cpuUsedPc": 0.06,
              "id": xxxxx,
              "rss": xxxxx
          }]
  </code></pre>