Change XML attributes to tag using powershell

Question

I have an PSCustomObject, I want to convert to xml using powershell. When I convert using ConvertTo-Xml, I am using following command to convert

$test = ConvertTo-Xml -As String -NoTypeInformation -InputObject $data

It is converting to xml in below format.

<?xml version="1.0" encoding="utf-8"?>
<Objects>
   <Object>
      <Property Name="ABC">1</Property>
      <Property Name="PQR">2</Property>      
      <Property Name="XYZ">3</Property>
   </Object>
</Objects>

whereas I want to be in below format.

<?xml version="1.0" encoding="utf-8"?>
<Objects>
   <Object>
      <ABC>1</ABC>
      <PQR>2</PQR>
      <XYZ>3</XYZ>
   </Object>
</Objects>

How can I do this?

Can you edit your question and show what your object looks like exactly? — Jack Fleeting, Jul 12 '23 at 11:28

score 0 · Answer 1 · answered Jul 12 '23 at 08:02

0

You could use xsl for this. See this answer how to use xsl in powershell

And this xsl would do the job:

<xsl:stylesheet version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

  <xsl:strip-space elements="*"/>  

  <xsl:template match="node()|@*">
    <xsl:copy>
      <xsl:apply-templates select="node()|@*"/>
    </xsl:copy>
  </xsl:template>
  
  <xsl:template match="Property">
    <xsl:element name="{@Name}">
      <xsl:value-of select="text()"/>
    </xsl:element>
  </xsl:template>
    
</xsl:stylesheet>

answered Jul 12 '23 at 08:02

Siebe Jongebloed

3,906
2
14
19

I don't want to read from file and write result to file, I want to read the XML from object and get the result in another object , how can I do it ? – Prasad Gavande Jul 12 '23 at 09:37
Also, reading xslt file every time may be heavy operation for me because I will have more than 50k objects to process.. is there any other way to do ? – Prasad Gavande Jul 12 '23 at 09:45
Would [this blogpost](https://devio.wordpress.com/2009/09/15/command-line-xslt-processor-with-powershell/) help you? Btw xslt is extremely fast – Siebe Jongebloed Jul 12 '23 at 10:39
With above blogpost, it is still output to file .. – Prasad Gavande Jul 14 '23 at 02:16

score 0 · Answer 2 · answered Jul 12 '23 at 12:25

Use Xml Linq with Powershell

using assembly System.Xml.Linq
$inputFilename = "c:\temp\test.xml"
$outputFilename = "c:\temp\test1.xml"

$doc = [System.Xml.Linq.XDocument]::Load($inputFilename)

$object = $doc.Descendants("Object")[0]
$properties = $object.Elements()
$Object.RemoveNodes()

foreach($property in $properties)
{
   $name = $property.Attribute("Name").Value
   $value = $property.Value
   $newElement = [System.Xml.Linq.XElement]::new([System.Xml.Linq.XName]::Get($name),$value);
   $object.Add($newElement)
}
$doc.Save($outputFilename)

You can use the $test string in above by changing the Load method to Parse : $doc = [System.Xml.Linq.XDocument]::Parse($test) — jdweng, Jul 13 '23 at 14:15

Change XML attributes to tag using powershell

2 Answers2