PowerShell Invoke-RestMethod Match

Question

I am looking writing a PowerShell script that calls an API using the Invoke-RestMethod. Below is the output from the command. I am looking to only return a line that matches the current hostname of the server running the PowerShell script, then take the number from the id= field and put that into a variable.

Any help would be greatly appreciated.

Command:

Invoke-RestMethod -Uri http://xxx.xxx.xxx.xxx/api/hosts -Headers @{"Authorization" = "Basic "+[System.Convert]::ToBase64String([System.Text.Encoding]::UTF8.GetBytes($username+":"+$password ))} -Method GET

Output:

host

@{name=dns01.aws.local; id=4; hostgroup_id=3; operatingsystem_id=3}
@{name=win-9d3nna26g9c.aws.local; id=56; hostgroup_id=5; operatingsystem_id=2}

UPDATE:

I am getting closer the below command will just return the line with the computer name, and filter only the name and id. Now I just need to get that id value into a variable, which I am having trouble figuring out, any help would be appreciated.

(Invoke-RestMethod -Uri http://xxx.xxx.xxx.xxx/api/hosts -Headers @{"Authorization" = "Basic "+[System.Convert]::ToBase64String([System.Text.Encoding]::UTF8.GetBytes($username+":"+$password ))}).host | Select-Object name,id | Where-Object name -Like "$env:COMPUTERNAME"

Output:

name id
---- --
win-9d3nna26g9c.aws.ths 56

Start-Automating Start-Automating · Accepted Answer · 2014-01-23T02:55:57

I don't have your input, so I can't be 100% sure this will work perfectly, but I believe you're after:

Invoke-RestMethod ... |
    ConvertFrom-Json | 
    Where-Object { $_.Name -eq $env:ComputerName } |
    Select-Object -ExpandProperty ID

PowerShell Invoke-RestMethod Match

host

2 Answers