title: Jsonpath for nested JSON objects
body: <p>I have a JSON with nested fields:</p>
  
  <pre><code>  [
      {
      "Platform Parent Dato Id": "23768",
      "Platform Dato Id": "24138",
      "Platform Dato Name": "Random Europe",
      "Platform mission Id": "111112",
      "Platform submission Id": "638687",
      "Platform submission Flight Id": "863524",
      "Start Date": "2017-12-01",
      "End Date": "2017-12-02",
      "Platform Compensation": 109.0909,
      "Total Value": 909.0909,
      "Goal": "200000.0000",
      "Value Information": {
        "Platform Compensation": [
          {
            "Platform mission Id": "111112",
            "Platform submission Id": "638687",
            "Platform submission Flight Id": "863524",
            "Value Rate": "14.0000",
            "Value": 109.0909
          }
        ]
      }
    },
    {
      "Platform Parent Dato Id": "23768",
      "Platform Dato Id": "24138",
      "Platform Dato Name": "Random Europe",
      "Platform mission Id": "111113",
      "Platform submission Id": "638687",
      "Platform submission Flight Id": "863524",
      "Start Date": "2017-12-01",
      "End Date": "2017-12-02",
      "Platform Compensation": 109.0909,
      "Total Value": 909.0909,
      "Goal": "200000.0000",
      "Value Information": {
        "Platform Compensation": [
          {
            "Platform mission Id": "111113",
            "Platform submission Id": "638687",
            "Platform submission Flight Id": "863524",
            "Value Rate": "12.0000",
            "Value": 109.0909
          }
        ]
      }
    }
    ]
  </code></pre>
  
  <p>and I am using a JSONPATH in order to get the <code>Value Rate</code> from the <code>Value Information</code> nest.</p>
  
  <p>I have pasted my JSON text in this website: <a href="http://jsonpath.com/" rel="noreferrer">http://jsonpath.com/</a>
  and after using this line:</p>
  
  <pre><code>$[*].['Platform Compensation'].['Value Rate']
  </code></pre>
  
  <p>I am getting this:</p>
  
  <p><a href="https://i.stack.imgur.com/UL3OE.png" rel="noreferrer"><img src="https://i.stack.imgur.com/UL3OE.png" alt="enter image description here"></a></p>
  
  <p>and after using this line:</p>
  
  <pre><code>$.['Value Information'].['Platform Compensation'].['Platform mission Id']
  </code></pre>
  
  <p>I am getting this:</p>
  
  <p><a href="https://i.stack.imgur.com/Sg13z.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Sg13z.png" alt="enter image description here"></a></p>
  
  <p>What I am trying to return (output) is the following:</p>
  
  <p><a href="https://i.stack.imgur.com/m9m4W.png" rel="noreferrer"><img src="https://i.stack.imgur.com/m9m4W.png" alt="enter image description here"></a></p>
  
  <p>but I cannot find the right syntax to combine those two in one line and return both with one JSONPATH query.</p>