Powershell ConvertFrom-Json accessing json value

Question

I have a json file that I'd like to convert to csv. However, the actual value is nested inside reading key that I need to access. It returns System.Object[] in which I know I have to access this, but I don't know how.

the following is the result.json file,

{"totalNumberOfReadings":1488,
    "readings":
        [
           {"meterNumber":"xxxxx","date":"2022-02-01 00:00","reading":0.0,"status":"AsRequested"},
           {"meterNumber":"xxxxx","date":"2022-01-31 23:30","reading":0.0,"status":"As Requested"},
           {"meterNumber":"xxxxx","date":"2022-01-31 23:00","reading":0.0,"status":"As Requested"},
           {"meterNumber":"xxxxx","date":"2022-01-31 23:00","reading":0.0,"status":"As Requested"},
        ]
}

My script is like this

C:\> (Get-Content -Raw result.json | ConvertFrom-Json) | ConvertTo-Csv -NoTypeInformation

the output is this

"totalNumberOfReadings","readings"
"1488","System.Object[]"

This is just the summary/metadata. I want the actual content inside the key's value, how to access the value?

zett42 · Accepted Answer · 2022-05-31 10:12:39Z

2

Either use member access:

(Get-Content -Raw result.json | ConvertFrom-Json).readings | ConvertTo-Csv -NoTypeInformation

...or only pipeline commands:

Get-Content -Raw result.json | ConvertFrom-Json | ForEach-Object readings | ConvertTo-Csv -NoTypeInformation

ForEach-Object readings is the short form of ForEach-Object -MemberName readings.

answered May 31, 2022 at 10:12

zett42

28.3k3 gold badges44 silver badges97 bronze badges

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

1 Comment

sutan Over a year ago

thanks, the first one works just fine for me!

Collectives™ on Stack Overflow

Powershell ConvertFrom-Json accessing json value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related