Generating JSON from a xml document / Powershell / controlling the array format

Question

I need to read some data from an XML document and then format it as JSON to submit as a POST to a new webservice we're deploying.

While I got most of it to work, I'm not really happy with how the JSON is coming out (I can modify the webservice if needed, so the data format issue I have now is mostly cosmetic).

So... Data source (the xml file):

<ConfigRepository ServiceUri="http://somemachine"
                  ConnectionTimeout="10000"
                  CacheEnabled="true"
                  CacheExpirationDuration="600"
                  ServiceMonitorPollDuration="10" />

Powershell code reading this/generating the JSON:

$configRepository = @()
foreach($attr in ($xml.Configuration.ConfigRepository).attributes)
{
    $configRepository += @{ $attr.Name = $attr.Value} 
}

When output to JSON, I get something like this:

"ConfigRepository":  [
    {
        "CacheEnabled":  "true"
    },
    {
        "CacheExpirationDuration": "600"
    },
    {
        "ConnectionTimeout":  "10000"
    },
    {
        "ServiceMonitorPollDuration":  "10"
    },
    {
        "ServiceUri":  "http://somemachine"
    },
]

The actual question:

Is there a way to keep my PS code generic, but with an output like this instead?

"ConfigRepository":  [
    {
        "CacheEnabled":  "true"
        "CacheExpirationDuration": "600"
        "ConnectionTimeout":  "10000"
        "ServiceMonitorPollDuration":  "10"
        "ServiceUri":  "http://somemachine"
    },
]

$configRepository is an array. How are you converting the array to JSON? — Jason Snell
– Jason Snell, Commented Jul 18, 2017 at 14:18
Using the standard ConvertTo-Json - this array is part of a much larger array, I posted only some parts relevant to the question at hand... — Nuno Linhares
– Nuno Linhares, Commented Jul 18, 2017 at 14:20

G42 · Accepted Answer · 2017-07-18 14:20:11Z

1

Doesn't nest the hashtable in an array - remove $configRepository = @()

foreach($attr in ($xml.Configuration.ConfigRepository).attributes)
{
    $configRepository += @{ $attr.Name = $attr.Value} 
}

answered Jul 18, 2017 at 14:20

G42

10.1k2 gold badges22 silver badges36 bronze badges

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

2 Comments

Nuno Linhares Over a year ago

Wow, that simple! Thank you SO much. - I'll accept it when I can (apparently need to wait a few more minutes).

G42 Over a year ago

@NunoLinhares No problem! Reg simplicity, PowerShell is nice like that. Previously, another StackOverflow soul had the opposite problem

Collectives™ on Stack Overflow

Generating JSON from a xml document / Powershell / controlling the array format

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related