Powershell JSON : How to retrieve specific key-value pair for all array items

Question

I am trying to get the list of "enabled" features from featureset array from below JSON snippet with powershell. output expected :

feature1, feature2, feature4

I tried this piece of code but I was only able to get to the specific index of the array, not all elements, also not able to put condition for "enable" = true :

$output = foreach( $feature in $jsn.abc.comp1.featureset[0].psobject.Properties ) {
   [PSCustomObject]@{
       featureName = $feature.Name
       featureValue = $feature.Value
   }
}

json:

{
"abc": {
    "comp1": {
        "id": "1308",
        "featureset":[
            {
                "name": "feature1",
                "enable" : true,
                "ID": "0670FF495355878281174937"
            },
            {
                "name": "feature2",
                "enable" : true,
                "ID": "0670FF495355878281174937"
            },
            {
                "name": "feature3",
                "enable" : false,
                "ID": "0670FF495355878281174937"
            },
            {
                "name": "feature4",
                "enable" : true,
                "ID": "0670FF495355878281174937"
            }
        ]
      }
    }
  }

I think you're looking for $json.abc.comp1.featureset | ? enable — Santiago Squarzon
– Santiago Squarzon, Commented Feb 9, 2023 at 14:30
Thanks, this filters enabled features but returns complete array, how only name key and its value can be retrieved for enabled features ? — user3462473
– user3462473, Commented Feb 9, 2023 at 14:47
using a loop like Mathias did in his answer. $json.abc.comp1.featureset | ? enable | % name would also work — Santiago Squarzon
– Santiago Squarzon, Commented Feb 9, 2023 at 14:56

Mathias R. Jessen · Accepted Answer · 2023-02-09 14:53:35Z

3

Loop over the whole featureset array, use Where-Object to filter:

$output = $jsn.abc.comp1.featureset |Where-Object enable -eq $true |ForEach-Object {
   $_.Name
}

answered Feb 9, 2023 at 14:53

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Collectives™ on Stack Overflow

Powershell JSON : How to retrieve specific key-value pair for all array items

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