Can I Iterate from JSON array in PowerShell?

Question

I'm using Azure Pipelines to make some automations, and in one job I wish to iterate from a JSON to config WebApp settings. I'm using powershell, but I'm struggling to do something like this, made in Python:

import json

varJson = json.loads('''{
        "key1": "value1", 
        "key2": "value2", 
        "key3": "value3",
        "key4": "value4"
    }''')

for i in varJson:
    print(f'az webapp config appsettings set -g resourceGroup -n appName --settings {i}=\"{varJson[i]}\"')

The output I wish is something like:

az webapp config appsettings set -g resourceGroup -n appName --settings key1="value1"
...

I tried to use objects, but it's confuse to me:

$Json = @'
{
    "key1": "value1", 
    "key2": "value2", 
    "key3": "value3",
    "key4": "value4"
}
'@ | ConvertFrom-Json
ForEach-Object -InputObject $Json {
    Write-Host $_.PSObject.Properties.Name 
}
Write-Host $Json

Can I do something in PowerShell similar of what I did in python? Or there's an easier way?

mklement0 · Accepted Answer · 2021-09-15 21:59:03Z

Try the following:

$fromJson = @'
{
    "key1": "value1", 
    "key2": "value2", 
    "key3": "value3",
    "key4": "value4"
}
'@ | ConvertFrom-Json

foreach ($prop in $fromJson.psobject.Properties) {
  @"
    az webapp config appsettings set -g resourceGroup -n appName --settings "$($prop.Name)=$($prop.Value)"
"@
}

Note:

.psobject is an intrinsic member that PowerShell makes available on objects of any type, and it is a rich source of reflection; its .Properties property returns a collection of objects describing the properties of the object at hand, each of which have a .Name and .Value property.
As in your Python code, the az command line is merely printed as a string, not invoked.
- To perform the actual invocations, remove the @" and "@ lines (the construct as a whole is a PowerShell here-string).
"$($prop.Name)=$($prop.Value)" results in something like "key1=value1", which PowerShell would pass without quoting to az; only if the value part contained spaces would PowerShell double-quote the - entire - argument.
- If az requires partial quoting on its command line, such as key1="value 1", the easiest solution is to call via cmd.exe /c:
```
cmd /c "az webapp config appsettings set -g resourceGroup -n appName --settings $($prop.Name)=`"$($prop.Value)`""
```
- If you want to be shielded from such intricacies, consider installing the Native module (Install-Module Native), whose ie function automatically performs the partial quoting for you (if the value part contains spaces), among other features, so that you can focus on PowerShell's syntax alone:
```
ie az webapp config appsettings set -g resourceGroup -n appName --settings "$($prop.Name)=$($prop.Value)"
```

Collectives™ on Stack Overflow

Can I Iterate from JSON array in PowerShell?

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