Prettify json in powershell 3

json powershell powershell-3.0
Eris picture Eris · Jul 16, 2014 · Viewed 23.1k times · Source

Given a standard json string value:

$jsonString = '{ "baz": "quuz", "cow": [ "moo", "cud" ], "foo": "bar" }'

How can I get this to be all pretty with newlines, preferably without brute-force regex?

Simplest method I've found so far is:

$jsonString | ConvertFrom-Json | ConvertTo-Json

However, that seems kinda silly.

Answer

js2010 picture js2010 · Jun 16, 2017

Works for me. Parentheses make sure get-content is done before piping. Default depth of convertto-json is 2, which is often too low.

function pjson ($jsonfile) {
  (get-content $jsonfile) | convertfrom-json | convertto-json -depth 100 | 
    set-content $jsonfile
}

Related questions

PowerShell : retrieve JSON object by field value

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 …

Read More
How to load a JSON file and convert it to an object of a specific type?

I have a type FooObject and I have a JSON file which was serialized from a FooObject instance. Now I want to use ConvertFrom-Json to load the JSON file to memory and covert the output of the command to a …

Read More
How do I update JSON file using PowerShell

I have one json file mytest.json like below I want to update values using PowerShell script update.json { "update": [ { "Name": "test1", "Version": "2.1" }, { "Name": "test2", "Version": "2.1" } ] } I want to write a PowerShell script where if Name=="test1" I want to …

Read More