How do I update JSON file using PowerShell

json powershell powershell-3.0
Neo picture Neo · Mar 8, 2016 · Viewed 42.6k times · Source

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 update Version= "3" How can i do it using parameters?

Answer

JPBlanc picture JPBlanc · Mar 8, 2016

Here is a way :

$a = Get-Content 'D:\temp\mytest.json' -raw | ConvertFrom-Json
$a.update | % {if($_.name -eq 'test1'){$_.version=3.0}}
$a | ConvertTo-Json -depth 32| set-content 'D:\temp\mytestBis.json'

According to @FLGMwt and @mikemaccana I improve the ConvertTo-Json with -depth 32 because the default depth value is 2 and for object deeper than 2 you will receive class informations in spite of objects.

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
Prettify json in powershell 3

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 | …

Read More