Loop to iterate through JSON

Question

[
{
"RgName": "DOTcom-dev-rg",
"Name": "dev",
"AppName": "devse-cd"
},
{
"RgName": "DOTcom-dev-rg",
"Name": "dev-cm",
"AppName": "devse-cm"
},
{
"RgName": "DOTcom-uat-rg",
"Name": "uat",
"AppName": "uatse-cd"
},
{
"RgName": "DOTcom-uat-rg",
"Name": "uat-cm",
"AppName": "uatse-cm"
}
]

Answer 1

Hi,

You can first read the json file and convert it to a PSCustomObject.

$file = 'd:\temp\file.json'  
$contents = Get-Content -Path $file | ConvertFrom-Json   

To get the items with specified property value you can use "Where-Object".

$contents | Where-Object {$_.RGname -eq 'DOTcom-dev-rg'}  

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.