Extract Value from JSON Using PowerShell based on condition

Question

I have the captured the JSON response in variable $releaseDefinitions. With this i want to extract the "ID" as "4598" when i pass the "name" as "STAGE1-PG-DB" under the "environments" tag using the powershell.

Any help on this is much appreciated.

{
    "id":  516,
    "environments":  [
                        {
                             "id":  4598,
                             "releaseId":  516,
                             "name":  "STAGE1-PG-DB",
                             "status":  "notStarted",
                         },
                        {
                             "id":  4599,
                             "releaseId":  516,
                             "name":  "STAGE2-PG-DB",
                             "status":  "notStarted",
                         },
                        {
                             "id":  4600,
                             "releaseId":  516,
                             "name":  "STAGE3-PG-DB",
                             "status":  "notStarted",
                         } 
                            
                     ]
}

Hello, can you share your attempt at this?

Abraham Zinala
– Abraham Zinala

2022-04-26 16:46:27 +00:00
Commented Apr 26, 2022 at 16:46 — Abraham Zinala
– Abraham Zinala, Commented Apr 26, 2022 at 16:46

scottwtang · Accepted Answer · 2022-04-26 20:58:30Z

2

I believe you are asking to get the JSON array object where the name is "STAGE1-PG-DB". Based on the info you've provided, you would do something like this (see my in-line comments)

$releaseDefinitions = Get-Content -Path $inputFileName -Raw | ConvertFrom-Json

# use dot-notation to get the entire Environments array
# pipe the array through using the pipe character
# filter through the array where the key (Name) is equal to your value (STAGE1-PG-DB)
$releaseDefinitions.environments | Where-Object {$_.name -eq "STAGE1-PG-DB"}

edited Apr 26, 2022 at 20:58

answered Apr 26, 2022 at 17:05

scottwtang

2,1182 gold badges5 silver badges15 bronze badges

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

1 Comment

PS83 Over a year ago

Thanks @scottwtang, This solves my purpose.

Collectives™ on Stack Overflow

Extract Value from JSON Using PowerShell based on condition

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