How to modify the content of an xml file in SharePoint Online by powershell

Question

I would like to fix some xml files seperated on multiple sites and document libraries in powershell. I have in a csv file the url of all these xml documents. So I already have some loop for each xml path. But how can I modify the content of these xml files? Do I need to download the file, modify it local and upload it again?

Answer 1

Yes, we need to download the XML file and update as per your need then upload back to the same location:

For update sample, you can refer the below PowerShell:

$Path = "\\spsite\sites\subsite\Library\" $Files = Get-ChildItem $Path | where {$_.extension -eq ".xml"} foreach($file in $Files){ $xml = New-Object XML $xml.PreserveWhitespace = $true $xml.Load($file.fullname) $xml.myFields.PhoneNumber = "234-5678"//update your fields on the form $xml.Save($file.fullname) } 

Reference:

Powershell to replace text in infopath XML files

OR

If your XML files are relatively smaller in size - then you may use the MemoryStream - MemoryStream sample as below:

$Stream = New-Object System.IO.MemoryStream $UDCX.Save($Stream) $document.SaveBinary($Stream.ToArray()) 

Reference:

Using powershell to read/modify/rewrite sharepoint xml document