How do I update JSON file using PowerShell (Patch Method)

Question

I have a json file like below, and I want to update values using a PowerShell script

{
  "rows": [{
    "id": 111,
    "name": "xrx",
    "serial": "A123456",
    "model": {
      "id": 8,
      "name": "wlw"
    },
    "model_number": "2323",
    "status_label": {
      "id": 22,
      "name": "out"
    }  
    }]
}

I want to edit the status label id and name (status_label -> id & name). Is there any way I can edit it with Powershell?

There's a comma missing after "model_number": "2323"

Theo
– Theo

2019-07-15 18:26:56 +00:00
Commented Jul 15, 2019 at 18:26 — Theo
– Theo, Commented Jul 15, 2019 at 18:26

theadzik · Accepted Answer · 2019-07-15 13:54:09Z

2

You can use ConvertFrom-Json and ConvertTo-Json functions.

$Json = Get-Content C:\Temp\json.json | ConvertFrom-Json
$Json.rows.status_label.id = "newID"
$Json.rows.status_label.name = "newName"
$Json | ConvertTo-Json | Out-File C:\Temp\newJson.json

When you use ConvertFrom-Json you will get a PowerShell object which you can manipulate as every other object. Then you can convert the object back into Json string and overwrite the old file or save it as a new one.

answered Jul 15, 2019 at 13:54

theadzik

1381 gold badge1 silver badge9 bronze badges

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

3 Comments

Sam Over a year ago

the form in json was changed, and because of that i can't change another time. any solutions? the status_label look like this after running this code: "status_label": "@{id=999; name=nn}"

theadzik Over a year ago

How did the JSON change? If you check what $Json.rows.status_label is (with | Get-Member for example) you'll see that it's an object with 2 properties. Id and name. You have to dig deeper :)

theadzik Over a year ago

@sam ConvertTo-Json has a -Depth flag, if the change was that the json got shallower it might help to set it higher

Collectives™ on Stack Overflow

How do I update JSON file using PowerShell (Patch Method)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related