Powershell arraylist to json

Question

Powershell arraylist to json

Nikola Batinica 21

i have arraylist where i am adding elements and that part work fine
{
"basePrice": 100,
"category": "some category",
"packageWeightUnit": "g",
"productType": "Some type"
}

but now i need to add to look like this
{
"basePrice": 100,
"category": "some category",
"packageWeightUnit": "g",
"productType": "Some type"
"attributes":{
"colour":["blue","red"],
hight:[100]
}

}

i use
$list = New-Object System.Collections.ArrayList

MotoX80 36,401 Reputation points

2022-03-11T15:51:02.873+00:00

i use
$list = New-Object System.Collections.ArrayList

Ok, so you created an empty arraylist variable named $list. Where is the rest of the script where you process the data? What doesn't work? Do you get an error?

https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/convertto-json?view=powershell-5.1

Accepted answer

1 additional answer

Your answer

MotoX80 36,401 Reputation points

2022-03-11T15:51:02.873+00:00

i use
$list = New-Object System.Collections.ArrayList

Ok, so you created an empty arraylist variable named $list. Where is the rest of the script where you process the data? What doesn't work? Do you get an error?

https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/convertto-json?view=powershell-5.1

Answer 1

Your description doesn't match your post title. What is your actual question?

Both Powershell and JSON don't particularly care about the structure of your data. In PS you can have an array of various objects (it sees everything as object anyway) and JSON allows for optional fields so the missing fields in the first value won't impact the structure.

# Using a hash object here for convenience
$item1 = @{ basePrice = 100; category = "some category"; packageWeightUnit = "g"; productType = "Some type" }
$item2 = @{ basePrice = 100; category = "some category"; packageWeightUnit = "g"; productType = "Some type"; attributes = @{ colour = @("blue", "red"); hight = @(100) } } 

# Assuming you have more items than this...
$list = New-Object System.Collections.ArrayList
$list += $item1
$list += $item2
ConvertTo-Json $list -depth 4

To go the other way, given the previous JSON

$readItems = ConvertFrom-Json $json

Answer 2

Nikola Batinica 21

$list.add(@{"name"=$red.name;
"description"=$desc;
"coverImage"=$red.coverImage;
"ean"=$red.ean;
"packageWeightValue"=$red.packageWeightValue;
"packageWeightUnit"=$red.packageWeightUnit;
"basePrice"=$red.basePrice;
"vat"=$red.vat;
"stockLevel"=$red.stockLevel;
"sku"=$red.sku;
"gallery"=$galerija;
"brand"=$red.brand;
"productType"=$red.productType;
"category"=$red.category;
attributes = @{ "key features" = @($features.naziv)}

})

and i am getting no error but output looks like
"attributes": {
"key features": "PARIS Hidratacija Balzam"
},

but it should be
"attributes": {
"key features": ["PARIS", "Hidratacija", "Balzam""
},

Michael Taylor 60,331 Reputation points

2022-03-11T17:35:36.177+00:00
The problem is with your $features.naziv variable. Given your code it appears to be a string set to PARIS Hidratacija Balzam. It needs to be an array of strings.

$features = @{ "naziv" = @("PARIS", "Hidratacija", "Balzam") } $item = @{ "attributes" = @{ "key features" = @($features.naziv) } } ConvertTo-Json $item

That would produce the JSON you want.

If you have a string and need an array then use the Split operator to produce an array.

"PARIS Hidratacija Balzam" -split " "

Share via

Powershell arraylist to json

1 additional answer

Your answer