How to get the value as an array of strings from powershell hashtable

Question

I have an array of hash table containing key value pairs, like below:

$myTest = @{};
$test1 = @{
    Name = "Food1"
    Value = "Sandwich"
    }
    $test2 = @{
    Name = "Food2"
    Value = "Salad"
    }
$myTest["Food1"] = $test1;
$myTest["Food2"] = $test2

On running the command $myUpdatedTest = $myTest.Values | ConvertTo-Json -Compress

gives the value in $myUpdatedTest --> [{"Value":"Sandwich","Name":"Food1"},{"Value":"Salad","Name":"Food2"}]

And if I have only $test1 added to the $myTest then the value comes in as {"Value":"Sandwich","Name":"Food1"} But in the later case I want the value to be inside [] --> [{"Value":"Sandwich","Name":"Food1"}] is there a way to achieve this?

Avoid piping the input: $myUpdatedTest = ConvertTo-Json -InputObject $myTest.Values — Mathias R. Jessen
– Mathias R. Jessen, Commented May 26, 2022 at 10:30

Otter · Accepted Answer · 2022-05-26 10:33:05Z

2

The issue with this is how you are sending the object to the ConvertTo-Json cmdlet.

I managed to get this working by changing

$myUpdatedTest = $myTest.Values | ConvertTo-Json -Compress

to

$myUpdatedTest = ConvertTo-Json -Compress -InputObject $myTest.Values

This then evaluates the whole $myTest.Values object as opposed to each value one by one. I hope this makes sense?

answered May 26, 2022 at 10:33

Otter

1,1729 silver badges20 bronze badges

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

Comments

nimizen · Accepted Answer · 2022-05-26 10:29:57Z

1

Kinda clunky, but this works:

$myTest = @{};
$test1 = @{
Name = "Food1"
Value = "Sandwich"
}
$test2 = @{
Name = "Food2"
Value = "Salad"
}
$myTest["Food1"] = $test1;
$myTest["Food2"] = $test2

if($myTest){

    if($myTest.Count -eq 1){

        $myUpdatedTest = "[$($myTest.Values | ConvertTo-Json -Compress)]"
    }else{

        $myUpdatedTest = $myTest.Values | ConvertTo-Json -Compress
    }
}

$myUpdatedTest

answered May 26, 2022 at 10:29

nimizen

3,4292 gold badges26 silver badges35 bronze badges

1 Comment

eightynine Over a year ago

Thanks @nimizen, I wanted to avoid the if condition (should've mentioned in the question)

Collectives™ on Stack Overflow

How to get the value as an array of strings from powershell hashtable

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related