title: U-SQL - Extract data from json-array
body: <p>Already tried the suggested JSONPath option, but it seems the JSONExtractor only recognizes root level. In my case I have to deal with a nested json-structure, with an array as well (see example below). Any options for extracting this without multiple intermediate files?</p>
  
  <pre><code>"relation": {
  "relationid": "123456",
  "name": "relation1",
  "addresses": {
      "address": [{
          "addressid": "1",
          "street": "Street 1",
          "postcode": "1234 AB",
          "city": "City 1"
          },
      {
          "addressid": "2",
          "street": "Street 2",
          "postcode": "5678 CD",
          "city": "City 2"
      }]
  }}
  </code></pre>
  
  <p>SELECT relationid, addressid, street, postcode, city ?</p>