Quickest Way to Import XML and output to Azure Blob in CSV format

Question

I was wondering what is the quickest way to receive a xml file and be able to convert to csv and put into azure blob.

Answer 1

Hello @Nathaniel B Szypulinski ,
I was thinking the quick way is to use the PowerShell script.

$xmlfilePath = "C:\azure\xmlfilename.xml" (if the file is remote then use: (Invoke-webrequest -URI "path").Content > $xmlfilePath )
$csvfilePath = "C:\azure\filename.csv"
[xml]$XmlFileContent = Get-Content -Path $xmlfilePath
$XmlFileContent.catalog.ChildNodes | Export-Csv -Path $csvfilePath -NoTypeInformation -Delimiter:","
//above code was to convert xml to csv
//below code is to upload that csv to blob storage account

$uploadstorage=Get-AzStorageAccount -ResourceGroupName "resourcegroupname" -Name "storageaccountname"
$storcontext=$uploadstorage.Context
Set-AzStorageBlobContent -Container "containername" -File $csvfilePath -Context $storcontext