title: How to fetch the value from the Json based on Named key in kusto query(KQL) language
body: <p>I have a json field in log analytics workspace and structure looks something like below</p>
  <pre><code>{
  &quot;AdditionalDetails&quot;: [
      {
          &quot;value&quot;: &quot;SomeValue&quot;,
          &quot;key&quot;: &quot;SomeKey&quot;
      },
      {
          &quot;value&quot;: &quot;SomeValue&quot;,
          &quot;key&quot;: &quot;SomeKey&quot;
      },
      {
          &quot;value&quot;: &quot;somevalue&quot;,
          &quot;key&quot;: &quot;somekey&quot;
      },
      {
          &quot;value&quot;: &quot;SomeTicketNumber&quot;,
          &quot;key&quot;: &quot;TicketNumber&quot;
      },
      {
          &quot;value&quot;: &quot;1/1/0001 6:00:00 AM&quot;,
          &quot;key&quot;: &quot;ExpirationTime&quot;
      }
  ]
  </code></pre>
  <p>}
  I am using Kusto query to filter this data based on the key value Ticket number. Once I remove all other columns I have find out the actual ticket number captured in the value.</p>
  <p>I have tried mvexpand, mv-expand and I get something like below.</p>
  <pre><code>print d = dynamic ({
      &quot;AdditionalDetails&quot;: [
          {
              &quot;value&quot;: &quot;SomeValue&quot;,
              &quot;key&quot;: &quot;SomeKey&quot;
          },
          {
              &quot;value&quot;: &quot;SomeValue&quot;,
              &quot;key&quot;: &quot;SomeKey&quot;
          },
          {
              &quot;value&quot;: &quot;somevalue&quot;,
              &quot;key&quot;: &quot;somekey&quot;
          },
          {
              &quot;value&quot;: &quot;SomeTicketNumber&quot;,
              &quot;key&quot;: &quot;TicketNumber&quot;
          },
          {
              &quot;value&quot;: &quot;1/1/0001 6:00:00 AM&quot;,
              &quot;key&quot;: &quot;ExpirationTime&quot;
          }
      ]
  })
  | project details = d.['AdditionalDetails'] 
  | mvexpand details
  | project  ticketnumber = details
  </code></pre>
  <p>Output</p>
  <pre><code>{&quot;value&quot;:&quot;SomeValue&quot;,&quot;key&quot;:&quot;SomeKey&quot;}
  {&quot;value&quot;:&quot;SomeValue&quot;,&quot;key&quot;:&quot;SomeKey&quot;}
  {&quot;value&quot;:&quot;somevalue&quot;,&quot;key&quot;:&quot;somekey&quot;}
  {&quot;value&quot;:&quot;SomeTicketNumber&quot;,&quot;key&quot;:&quot;TicketNumber&quot;}
  {&quot;value&quot;:&quot;1/1/0001 6:00:00 AM&quot;,&quot;key&quot;:&quot;ExpirationTime&quot;}
  </code></pre>
  <p>requirement is to get only row where the key name is ticketnumber, once i have the row I should be able to project ticket number as column, any suggestion?</p>
  <p><em>Note : I was able to get the value of the ticket based on the index but Json structure is dynamic so I can't hardcode the index.</em></p>