How to read specific Key from JSON file with Powershell

Question

I'm trying to read a Json file with some passwords but them are stored into Key-Value pattern as below:

{
    "id":  "a8cc4184-3844-4605-8e35-ea479ae1094e",
    "name":  "Test Credentials and Secrets",
    "values":  [
                   {
                       "key":  "apassword",
                       "value":  "mypassword",
                       "enabled":  true
                   },
                   {
                       "key":  "tpassword",
                       "value":  "my other password",
                       "enabled":  true
                   },
               ],
    "exported_using":  "Postman/7.34.0"
}

How can I get any specific value with PowerShell? tpassword value for instance.

Jess · Accepted Answer · 2022-03-16 17:51:48Z

4

I would recommend using ConvertFrom-Json to turn it into an Object so you can then access the properties easily with PowerShell.

I saved the json above to C:\temp\json.json and then the following got me the tpassword value:

$json = Get-Content C:\temp\json.json | ConvertFrom-Json
$json.values | Where-Object key -eq 'tpassword' | Select-Object Value

answered Mar 16, 2022 at 17:51

Jess

1461 silver badge5 bronze badges

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

4 Comments

zett42 Over a year ago

Hey, your console looks cool! Is this a special app or an extension of the regular pwsh console?

Jess Over a year ago

It's Windows terminal with an oh my posh prompt (ohmyposh.dev).

Torben Gundtofte-Bruun Over a year ago

I've copied this code, and Write-Host $json shows the JSON data block, but Write-Host $json.values outputs a blank line -- why?

Torben Gundtofte-Bruun Over a year ago

I have posted a new question here

Collectives™ on Stack Overflow

How to read specific Key from JSON file with Powershell

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related