Parse JSON in Powershell

Question

I have a json file which has the below content. I want to iterate through each item (using foreach loop) in Powershell. How can I do it?

{ "abc": { "isSecret": null, "value": "'167401'" }, "dar": { "isSecret": null, "value": "8980" }, "hgt": { "isSecret": null, "value": "893240" }, "newvar1": { "isSecret": null, "value": "newvalue1" }, "var": { "isSecret": null, "value": "1230" } }

Powershell 7 has name, value pairs with convertfrom-json -AsHashtable — js2010
– js2010, Commented Nov 24, 2022 at 16:41

iRon · Accepted Answer · 2022-11-24 16:47:23Z

$Data = $Json |ConvertFrom-Json $Data.PSObject.Properties.Value isSecret value -------- ----- '167401' 8980 893240 newvalue1 1230

To iterate through the values:

$Data.PSObject.Properties.Value.ForEach{ Write-Host 'isSecret:' $_.isSecret Write-Host 'Value:' $_.Value }

TZHX · Accepted Answer · 2022-11-24 16:27:20Z

0

You can do something like:

$input = @' <your input here> '@ $json = $input | ConvertFrom-Json foreach($item in $json.PSObject.Properties) { Write-Output $item.Name Write-Output $item.Value.isSecret Write-Output $item.Value.value }

with your input, this gives me:

abc '167401' dar 8980 hgt 893240 newvar1 newvalue1 var 1230

as all your isSecret values are null they don't show any content.

edited Nov 24, 2022 at 16:27

answered Nov 24, 2022 at 16:05

TZHX

5,40616 gold badges51 silver badges60 bronze badges

4 Comments

Sourav Karmakar Over a year ago

I want to fetch ".isSecret" and ".value" for each item. Is there any way ?

Mathias R. Jessen Over a year ago

I downvoted this answer because it gives the illusion of iterating over the members of the root object, but it doesn't actually

TZHX Over a year ago

@MathiasR.Jessen fair, I've just realised that the input is an object rather than a list. will update.

Sourav Karmakar Over a year ago

Anyway, your answer satisfies my requirements. Thank you so much @TZHX .

js2010 · Accepted Answer · 2022-11-24 16:42:47Z

Powershell 7 version with name,value pairs:

cat file.json | convertfrom-json -AsHashtable Name Value ---- ----- hgt {isSecret, value} newvar1 {isSecret, value} dar {isSecret, value} abc {isSecret, value} var {isSecret, value}

Collectives™ on Stack Overflow

Parse JSON in Powershell

3 Answers 3

Comments

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Related