Loop through Json in powershell

Question

I have json that I get from an API that returns a value like this

[{
    "Location": "/xxx/005D2"
}, {
    "Location": "/xxx/020D2"
}, {
    "Location": "/xxx/061D2"
}, {
    "Location": "/xxx/086D2"
}, {
    "Location": "/xxx/100D2"
}]

When I call the URL and access the variable

$installs= Invoke-RestMethod -Uri $installLocation -Method Get;

I get the following

Location
--------------
/xxx/100D2
/xxx/120D2
/xxx/110D2
etc

How can I loop through these so I only access 1 location at a time?

$installs | foreach { $_.location; };

goTo-devNull
– goTo-devNull

2018-08-13 18:34:13 +00:00
Commented Aug 13, 2018 at 18:34 — goTo-devNull
– goTo-devNull, Commented Aug 13, 2018 at 18:34

vrdse · Accepted Answer · 2018-08-13 19:26:14Z

2

You acutally don't want to loop through JSON, but through a PowerShell object ($installs). You can do that, as with any other PowerShell object.

$installs | ForEach-Object {
    $_.Location
}

answered Aug 13, 2018 at 19:26

vrdse

3,24413 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Loop through Json in powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related