Setting up a JSON object as a variable in a linux Powershell script

Question

I am currently sending in a list of key value variables from octopus to my project into my prompt. These are read and set in my environment by the code below.

$testKeys = $OctopusParameters.keys | Where-Object {$_ -like "test.env.*"}
ForEach ($key in $testKeys)
{
    $value = $OctopusParameters[$key]
    $name = $key.subString(9) # remove test.env prefix
    $kubectlArgs += "--env=`"$name=$value`""
}

This is coming back as follows:

> --env="ASPNETCORE_ENVIRONMENT=integration" 
> --env="ConnectionStrings__MongoDB=my mongo connectgion string" 
> --env="ServiceConfiguration__MyJSONObjectConfiguration=[ {'MyID': 23, 'URL': 'http://google.com/', 'User': 'MyUser',
> 'Password': 'test', 'Domain': 'MyDomain', 'Key': 'myKey'} ]"

So as you can see, this works perfectly when it is a one to one, key = string value. The problem is that for the serviceConfiguration I am passing in a JSON object.

My code is grabbing the values I need like so

"ServiceConfiguration:MyJSONObjectConfiguration:0"

How do I configure me PS1 script to treat the serviceConfiguration as JSON object and not a string? Is it even possible?

I don't understand what you're trying to do. PS1 is a string, it can contain some escape sequences to display special values, but it doesn't know anything about JSON. — Barmar
– Barmar, Commented Feb 24, 2020 at 22:10
@Barmar sorry it is a powershell script is there any way of setting into a JSON object or the propery way of doing it? Or should I just send the string back to my code and deal it with it there? — Lostaunaum
– Lostaunaum, Commented Feb 24, 2020 at 22:13

Kory Gill · Accepted Answer · 2020-02-24 23:40:22Z

1

I am not sure you have provided enough information to solve your problem fully. One possibility is if the value starts with '[' then treat as JSON and use CovertFrom-Json.

Something like:

"[ {'MyID': 23, 'URL': 'http://google.com/', 'User': 'MyUser', 'Password': 'test', 'Domain': 'MyDomain', 'Key': 'myKey'} ]" | ConvertFrom-Json

Which gives an object like:

MyID     : 23
URL      : http://google.com/
User     : MyUser
Password : test
Domain   : MyDomain
Key      : myKey

answered Feb 24, 2020 at 23:40

Kory Gill

7,1711 gold badge28 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Setting up a JSON object as a variable in a linux Powershell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related