How to parse XML in Powershell with Select-Xml and Xpath?

Question

obvious output for this example would be the date and time.

In the context of iterating over an xml document, how is this document correctly cast or converted to xml in Powershell dotnet core on Linux?

PS /home/nicholas/flwor> 
PS /home/nicholas/flwor> Select-Xml -Xml (Get-Date | ConvertTo-Xml) -XPath "/Objects/Object"

Node   Path        Pattern
----   ----        -------
Object InputStream /Objects/Object

PS /home/nicholas/flwor> 
PS /home/nicholas/flwor> (Get-Date | ConvertTo-Xml).OuterXml                                
<?xml version="1.0" encoding="utf-8"?><Objects><Object Type="System.DateTime">12/10/2020 5:12:45 AM</Object></Objects>
PS /home/nicholas/flwor>

updated with the simplest possible example.

So, this example is xml but: how is it parsed or queried with xpath?

alternate solution given in IRC:

PS /home/nicholas/flwor> 
PS /home/nicholas/flwor> $date.SelectSingleNode('/Objects/Object').'#text'
12/10/2020 5:07:04 AM
PS /home/nicholas/flwor>

no doubt that's doable with Select-Xml and Xpath.

Use quotes: $serviceStatePath = './serviceState.xml' or use a named (-Path) parameter. — iRon
– iRon, Commented Dec 10, 2020 at 12:23

Nicholas Saunders · Accepted Answer · 2020-12-10 13:25:54Z

0

if awkward, this works:

PS /home/nicholas/flwor> 
PS /home/nicholas/flwor> Select-Xml -Xml (Get-Date | ConvertTo-Xml) -XPath "/Objects/Object" |  Select-Object -ExpandProperty Node

Type            #text
----            -----
System.DateTime 12/10/2020 5:23:39 AM

PS /home/nicholas/flwor>

the help files had a similar example.

answered Dec 10, 2020 at 13:25

Nicholas Saunders

7741 gold badge11 silver badges36 bronze badges

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

1 Comment

zett42 Over a year ago

Returns date value directly: (Get-Date | ConvertTo-Xml | Select-Xml "/Objects/Object").Node.InnerText

Collectives™ on Stack Overflow

How to parse XML in Powershell with Select-Xml and Xpath?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related