PowerShell : retrieve JSON object by field value

by 
$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

More Related Contents:

  1. Prettify json in powershell 3
  2. Unexpected ConvertTo-Json results? Answer: it has a default -Depth of 2
  3. Iterating through a JSON file PowerShell
  4. Convert nested JSON array into separate columns in CSV file
  5. PowerShell 2.0 ConvertFrom-Json and ConvertTo-Json implementation
  6. Proper formating of JSON using powershell
  7. Why does powershell give different result in one-liner than two-liner when converting JSON?
  8. Cannot convert PSCustomObjects within array back to JSON correctly
  9. Powershell ConvertTo-JSON missing nested level
  10. Merge two json objects
  11. ConvertFrom-Json max length
  12. How to parse JSON from the Invoke-WebRequest in PowerShell?
  13. Binary Data in JSON String. Something better than Base64
  14. What is “406-Not Acceptable Response” in HTTP?
  15. XSLT equivalent for JSON
  16. How to merge 2 JSON objects from 2 files using jq?
  17. Select objects based on value of variable in object using jq
  18. Modify a key-value in a json using jq in-place
  19. get multiple checkbox value as an array in angular
  20. How to process a github webhook payload in Jenkins?
  21. No Json serializer as JsObject found for type play.api.libs.json.JsObject
  22. How can I use Serde with a JSON array with different objects for successes and errors?
  23. How do I update a single value in a json document using jq?
  24. How to create multiple tables in jasper report using json as a datasource?
  25. How to use jq when the variable has reserved characters?
  26. HTTP POST with Json on Body – Flutter/Dart
  27. Decode JSON as it is still streaming in via net/http
  28. Difference between PowerShell Console and PowerShell ISE
  29. alamofire.error Code=-6006 “JSON could not be serialized
  30. include class name in all objects serialized by jackson

Leave a Comment