Powershell - Add another object to a JSON with multiple sections?

Question

I am extracting a JSON from a file using the following syntax:

$json = Get-Content $jsonfile | Out-String | ConvertFrom-Json

This is what my JSON currently looks like:

{
    "Server":  {
                   "CustomModules":  [
                                         "@{Name=Test Server Module 1; Tag=Server; Action=Option I want; Image_Path=C:Temp; Admin_Only=false}",
                                         "@{Name=Test Server Module 2; Tag=Server; Action=Option I want; Image_Path=C:Temp/Downloads; Admin_Only=false}"
                                     ]
               },
    "Help Desk":  {
                      "CustomModules":  [
                                            "@{Name=Test Help Desk Module 1; Tag=HD; Action=Option I want; Image_Path=C:Temp; Admin_Only=false}",
                                            "@{Name=Test Help Desk Module 2; Tag=HD; Action=Option I want; Image_Path=C:Temp/Downloads; Admin_Only=true}"
                                        ]
                  }
}

How would I add another set of values under the Server 'CustomModules' so it looks like this?

    "Server":  {
                   "CustomModules":  [
                                         "@{Name=Test Server Module 1; Tag=Server; Action=Option I want; Image_Path=C:Temp; Admin_Only=false}",
                                         "@{Name=Test Server Module 2; Tag=Server; Action=Option I want; Image_Path=C:Temp/Downloads; Admin_Only=false}",
                                         "@{Name=Test Server Module 3; Tag=Server; Action=Option I want; Image_Path=C:/User/TestUser; Admin_Only=true}"
                                     ]
               },
    "Help Desk":  {
                      "CustomModules":  [
                                            "@{Name=Test Help Desk Module 1; Tag=HD; Action=Option I want; Image_Path=C:Temp; Admin_Only=false}",
                                            "@{Name=Test Help Desk Module 2; Tag=HD; Action=Option I want; Image_Path=C:Temp/Downloads; Admin_Only=true}"
                                        ]
                  }
}

I've tried Add-Member but it only adds to the current values already there.

Are you sure you want string representation of your objects like @{Name=Test....} ? You will need to parse them after, I would recommend you to export them as real Json representations of the object — Santiago Squarzon
– Santiago Squarzon, Commented Oct 6, 2022 at 3:34

Santiago Squarzon · Accepted Answer · 2022-10-06 03:58:49Z

1

You can append objects into the array CustomModules array using this as an example:

$json = Get-Content path\to\json.json -Raw | ConvertFrom-Json
$json.Server.CustomModules = @(
    $json.Server.CustomModules
    ([pscustomobject]@{
        Name       = 'Test Server Module 3'
        Tag        = 'Server'
        Action     = 'Option I want'
        Image_Path = 'C:/User/TestUser'
        Admin_Only = $true
    })
)
$json | ConvertTo-Json

However, as recommended in comments, your arrays currently have string representations of PowerShell objects, most likely due to serialization exceeded the default depth of 2. So to avoid this, because you will need to parse them later, use ConvertTo-Json -Depth 99 when exporting the initial Json.

edited Oct 6, 2022 at 3:58

answered Oct 6, 2022 at 3:47

Santiago Squarzon

65.5k5 gold badges26 silver badges59 bronze badges

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

1 Comment

Joe Over a year ago

Thank you so much, both, for this help! Works as I needed!

Collectives™ on Stack Overflow

Powershell - Add another object to a JSON with multiple sections?

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