Looping through JSON file with PowerShell

Question

How do I loop through all items in a JSON file? The current code just writes all names on one big line:

Get-Content -Raw -Path c:\temp\Environments.Generic.json | ConvertFrom-Json | ForEach-Object {
    Write-Host $_.Name
}

json file:

[
   {
      "Name":"EnableRetry",
      "Description":"Enable retry for Webservice Task",
      "Type":"Boolean",
      "Sensitive":false,
      "Value":true
   },
   {
      "Name":"FolderStageFiles",
      "Description":"Location of stage files",
      "Type":"String",
      "Sensitive":false,
      "Value":"d:\\sources\\"
   },
   {
      "Name":"FtpPassword",
      "Description":"Secret FTP password",
      "Type":"String",
      "Sensitive":true,
      "Value":"Welcome1"
   }
]

Duplicate from stackoverflow.com/questions/33520699/… ?

Micky Balladelli
– Micky Balladelli

2017-05-07 22:01:18 +00:00
Commented May 7, 2017 at 22:01 — Micky Balladelli
– Micky Balladelli, Commented May 7, 2017 at 22:01

Joost · Accepted Answer · 2017-05-12 12:06:40Z

9

I ended up Select-Object and a ForEach-Object:

$JSON = Get-Content -Raw -Path c:\temp\Environments.Generic.json | ConvertFrom-Json

$JSON | Select-Object -Property Name,Description,Type,Sensitive,Value | ForEach-Object {
    Write-Host $_.Name $_.Value
}

answered May 12, 2017 at 12:06

Joost

1,9313 gold badges20 silver badges22 bronze badges

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

3 Comments

Mark Wragg Over a year ago

Looks like a fine solution to me. Apologies for not coming back to you.

Joost Over a year ago

No problem, I took your code as a base and that helped me... Will post the complete code on my blog in a couple of days.

Joost Over a year ago

Here is the complete code if someone want to copy it: microsoft-ssis.blogspot.com/2017/05/…

Mark Wragg · Accepted Answer · 2017-05-08 08:27:17Z

2

If you do this:

$JSON = Get-Content -Raw -Path c:\temp\Environments.Generic.json | ConvertFrom-Json

$JSON will be a PowerShell object that contains a collection of objects with all of the properties defined in your JSON file.

Enter $JSON at the console and you'll see the contents of this object.

To access specific properties for specific items in the collection you could do (for example):

$JSON | Where {$_.Name -eq 'FolderStageFiles'} | Select -ExpandProperty Value

answered May 8, 2017 at 8:27

Mark Wragg

23.6k7 gold badges48 silver badges77 bronze badges

1 Comment

Joost Over a year ago

Is there something for looping through the set because I don't know the values of the json file... only the structure (Name, Description, Type, Sensitive and Value). I want to loop through these records and add these values to an SSIS environment like microsoft-ssis.blogspot.com/2015/08/…

Collectives™ on Stack Overflow

Looping through JSON file with PowerShell

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related