Powershell with JSON nested objects - cannot get to a property of property of object

Question

I'm quite new to Powershell and currently I'm trying to convert some data from JSON I downloaded from Solr.

The JSON file looks like:

{
 "responseHeader": {"status":0, "QTime":2651},
"InitFailures":{}, 
"status":{
   "YX_SERVER.ONE_LOG.2020-11-07_07_49_33": {
         "name":"SERVER.ONE_LOG.2020-11-07_07_49_33",
            "index":{
               "sizeInBytes":69,
                "size":"69 bytes"}},
 "XY_SERVER.TWO_LOG.2020-11-08_09_52_11": {
         "name":"XY_SERVER.TWO_LOG.2020-11-08_09_52_11",
            "index":{
               "sizeInBytes":6487,
                    "size":"6487 bytes"}},
 "ZX_SERVER.THREE_LOG.2020-10-07_07_42_23": {
         "name":"SERVER.THREE_LOG.2020-10-07_07_42_23",
            "index":{
               "sizeInBytes":6977,
               "size":"6977 bytes"
                              }}}}

Below the second status line is the list of the servers with numerous parameters(all names are different), I tried to go deeper into it, but need help with nested data.

I tried the following:

$list = Get-Content C:\Users\User\Download\cores.json - Raw |convertfrom-json |select-object -ExpandProperty status

Then $list shows me the list of servers and the data needed is in the right column but I cannot access it directly. How can I build the table and calculate the sum just like follows:

Name                                     Size(inbytes) 
YX_SERVER.ONE_LOG.2020-11-07_07_49_33    69
XY_SERVER.TWO_LOG.2020-11-08_09_52_11    6487
ZX_SERVER.THREE_LOG.2020-10-07_07_42_23  6977

Summary                                  Total size
                                         ?

iRon · Accepted Answer · 2020-11-26 16:04:38Z

1

$Content = Get-Content .\cores.json
$Data = $Content | ConvertFrom-Json
$Status = $Data.status
$Table = $Status.PSObject.Properties.Value | Foreach-Object {
    [pscustomobject]@{
        name = $_.name
        sizeInBytes = $_.index.sizeInBytes
    }
}
$Table

[pscustomobject]@{
    name = 'Total Size:'
    sizeInBytes = ($Table.sizeInBytes | Measure-Object -Sum).Sum
}

name                                  sizeInBytes
----                                  -----------
SERVER.THREE_LOG.2020-10-07_07_42_23         6977
XY_SERVER.TWO_LOG.2020-11-08_09_52_11        6487
SERVER.ONE_LOG.2020-11-07_07_49_33             69
Total Size:                                 13533

edited Nov 26, 2020 at 16:04

answered Nov 26, 2020 at 12:37

iRon

24.4k10 gold badges60 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Roman Over a year ago

Sorry for that typo in JSON! I edited and validated it. Unfortunately -ashashtable option was introduced in Powershell 6.0. And I only have 5.0 installed. Is there any other way to do this?

iRon Over a year ago

I have updated the answer for older versions of PowerShell that do not support -AsHashTable in which case you might simply enumerate the $Status.PSObject.Properties.Value member

Roman Over a year ago

That perfectly helped! Thank YOU so MUCH! You're amazing! ^__^

Collectives™ on Stack Overflow

Powershell with JSON nested objects - cannot get to a property of property of object

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related