title: How to query a json file?
body: <h2>Here is the file I would like to parse</h2>
  
  <ol>
  <li>I receive a file from a webservice in JSON format.</li>
  <li>I would like to parse the content in such a way that I display the name of the president from the USA</li>
  </ol>
  
  <blockquote>
  <pre><code>{
      "response": {
          "result": {
              "Countries": {
                  "row": [
                      {
                          "no": "1",
                          "FL": [
                              {
                                  "content": "USA",
                                  "val": "Country"
                              },
                              {
                                  "content": "Barack Obama",
                                  "val": "President"
                              }
                          ]
                      },
                      {
                          "no": "2",
                          "FL": [
                              {
                                  "content": "Cuba",
                                  "val": "Country"
                              },
                              {
                                  "content": "Raul Castro",
                                  "val": "President"
                              }
                          ]
                      }
                  ]
              }
          }
      }
  }
  </code></pre>
  </blockquote>
  
  <h2>The expected output</h2>
  
  <pre><code>{ presidents: [
      { "name": "Barack Obama"}
      ]
  }
  </code></pre>
  
  <h2>could you provide a solution using a kind of JSON XPath?</h2>