nested XML parsing in powershell

Question

I am trying to use powershell to parse an XML file to get the value of a specific field. I am running into some issues with getting into the nested objects trying with both Select-XML and [xml]$cn = Get-Content file.xml

I was wondering if anyone would be able to take a look and offer a hand ?

<DentalContainer version="2019-1">
  <Object name="MainObject" type="TDM_Container">
    <Object name="OrderList" type="TDM_List_Order">
      <List name="Items">
        <Object type="TDM_Item_Order">
          <Property name="ClientID" value="91494"/>
          <Property name="ClientOrderNo" value=""/>
          <Property name="ClientContactPerson" value=""/>
          <Property name="OrderImportanceID" value="oiNormal"/>
          <Property name="Patient_RefNo" value=""/>
          <Property name="Patient_FirstName" value=""/>
          <Property name="Patient_LastName" value="testest"/>
          <Property name="DeliveryAddress1" value=""/>
          <Property name="DeliveryAddress2" value=""/>
          <Property name="DeliveryZip" value=""/>
          <Property name="DeliveryCity" value=""/>
          <Property name="DeliveryState" value=""/>
          <Property name="DeliveryCountryID" value=""/>
          <Property name="DeliveryType" value=""/>
          <Property name="ManufName" value="XYZ"/>
          <Property name="OperatorName" value="SIMPLE"/>
        </Object>
      </List>
    </Object>    
    <Property name="ImportForceOverwrite" value="false"/>
    <Property name="ImportForceClean" value="false"/>
    <Property name="EmptyRecycleBin" value="false"/>
  </Object>
</DentalContainer>

Does this answer your question? Parsing xml using powershell — Jawad
– Jawad, Commented Feb 4, 2020 at 1:28

Jawad · Accepted Answer · 2020-02-04 02:38:24Z

1

Given your xml file, you can use the XPath to look up certain values or properties from it. Since your question is vague, as in what you were interested in, following is a sample on how to access the property attributes (name and value).

[xml]$cn = Get-Content C:\temp\xml.txt

# Single Node
$OrderImportanceID = $cn.DocumentElement.SelectSingleNode("//Property[@name='OrderImportanceID']").Attributes["value"].Value

# All Nodes that match Element with Property tag.
$allProperties = $cn.DocumentElement.SelectNodes("//Property")

# You Can loop all the properties and print each name and value
foreach($prop in $allProperties) {
    Write-output "Property Name: $($prop.Name), Value: $($prop.value)"
}

XPath syntax reference

answered Feb 4, 2020 at 2:38

Jawad

11.4k3 gold badges28 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

nested XML parsing in powershell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related