Sort JSON objects by value of the key (Index) in PowerShell

Question

I'm trying to sort the following JSON objects by the value of the "Index" key.

JSON =  {           
        "PIPoint":  {
                        "Label":  "\"PIPoint\"",
                        "Visible":  "True",
                        "Index":  "2"
                    },
        "Description":  {
                            "Label":  "\"Description\"",
                            "Visible":  "True",
                            "Index":  "3"
                        },
        "Analysis":  {
                         "Label":  "\"Analysis\"",
                         "Visible":  "True",
                         "Index":  "4"
                     },
        "PIPointExist":  {
                             "Label":  "\"PIPointExist\"",
                             "Visible":  "True",
                             "Index":  "5"
                         },
        "Custom Location":  {
                                "Label":  "\"Custom Location\"",
                                "Visible":  "True",
                                "Index":  "1"
                            }
    }

I've try the following code but it did not work

$json = Get-Content 'C:\column.json' | ConvertFrom-Json
$json = $json | Sort-Object -Property {$_.Index} 
$json | ConvertTo-Json | Out-File 'C:\\column_sorted.json'

Why would you like to do that? JSON objects are by definition unordered. Arrays are exception, as those preserve order. — vonPryz
– vonPryz, Commented Jul 28, 2021 at 14:18
The JSON contains the list of column that will appear in a report i generate. I want to make the column configurable, so i decide to use JSON to store them. I've created a sub-property to able to make them visible, also decide in which order they will appear in the report and to able to change the display name. — Anastasios
– Anastasios, Commented Jul 28, 2021 at 14:32

AdminOfThings · Accepted Answer · 2021-07-28 14:29:02Z

1

One way to do this would be to sort the properties and use Select-Object to reorder the output:

# Return objects based on JSON strings
$jsonObjs = Get-Content 'C:\column.json' | ConvertFrom-Json
# Sorted properties list 
$Properties = ($jsonObjs.psobject.properties | Sort-Object {[int]$_.Value.Index}).Name
# Create new JSON strings with new order
$jsonObjs | Select-Object $Properties | ConvertTo-Json

answered Jul 28, 2021 at 14:29

AdminOfThings

25.2k4 gold badges23 silver badges31 bronze badges

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

Comments

iRon · Accepted Answer · 2021-07-28 14:29:30Z

0

$json¹ is a single object (with just 5 properties).
So you need to sort the properties:

$Data = Get-Content 'C:\column.json' | ConvertFrom-Json
$Properties = [ordered]@{}
$Data.PSObject.Properties |Sort-Object { $_.Value.Index } |ForEach-Object { $Properties[$_.Name] = $_.Value }
[pscustomobject]$Properties | ConvertTo-Json

I would call it $Json as it is no longer a Json string but an object

answered Jul 28, 2021 at 14:29

iRon

24.4k10 gold badges60 silver badges107 bronze badges

Collectives™ on Stack Overflow

Sort JSON objects by value of the key (Index) in PowerShell

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related