Convert a Powershell-Object to JSON with sorting

Question

I have a PSCustomObject in Powershell which I want to convert to JSON. The Key-Value-Pair should be under the "children" array. Can you help?

Powershell:

#PowershellObject
$BookmarkContainer = [PSCustomObject]@{
    "roots" = @{
        "other" = @{
            "children" = @()
        }
        "bookmark_bar" = @{
            "children" = @()
            "name" ="FavouriteBar"
            "type" ="folder"
            
        }
    }
    "version"=1
}

JSON-Output:

{
    "roots":  {
        "bookmark_bar":  {
            "name":  "FavouriteBar",
            "type":  "folder",
            "children":  [ ]
        },
        "other":  {
            "children":  [ ]
        }
    },
    "version":  1
}

Intended output:

{
    "roots":  {
        "bookmark_bar":  {
            "children":  [ ],
            "name":  "FavouriteBar",
            "type":  "folder"
        },
        "other":  {
            "children":  [ ]
        }
    },
    "version":  1
}

Hash tables are not ordered by default. Use the [ordered] attribute to use a OrderedDictionary instead. — AdminOfThings
– AdminOfThings, Commented Oct 5, 2021 at 13:03
What @AdminOfThings said. Or cast the inner items to [pscustomobject] (will also retain syntactic order) — Mathias R. Jessen
– Mathias R. Jessen, Commented Oct 5, 2021 at 13:04

AdminOfThings · Accepted Answer · 2021-10-05 13:07:32Z

Hash tables are not ordered by default. Use the [ordered] attribute to use a OrderedDictionary instead. Use the -Depth parameter on ConvertTo-Json since its default value is 2 and you have more than 2 levels of nesting.

$BookmarkContainer = [PSCustomObject]@{
    "roots" = [ordered]@{
        "other" = @{
            "children" = @()
        }
        "bookmark_bar" = [ordered]@{
            "children" = @()
            "name" ="FavouriteBar"
            "type" ="folder"
            
        }
    }
    "version"=1
}

$BookmarkContainer | ConvertTo-Json -Depth 4

Output:

{
    "roots":  {
                  "other":  {
                                "children":  [

                                             ]
                            },
                  "bookmark_bar":  {
                                       "children":  [

                                                    ],
                                       "name":  "FavouriteBar",
                                       "type":  "folder"
                                   }
              },
    "version":  1
}

Collectives™ on Stack Overflow

Convert a Powershell-Object to JSON with sorting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related