Parsing XML with namespace with PowerShell

Question

I need a little help with understanding of an XML in PowerShell. I have several XML files like this:



    
        ...
        true
        false
        true
        true
        false
        true
        ...
    
    
        ...
        true
        true
        false
        true
        false
        fasle
        ...
    
    
        ...
        true
        true
        false
        true
        false
        true
        ...

I need to get the values of two elements in PowerShell:

(without site-id attribute)

for the product with product-id="50610".

I have the following code:

$Path = "C:\Temp\0\2017-08-12_190211.xml"
$XPath = "/ns:catalog/ns:product[@product-id='50610']"

$files = Get-ChildItem $Path | Where {-not $_.PSIsContainer}

if ($files -eq $null) {
    return
}

foreach ($file in $files) {
    [xml]$xml = Get-Content $file
    $namespace = $xml.DocumentElement.NamespaceURI
    $ns = New-Object System.Xml.XmlNamespaceManager($xml.NameTable)
    $ns.AddNamespace("ns", $namespace)
    $product = $xml.SelectSingleNode($XPath, $ns)
}

Several questions:

With this code I am able to select the needed product node. PowerShell shows:
```
online-flag        : {true, online-flag, online-flag, online-flag...}
```
But how then I can select the values of the needed online-flag elements (if it is possible both ways: XPath one and the object one)?

Is it possible to select a node in the "object" way? Like this:

$product = $xml.catalog.product |
           Where-Object {$_."product-id".value -eq "50610"}

If I have several files, what is the best way to select filename, global online-flag (without attributes), specific online-flag?

Parsing XML with namespace with PowerShell

3 Answers