How to convert PSCustomObject to array in PowerShell?

Question

I have below JSON file that gets parsed with ConvertFrom-Json command:

{
  "item1": {
    "class": "class1",
    "price": "price1"
  },
  "item2": {
    "class": "class2",
    "price": "price2"
  }
}

This creates a PSCustomObject with two properties item1 and item2. It produces below output:

item1                         item2
-----                         -----
@{class=class1; price=price1} @{class=class2; price=price2}

What I need instead is an array that prints:

name  class  price
----  -----  -----
item1 class1 price1
item2 class2 price2

Please note that I cannot modify the content of JSON file.

Any kind of help is much appreciated.

Jatin Sanghvi · Accepted Answer · 2019-12-18 19:55:55Z

4

Found the solution in my colleague's code:

$json = Get-Content -Path "<file-path>" | ConvertFrom-Json;
$json.PSObject.Properties | ForEach-Object { [PSCustomObject] @{
    name = $_.Name;
    class = $_.Value.class;
    price = $_.Value.price;
}}

edited Dec 18, 2019 at 19:55

answered Dec 18, 2019 at 18:57

Jatin Sanghvi

2,3791 gold badge29 silver badges34 bronze badges

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

Comments

Carsten · Accepted Answer · 2022-06-24 08:26:28Z

1

This one gives you all item-attributes and adds the name. The result is an array of objects:

$result = foreach($item in $json.PsObject.Properties) {
    Add-Member -in $item.value -NotePropertyName 'name' -NotePropertyValue $item.name –PassThru
}

edited Jun 24, 2022 at 8:26

answered Jun 24, 2022 at 8:05

Carsten

2,3411 gold badge24 silver badges42 bronze badges

Collectives™ on Stack Overflow

How to convert PSCustomObject to array in PowerShell?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related