Using MS PowerShell ISE to query json data

Question

I have a text file containing json data and looks like this:

{ 
  "field1":"value1",
  "field2": [
      { 
         "subfield1": "subvalue",
         "subfield2": []
      },
      { 
         "subfield1": "subvalue2",
         "subfield2": [ "string1", "string2", "...", "stringN" ]
      }
  ]
}

I want to get the count of objects contained in field2, where subfield2 is empty.

I tried it this way to get all objects where subfield2 is empty:

$datas = Get-Content -Path .\data
$json = $datas | ConvertFrom-Json
$json.field2 | Select-Object subfield2 | where subfield2 -Match ".*\[\].*"

Executing this results in no output. Using -EQ or -Like doesn't work either.

The JSON sample is invalid. Please edit the question and add parsable, valid data. — vonPryz
– vonPryz, Commented Dec 14, 2018 at 7:31

Kory Gill · Accepted Answer · 2018-12-14 07:45:35Z

3

Probably many other ways. This is one.

@($json.field2 | Where-Object {$($_.subfield2) -eq $null}).Count

Make $_.subfield2 a string with $($_.subfield2). Check string for $null.

answered Dec 14, 2018 at 7:45

Kory Gill

7,1711 gold badge28 silver badges35 bronze badges

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

2 Comments

Andreas_Lng Over a year ago

That's it! Nice and thanks alot. Is there any good documentation you can recommend for digging deeper into powershell? I'm very new to it

Kory Gill Over a year ago

"Windows PowerShell in Action" book, use Get-Help like ` Get-Help Get-Process -Examples` and search this site for lots of good examples and answers. Use ISE or VSCode to write and debug code.

Collectives™ on Stack Overflow

Using MS PowerShell ISE to query json data

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