How to read json file from powershell and extract a list of array

Question

Need name in array if change flag is true eg list = [kernel,activemq] How to extract through PowerShell

[
    {
        "name"           : "kernel",
        "change_flag"    : "TRUE",
        "localpath"      : "setupfiles\\controlroom\\kernel.jar",
        "unpack"         : "FALSE",
        "filename"       : ["",""]
    },
    {
        "name"           : "activemq",
        "change_flag"    : "TRUE",
        "localpath"      : "setupfiles\\controlroom\\activemq.jar",
        "unpack"         : "FALSE",
        "filename"       : ["",""]
    },
    {
        "name"           : "ignite-server",
        "change_flag"    : "FALSE",
        "localpath"      : "setupfiles\\controlroom\\ignite-server.jar",
        "unpack"         : "FALSE",
        "filename"       : []
    }
]

Martin Brandl · Accepted Answer · 2020-04-29 08:41:33Z

1

Use the ConvertFrom-Json cmdet to convert your text to json, then you can filter using the Where-Object cmdlet:

$json = 
@'
[
    {
        "name"           : "kernel",
        "change_flag"    : "TRUE",
        "localpath"      : "setupfiles\\controlroom\\kernel.jar",
        "unpack"         : "FALSE",
        "filename"       : ["",""]
    },
    {
        "name"           : "activemq",
        "change_flag"    : "TRUE",
        "localpath"      : "setupfiles\\controlroom\\activemq.jar",
        "unpack"         : "FALSE",
        "filename"       : ["",""]
    },
    {
        "name"           : "ignite-server",
        "change_flag"    : "FALSE",
        "localpath"      : "setupfiles\\controlroom\\ignite-server.jar",
        "unpack"         : "FALSE",
        "filename"       : []
    }
]
'@

($json | ConvertFrom-Json) | Where-Object change_flag -eq 'TRUE' | Select-Object -ExpandProperty name

edited Apr 29, 2020 at 8:41

answered Apr 29, 2020 at 6:09

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

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

2 Comments

Jugal Shah Over a year ago

i need only if change_flag = true than create list and add value of each name

Martin Brandl Over a year ago

I adopt my answer. Please give it a try

Collectives™ on Stack Overflow

How to read json file from powershell and extract a list of array

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