Unable to get array inside a array list in powershell to json

Question

I am trying to write a PowerShell script that will return me a JSON...This is what I have been able to get.

$stepBase = @{}
$wizardDataArray = @{}
$stepTypeData =@{}
$step = New-Object System.Collections.ArrayList

$wizardData = @{"mode"="Add"; "resourceName"="basicServer";
"serverName"="demoServer"; "serverAddress"="xyz.abc.info";
"activeDbCatalog"="demodb";}

$stepData = @{"wizardType"="baseServer"; "wizardData"=$wizardData}

$stepTypeData = @{"stepType"="runWizard"; "stepData"=$stepData}
$step.Add(@{"steps"=$stepTypeData})


$stepBase.Add("steps", $step)
$stepBase | ConvertTo-Json -Depth 10

This is the ouput :

0
{
  "steps": [
    {
      "steps": {
        "stepData": {
          "wizardType": "baseServer",
          "wizardData": {
            "serverAddress": "xyz.abc.info",
            "activeDbCatalog": "demodb",
            "resourceName": "basicServer",
            "mode": "Add",
            "serverName": "demoServer"
          }
        },
        "stepType": "runWizard"
      }
    }
  ]
}

But this is different from my need...which is this...

{
  "steps": [
    {
      "stepType": "runWizard",
      "stepData": {
        "wizardType": "baseServer",
        "wizardData": {
          "mode": "Add",
          "resourceName": "basicServer",
          "serverName": "demoServer",
          "serverAddress": "xyz.abc.info",
          "activeDbCatalog": "demoDb"
        }
      }
    }
  ]
}

I am not able to get my array inside the list without mentioning the key "step".

Sharad esdee Dutta · Accepted Answer · 2021-10-20 07:20:05Z

2

Try this...

$stepBase = @{}
$step = New-Object System.Collections.ArrayList

$wizardData = @{"mode"="Add"; "resourceName"="basicServer";
"serverName"="demoServer"; "serverAddress"="xyz.abc.info";
"activeDbCatalog"="demodb";}

$stepData = @{"wizardType"="demoServer"; "wizardData"=$wizardData}

$step.Add(@{"stepType"="runWizard"; "stepData"=$stepData})
$stepBase.Add("steps", $step)
$stepBase | ConvertTo-Json -Depth 10

answered Oct 20, 2021 at 7:20

Sharad esdee Dutta

1,14713 silver badges27 bronze badges

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

Comments

Guenther Schmitz · Accepted Answer · 2021-10-20 06:50:45Z

0

so what if you skip the very last assignment and convert $step to JSON? like so:

$wizardDataArray = @{}
$stepTypeData =@{}
$step = New-Object System.Collections.ArrayList

$wizardData = @{"mode"="Add"; "resourceName"="basicServer";
"serverName"="demoServer"; "serverAddress"="xyz.abc.info";
"activeDbCatalog"="demodb";}

$stepData = @{"wizardType"="baseServer"; "wizardData"=$wizardData}

$stepTypeData = @{"stepType"="runWizard"; "stepData"=$stepData}
$step.Add(@{"steps"=$stepTypeData})


$step | ConvertTo-Json -Depth 10

answered Oct 20, 2021 at 6:50

Guenther Schmitz

2,0191 gold badge13 silver badges23 bronze badges

1 Comment

horizon Over a year ago

Hello, Actually I need a all of it to be wrapped inside "steps" with a square bracket i.e. I need them to be wrapped inside a ArrayList

Collectives™ on Stack Overflow

Unable to get array inside a array list in powershell to json

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