powershell, xml and namespaces

Question

I have some XML:

<SOAP:Envelope xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">
  <SOAP:Body>
    <P2MessageServiceStatus>
      <CONNECTION>CONNECTION_CONNECTED</CONNECTION>
      <ROUTER>ROUTER_CONNECTED</ROUTER>
    </P2MessageServiceStatus>
  </SOAP:Body>
</SOAP:Envelope>

Can't deal with it because of namespaces. Trying a lot, but not working.

[string]$xpath = '/SOAP:Envelope/SOAP:Body/P2MessageServiceStatus/@CONNECTION'

$wc = New-Object Net.WebClient
[xml]$stuff = $wc.DownloadString($url)

$ns = New-Object Xml.XmlNamespaceManager $stuff.NameTable
$ns.AddNamespace("SOAP", $xmlns)

$xmlvalue = $stuff.SelectSingleNode($xpath, $ns)

Error - need Namespace manager or XsltContext

If

$xmlvalue = $stuff.SelectSingleNode($xpath,'SOAP')

Error - Unable to find overload for "SelectSingleNode"

How to make that xpath query work with namespaces?

Martin Brandl · Accepted Answer · 2016-05-09 20:10:55Z

2

I don't see your $xmlns defined. This works:

[string]$xpath='/SOAP:Envelope/SOAP:Body/P2MessageServiceStatus/CONNECTION'

$namespaceMgr = New-Object System.Xml.XmlNamespaceManager $stuff.NameTable
$namespace = $stuff.DocumentElement.NamespaceURI
$namespaceMgr.AddNamespace("SOAP", $namespace)


$stuff.SelectSingleNode($xpath,$ns)

Note: You can also access the nodes like properties with PowerShell:

$stuff.DocumentElement.Body.P2MessageServiceStatus.CONNECTION

edited May 9, 2016 at 20:10

answered May 9, 2016 at 20:03

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

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

5 Comments

Igor Kuznetsov Over a year ago

if i use $stuff.SelectSingleNode($xpath,$namespace) its not work at all. If $stuff.SelectSingleNode($xpath,$namespaceMgr) it returns value but also i got exception 'cant find reload for SelectSingleNode and 2 methods...' ... is it normal ?

Igor Kuznetsov Over a year ago

omg i got that exception on work pc but not on my server... it works..thank you a lot

Igor Kuznetsov Over a year ago

if i see variable $namespaceMgr i will see 3 of them - xmlns,xml, SOAP. could it be an errors reason?

Timo Over a year ago

My xml to parse starts with

<?xml version="1.0"?>  <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/" s:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> <s:Body> <u:GetInfoResponse xmlns:u="urn:dslforum-org:service:WLANConfiguration:1">...

. How can I parse it? This works: $xml=[xml]$xml.Content;Write-Host $xml.xml which gives version="1.0" but $xml.DocumentElement prints nothing. Do I need a namespacemanager and $xpath?

Timo Over a year ago

Instead of $stuff.SelectSingleNode($xpath,$ns) you mean $stuff.SelectSingleNode($xpath,$namespace)?

Collectives™ on Stack Overflow

powershell, xml and namespaces

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related