Create new element in existing XML Document using Powershell

Question

I have a script that reads from an XML file, performs some web services, from which it gets a response and I'd now like the XML fie to be amended with the webs response as below.

Original XML:

<ItemNum>
    <Key>11233</Key>
    <Item>123.jpg</Item>
    <Item>456.jpg</Item>
    <Item>789.jpg</Item>
    <Detail>Processed on 8-12-2017</Detail>
</ItemNum>

The script will process the items from the XML and iterate through the itemlist, similar to below:

[xml]$xml = Get-Content -Path $xmlPath

Foreach ($websResponse in $websResponseList) {
    <Create New Element>
    <Add Webs Response to Element>
}

$xml.save($xmlPath)

The result should be the original XML modified to look like the below:

<ItemNum>
    <Key>11233</Key>
    <Item>123.jpg</Item>
    <Item>456.jpg</Item>
    <Item>789.jpg</Item>
    <Detail>Processed on 8-12-2017</Detail>
    <WebS>00001</WebS>
    <WebS>00002</WebS>
    <WebS>00003</WebS>
</ItemNum>

I've read countless articles on working with XML in Powershell and probably some that are very similar what I'm trying to achieve but this is for some reason stumping me so would appreciate any pointers.

Palle Due · Accepted Answer · 2017-12-08 11:15:00Z

1

You're almost there:

[xml]$xml = Get-Content -Path $xmlPath

foreach ($websResponse in $websResponseList) 
{
    $elem = $xml.CreateElement('WebS','00001') # substitute with data
    $xml.ItemNum.AppendChild($elem)
}
$xml.save($xmlPath)

answered Dec 8, 2017 at 11:15

Palle Due

6,3224 gold badges22 silver badges36 bronze badges

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

2 Comments

Rob Berry Over a year ago

Thanks Palle, almost there! This created 3 new elements but the data is inside the element like this '<WebS xmlns="00001" /> as opposed to <WebS>"00001"</WebS>. Is this something to do with OuterXML, InnerXml ?

Rob Berry Over a year ago

ok I have it. I just needed an extra line with the content of the element which was $elem.InnerXml = '00001'. Thanks Palle!

Collectives™ on Stack Overflow

Create new element in existing XML Document using Powershell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related