PowerShell retrieve JSON object by field value

Question

Consider JSON in this format     Stuffs                    Name    Darts            Type    Fun Stuff                        Name    Clean Toilet            Type    Boring Stuff            In PowerShell 3  we can obtain a list of Stuffs     JSON   Get-Content  jsonConfigFile   Out-String   ConvertFrom-Json   Assuming we don t know the exact contents of the list  including the ordering of the objects  how can we retrieve the object s  with a specific value for the Name field     Brute force  we could iterate through the list     foreach   Stuff in  JSON Stuffs        But I am hopeful there exists a more direct mechanism   similar to Lync or Lambda expressions in C

User · Answer

I just asked the same question here  https   stackoverflow com a 23062370 3532136 It has a good solution  I hope it helps     In resume  you can use this   The Json file in my case was called jsonfile json          CARD MODEL TITLE    OWNER S MANUAL        CARD MODEL SUBTITLE    Configure your download        CARD MODEL SELECT    Select Model        CARD LANG TITLE    Select Language        CARD LANG DEVICE LANG    Your device        CARD YEAR TITLE    Select Model Year        CARD YEAR LATEST     Latest         STEPS MODEL    Model        STEPS LANGUAGE    Language        STEPS YEAR    Model Year        BUTTON BACK    Back        BUTTON NEXT    Next        BUTTON CLOSE    Close      Code    json    Get-Content  jsonfile json  -Raw    ConvertFrom-Json   json psobject properties name   Output   CARD MODEL TITLE CARD MODEL SUBTITLE CARD MODEL SELECT CARD LANG TITLE CARD LANG DEVICE LANG CARD YEAR TITLE CARD YEAR LATEST STEPS MODEL STEPS LANGUAGE STEPS YEAR BUTTON BACK BUTTON NEXT BUTTON CLOSE   Thanks to mjolinor

User · Answer

In regards to PowerShell 5 1  this is so much easier in PowerShell 7      Operating off the assumption that we have a file named jsonConfigFile json with the following content from your post          Stuffs                            Name    Darts                Type    Fun Stuff                                    Name    Clean Toilet                Type    Boring Stuff                      This will create an ordered hashtable from a JSON file to help make retrieval easier    json    ordered       Get-Content  jsonConfigFile json  -Raw   ConvertFrom-Json  PSObject Properties       ForEach-Object    json    Name       Value      json Stuffs will list a nice hashtable  but it gets a little more complicated from here  Say you want the Type key s value associated with the Clean Toilet key  you would retrieve it like this    json Stuffs Where     Name -eq  Clean Toilet    Type   It s a pain in the ass  but if your goal is to use JSON on a barebones Windows 10 installation  this is the best way to do it as far as I ve found

User · Answer

David Brabant s answer led me to what I needed  with this addition   x Stuffs   where      Name -eq  Darts      Select -ExpandProperty Type

User · Answer

json         Stuffs                                 Name    Darts                Type    Fun Stuff                                     Name    Clean Toilet                Type    Boring Stuff                         x    json   ConvertFrom-Json   x Stuffs 0    access to Darts  x Stuffs 1    access to Clean Toilet  darts    x Stuffs   where      Name -eq  Darts     Darts

User · Answer

This is my json data                 name   Test          value   TestValue                    name   Test          value   TestValue           Powershell script    data   Get-Content  Path to json file    Out-String   ConvertFrom-Json  foreach   line in  data          line name

User · Answer

Hows about this    json Get-Content -Raw -Path  my json    Out-String   ConvertFrom-Json  foo  TheVariableYourUsingToSelectSomething   json SomePathYouKnow psobject properties Where     name -eq  foo   value   which would select from json structured    SomePathYouKnow    TheVariableYourUsingToSelectSomething    Tada      This is based on this accessing values in powershell SO question   Isn t powershell fabulous

[json] PowerShell : retrieve JSON object by field value

Examples related to json

Examples related to powershell

Examples related to powershell-3.0