Need to generate a paramater file

[rsunderkartik]

I have a csv like the and I want to create a parameter file in Json which nests the subnet under vnet

Azuresubscription1 | rg-centralus-hub-001 | centralus | vnet-centralus-hub-001 | sn-centralus-hub-core-trust | 10.151.0.0/27
Azuresubscription1 | rg-centralus-hub-001 | centralus | vnet-centralus-hub-001 | sn-centralus-hub-edge-untrust | 10.151.0.32/27
Azuresubscription1 | rg-centralus-hub-001 | centralus | vnet-centralus-hub-001 | sn-centralus-hub-edge-trust | 10.151.0.64/27
Azuresubscription1 | rg-centralus-hub-001 | centralus | vnet-centralus-hub-001 | sn-centralus-hub-ec-wan0 | 10.151.0.96/27
Azuresubscription1 | rg-centralus-hub-001 | centralus | vnet-centralus-hub-001 | sn-centralus-hub-ec-lan0 | 10.151.0.128/27
Azuresubscription1 | rg-centralus-hub-001 | centralus | vnet-centralus-hub-001 | sn-centralus-hub-services | 10.151.1.0/24
Azuresubscription1 | rg-centralus-hub-001 | centralus | vnet-centralus-hub-001 | AppGateway | 10.152.2.0/24
Azuresubscription1 | rg-centralus-hub-001 | centralus | vnet-centralus-hub-001 | sn-centralus-hub-mgmt | 10.153.7.0/24

---

Powershell Script

$inputfile = Import-Csv 'C:\Azure\UserScripts\newhub-spoke\Book3.csv'

subnetentries = @()

    foreach ($item in $inputfile){
        $outputformat = New-Object Psobject
        $outputformat | Add-Member -MemberType NoteProperty -Name "Subscription" -value ($item.Subscription)
        $outputformat | Add-Member -MemberType NoteProperty -Name "rgname" -value ($item.rgname)
        $outputformat | Add-Member -MemberType NoteProperty -Name "region" -value ($item.region)
        $outputformat | Add-Member -MemberType NoteProperty -Name "Vnetname" -value ($item.Vnetname)
        $outputformat | Add-Member -MemberType NoteProperty -Name "subnet" -value ($subnet)
        if (($item.Vnetname -eq "$uniquehub")){
            $obj = New-Object Psobject
            $obj | Add-Member -MemberType NoteProperty -Name "subnetname" -value  ($subnet.add($item.subnetname))
            $obj | Add-Member -MemberType NoteProperty -Name "subnetaddr" -value  ($subnet.add($item.subnetaddr))
            #Write-Host "$uniquehub"}
            $obj
            $subnet +=  $obj
        }
    }

---

Desired Output in Json

    {
        "Subscription":  "sub-hub",
        "rgname":  "rg-usw2-hub-001",
        "region":  "westus2",
        "addrspace":  "10.151.0.0/21",
        "vnetnames":  "vnet-usw2-hub-001",
        "subnets":  [
                        {
                            "subnetname":  "sn-usw2-hub-core-trust",
                            "subnetaddr":  "10.151.0.0/27"
                        },
                        {
                            "subnetname":  "sn-usw2-hub-edge-untrust",
                            "subnetaddr":  "10.151.0.32/27"
                        },
                        {
                            "subnetname":  "sn-usw2-hub-edge-trust",
                            "subnetaddr":  "10.151.0.64/27"
                        },
                        {
                            "subnetname":  "sn-usw2-hub-ec-wan0",
                            "subnetaddr":  "10.151.0.96/27"
                        },
                        {
                            "subnetname":  "sn-usw2-hub-ec-lan0",
                            "subnetaddr":  "10.151.0.128/27"
                        },
                        {
                            "subnetname":  "sn-usw2-hub-services",
                            "subnetaddr":  "10.151.1.0/24"
                        },
                        {
                            "subnetname":  "AppGateway",
                            "subnetaddr":  "10.152.2.0/24"
                        },
                        {
                            "subnetname":  "sn-usw2-hub-mgmt",
                            "subnetaddr":  "10.153.7.0/24"
                        }
                    ]
    }
]

[isra-fel]

Welcome to the discussion @rsunderkartik
I'm not sure if I understand you. Could you elaborate your question again?