How to capture JSON key and values as an array in powershell

Question

I have a json output from an api call, which partially looks like as below. As part of this json, there are many id and name values listed..Now, I want to capture id and name pair together as an array , as part of some steps in the program I get returned with name , I want to compare this name with the name stored in array previously and return the id value corresponding to it. As I have to pass this id value to another rest api call.

Could someone help how can I capture this array through powershell?

$Json = '{
    "value": [
        {
            "id": "1",
            "name": "datafactory.git",
            "size": 0,
            "remoteUrl": "",
            "sshUrl": "",
            "webUrl": "",
            "isDisabled": false
        },
        {
            "id": "2",
            "name": "datafactory",
            "defaultBranch": "refs/heads/main",
            "size": 13569,
            "remoteUrl": "",
            "sshUrl": "",
            "webUrl": "",
            "isDisabled": false
        },
    ]
}'

I'd start with ConvertFrom-Json to get your Json into powershell objects and go from there. — Lieven Keersmaekers
– Lieven Keersmaekers, Commented May 26, 2021 at 6:39
Yes, I had done that, but how can I capture both id and name as a pair together, so that I can compare the name with some value obtained from script and output the id value? — Padmapriya Kp
– Padmapriya Kp, Commented May 26, 2021 at 6:49

iRon · Accepted Answer · 2021-05-26 09:35:21Z

1

I would create a hash table for this:

($Json |ConvertFrom-Json).Value |ForEach-Object {
    $HashTable = @{}
} {
    $HashTable[$_.name] = $_.id
}

Usage:

$HashTable.datafactory
2

You might also consider to refer to the complete value property object (instead of just the id):

($Json |ConvertFrom-Json).Value |ForEach-Object {
    $HashTable = @{}
} {
    $HashTable[$_.name] = $_
}

Usage:

$HashTable.datafactory.id
2

$HashTable.datafactory.size
13569

edited May 26, 2021 at 9:35

answered May 26, 2021 at 9:25

iRon

24.4k10 gold badges60 silver badges107 bronze badges

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

2 Comments

Padmapriya Kp Over a year ago

Thanks iRon, I was trying to do a comparison and printing, but I have an issue there..could u pls suggest.. $reponame = "repo" if($reponame -eq $HashTable.$reponame){ echo $HashTable.$reponame.id } else{ echo "not compared" }

iRon Over a year ago

Sorry for the late response, I guess you actually want to see whether the reponame exists: if ($HashTable.Contains($reponame)) { $HashTable[$reponame].id } else { "$reponame doesn't exist" }

Collectives™ on Stack Overflow

How to capture JSON key and values as an array in powershell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related