Edit Json using powershell

Question

I have a complex configuration file that i want to update using Powershell.

is there any helpful way i could achieve that.

I want to update SelectedCodes only.

the file:

<?xml version="1.0"?>
<Settings>
  <ServerIPAddress>192.168.150.128:8090</ServerIPAddress>
  <SettingString>
    {
      "StationName":"Testing",
      "LocationCode":12,
      "AskForMoreDetails":false,
      "IsLaptop":false,
      "SpecificDepartment":"",
      "SelectedCodes":[
          {
            "Id":16,
            "Name":"Code Blue",
            "HtmlColorCode":"#0000FF",
            "TextColorCode":"#ffffff",
            "DisplayOrderNumber":1
          },
          {
            "Id":19,
            "Name":"CCRT",
            "HtmlColorCode":"#3CB371",
            "TextColorCode":"#FFFFFF",
            "DisplayOrderNumber":3
          }
      ],
      "AreaCode":12
    }
  </SettingString>
  <StartUpLaunchSet>False</StartUpLaunchSet>
  <CodeRedId>27</CodeRedId>
</Settings>

What do you want it to update to?

Abraham Zinala
– Abraham Zinala

2021-01-24 05:47:25 +00:00
Commented Jan 24, 2021 at 5:47 — Abraham Zinala
– Abraham Zinala, Commented Jan 24, 2021 at 5:47
I want to add more SelectedCodes

Saad Aldulaijan
– Saad Aldulaijan

2021-01-24 05:56:59 +00:00
Commented Jan 24, 2021 at 5:56 — Saad Aldulaijan
– Saad Aldulaijan, Commented Jan 24, 2021 at 5:56

Guenther Schmitz · Accepted Answer · 2021-01-24 07:59:32Z

3

you first have to create another code object like:

$additionalCode = [pscustomobject]@{
    Id='20'
    Name='Code Red'
    HtmlColorCode='#e83f3f'
    TextColorCode='#ffffff'
    DisplayOrderNumber='5'
}

to add this to your file we first have to read the file

$filePath = 'c:\path\to\file.xml'
[XML]$xmlObject = Get-Content -Path $filePath

convert the JSON part of the xml to PowerShell object

$settingJson = $xmlObject.Settings.SettingString | ConvertFrom-Json

add the previously created additional code object

$settingJson.SelectedCodes += $additionalCode

convert the JSON to string and store it back in the XML object

$settingString = $settingJson | ConvertTo-Json
$xmlObject.Settings.SettingString = $settingString.ToString()

save the XML document to file

$xmlObject.Save('c:\path\to\edited.xml')

or overwrite the file directly

$xmlObject.Save($filePath)

answered Jan 24, 2021 at 7:59

Guenther Schmitz

2,0191 gold badge13 silver badges23 bronze badges

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

1 Comment

Guenther Schmitz Over a year ago

@SaadAldulaijan please mark the answer as such

Collectives™ on Stack Overflow

Edit Json using powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related