Parsing XML to CSV

Export.ps1

Add-Type -AssemblyName System.Xml.Linq

$reader = [System.Xml.XmlReader]::Create("./magnified.xml")

$reader.ReadStartElement("response")
$reader.ReadStartElement("row")

$csv = @()

while(!$reader.EOF) {
    if ($reader.IsStartElement() -and $reader.Name -eq "row") {
        $element = [System.Xml.Linq.XElement]::ReadFrom($reader)
        
        if ($null -ne $element) {
            $csv += [PSCustomObject]@{
                ZipCode = $element.Element("zip_code").Value
                TotalPopulation = $element.Element("total_population").Value
                MedianAge = $element.Element("median_age").Value
                TotalMales = $element.Element("total_males").Value
                TotalFemales = $element.Element("total_females").Value
                TotalHouseholds = $element.Element("total_households").Value
                AverageHouseholdSize = $element.Element("average_household_size").Value
            } 
        }
    } else {
        $reader.Read() | Out-Null
    }
}

$csv | Export-Csv -Path ./Out.csv -NoTypeInformation