title: Powershell - JSON file to table
body: <p>I am trying to get into Powershell and am trying to convert a simple JSON file to table format.</p>
  
  <p>The json-file looks like this:</p>
  
  <pre><code>{ "Members" : [
  { "Id" : 1,
      "Details" : [ { "FirstName" : "Adam" }, { "LastName" : "Ant" } ] },
  { "Id" : 2,
      "Details" : [ { "FirstName" : "Ben" }, { "LastName" : "Boggs" } ] },
  { "Id" : 3,
      "Details" : [ { "FirstName" : "Carl"} , { "LastName" : "Cox" } ] }
  ]
  }
  </code></pre>
  
  <p>Powershell expression:</p>
  
  <pre><code>$jString.Members.details | Select-Object -Property Id, FirstName, LastName
  </code></pre>
  
  <p>output so far (best I got).. id missing</p>
  
  <pre><code>Id  FirstName   LastName
  --  ---------   --------
      Adam        Ant
      Ben         Boggs
      Carl        Cox
  </code></pre>
  
  <p>How would I accomplish that?</p>
  
  <p>Any help appreciated</p>