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

1

$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
}

edited Nov 24, 2022 at 16:47

answered Nov 24, 2022 at 16:26

iRon

24.4k10 gold badges60 silver badges107 bronze badges

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

Comments

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 badges50 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

0

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}

answered Nov 24, 2022 at 16:42

js2010

28.3k6 gold badges82 silver badges88 bronze badges

Collectives™ on Stack Overflow

Parse JSON in Powershell

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related