JSON Array - Powershell

Question

I need an JSON array string like the following: [{"a":"1","b":"2","c“:"3","d": "4"}]

If I am using the following code, I am getting {medik:[{"a":"1","b":"2","c“:"3","d": "4"}]}

$body = @{
   medik =  @(
        @{
            a = '1'
            b = '2'
            c = '3'
            d = '4'
        }
    )
}
$jsbody=$body|ConvertTo-Json -Compress;
$jsbody

Can anyone help me? Thanks in advance!

Why do you have medik =

Nico Nekoru
– Nico Nekoru

2020-07-20 22:19:33 +00:00
Commented Jul 20, 2020 at 22:19 — Nico Nekoru
– Nico Nekoru, Commented Jul 20, 2020 at 22:19

ekeeling · Accepted Answer · 2020-07-20 22:49:38Z

2

Try it without using the pipeline.

When using the pipeline you are passing the array one hashtable at a time to ConvertTo-Json. Since there is only one hashtable, it is seen as a single hashtable not an array of hashtables.

ConvertTo-Json @(@{a = '1'; b = '2'; c = '3'; d = '4'})

Output:

PS C:\tmp\overflow> $body = @(@{a = '1'; b = '2'; c = '3'; d = '4'})
>> ConvertTo-Json $body

[
  {
    "d": "4",
    "c": "3",
    "b": "2",
    "a": "1"
  }
]

answered Jul 20, 2020 at 22:49

ekeeling

3912 silver badges8 bronze badges

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

1 Comment

ekeeling Over a year ago

Not a problem. If you feel this is the correct answer, please remember to mark it as accepted.

Collectives™ on Stack Overflow

JSON Array - Powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related