Powershell reading Json

Question

I'm getting the following response through an API and I'm trying to pull data out of the JSON response. I'm interested in only pulling the clone.href when clone.name = ssh.

response: {
    "links":  {
        "clone":  [
            "@{href=ssh://sampleurl.com; name=ssh}",
            "@{href=https://sampleurl.com; name=http}"
        ],
        "self":  [
            "@{href=https://sampleurl.com}"
        ]
    }
}

I'm using the following to call the API:

Invoke-RestMethod -Uri $uri -Headers $Header -Method POST -Body $Body|ConvertTo-Json

Is this how the Json actually looks? Try using ConvertTo-Json -Depth 30 and see if the Json looks like the one you have posted here — Santiago Squarzon
– Santiago Squarzon, Commented Jun 1, 2022 at 22:13

zett42 · Accepted Answer · 2022-06-01 22:17:30Z

1

You can do this:

$result = Invoke-RestMethod -Uri $uri -Headers $Header -Method POST -Body $Body|ConvertTo-Json

$href = $result.links.clone | Where-Object Name -eq ssh | ForEach-Object href
$href # Output to console

This uses Where-Object to filter the clone array and ForEach-Object to extract the href property, using short form of ForEach-Object -MemberName href.

Alternatively you can use the following syntax:

$href = $result.links.clone.Where{ $_.Name -eq 'ssh' }.href

It uses PowerShell intrinsic method Where for filtering.

answered Jun 1, 2022 at 22:17

zett42

28.3k3 gold badges44 silver badges97 bronze badges

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

Collectives™ on Stack Overflow

Powershell reading Json

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