handling-nested-json

handling-nested-json.ps1

$json = '{
    "keystores": {
      "/usr/local/cert/foo/cert1.jks:signing1": {
        "days_remaining": 629,
        "issuer": "C=SE O=Inera AB CN=SITHS Type 3 CA v1 PP",
        "owner": "C=SE L=Vanersborg O=Vastra Gotalands Lans Landsting CN=footest.vgregion.se serialNumber=12345"
      },      
      "/usr/local/cert/foo/cert1.jks:signing2": {
        "days_remaining": 629,
        "issuer": "C=SE O=Inera AB CN=SITHS Type 3 CA v1 PP",
        "owner": "C=SE L=Vanersborg O=Vastra Gotalands Lans Landsting CN=footest.vgregion.se serialNumber=12345"
      },
      "/usr/local/cert/foo/cert1.jks:encryption1": {
        "days_remaining": 594,
        "issuer": "C=SE L=Stockholm O=Foo AB OU=Foo CN=Foo Bar Root",
        "owner": "serialNumber=12345 C=SE O=Foo AB OU=Foo CN=encryption"
      },
      "/usr/local/cert/foo.domain.org_siths_type3_ca_v1_pp_auth.p12:1": {
        "days_remaining": 531,
        "issuer": "C=SE O=Inera AB CN=SITHS Type 3 CA v1 PP",
        "owner": "C=SE L=Vanersborg O=Vastra Gotalands Lans Landsting CN=footest.vgregion.sjunet.org serialNumber=1234"
      },
      "/usr/local/cert/footest.domain.com_siths_type3_ca_v1_pp_auth.p12:1": {
        "days_remaining": 537,
        "issuer": "C=SE O=Inera AB CN=SITHS Type 3 CA v1 PP",
        "owner": "C=SE L=Vanersborg O=Vastra Gotalands Lans Landsting CN=footest.vgregion.se serialNumber=1234"
      }
    }
  }'

$o = $json | ConvertFrom-Json
foreach ($info in $o.keystores.PSObject.Properties) {
    [pscustomobject]@{
    "Name"=$info.Name;
    "Days_Remaining"=$info.Value.days_remaining;
    "Issuer"=$info.Value.issuer;
    "Owner"=$info.Value.owner
    }
}