Parsing JSON in PowerShell using ConvertFrom-Json

gistfile1.ps1

$json = @"
{"A": {"property1": "value1", "property2": "value2"}, "B": {"property1": "value3", "property2": "value4"}}
"@

$parsed = $json | ConvertFrom-Json
foreach ($line in $parsed | Get-Member) {
	echo $parsed.$($line.Name).property1
	echo $parsed.$($line.Name).property2
}

Hello!

I don't know JSON so I did this:

@(
    [pscustomobject]@{A=$([pscustomobject]@{property1= 'value1';property2='value2'})}
    [pscustomobject]@{B=$([pscustomobject]@{property1='value3';property2='value4'})}
    ) | ConvertTo-Json

This produces:

[
    {
        "A":  {
                  "property1":  "value1",
                  "property2":  "value2"
              }
    },
    {
        "B":  {
                  "property1":  "value3",
                  "property2":  "value4"
              }
    }
]

Seems like an odd object model - this might be the basis behind the difficulty working with the data, rather than PowerShell. Did you mean something like this?

[
    {
        "property1":  "value1",
        "property2":  "value2"
    },
    {
        "property1":  "value3",
        "property2":  "value4"
    }
]

Which produces this:

$parsed = @"
[
    {
        "property1":  "value1",
        "property2":  "value2"
    },
    {
        "property1":  "value3",
        "property2":  "value4"
    }
]
"@ | convertfrom-json

foreach($line in $parsed){
   $line.property1
   $line.property2
}

Cheers!