title: How to transform a JSON array of objects to a Kusto table?
body: <p>I have a JSON schema that I get from the server and I need to transform this JSON into a log analytics query language table and use that table to make a join with another table.</p>
  
  <p>The JSON has the following schema: </p>
  
  <pre><code>[{
     "X": "xyz",
     "Y": "xyz",
     "Z": "xyz",
     "prop1": "value1",
     "prop2": "value2",
     "prop3": "value3"
  }, {
       "X": "xyz",
       "Y": "xyz",
       "Z": "xyz",
       "prop1": "value1",
       "prop2": "value2",
       "prop3": "value3"
  }]
  </code></pre>
  
  <p>I tried this : </p>
  
  <pre><code>let table = todynamic('[{
    "X": "xyz",
    "Y": "xyz",
    "Z": "xyz",
    "prop1": "value1",
    "prop2": "value2", 
    "prop3": "value3"
  }, {
    "X": "xyz",
    "Y": "xyz",
    "Z": "xyz",
    "prop1": "value1",
    "prop2": "value2",
    "prop3": "value3"
  ]');
  </code></pre>
  
  <p>But this does not convert the JSON into something that can be used in a join with other tables. </p>
  
  <p>Any help will be very appreciated.</p>