XML element name of an attribute using Powershell

Question

I would like to get the xml element name of an attribute using powershell. Can anyone please let me know if we have a built in function for the same.

Following is my xml file called pricefile.xml

 <model type="model1" name="default" price="12.12" date="some_value">
  <PriceData>
    <item name="watch" price="24.28" date="2013-12-01"/>
    <item name="toy" price="22.34" date="2013-12-02"/>
    <item name="bread" price="24.12" date="2013-12-03"/>
  </PriceData>
 </model>

Say I want to get the element name "item" for the attribute "toy". How can I get this data?

This is what I have so far.

[xml]$item = get-content pricefile.xml
$item.SelectNodes("//item") | where {$_.name -like "toy"}

which gives me the below output, but I do not know how to get the element of the attribute from here or it's parent node.

name            price                   date                                             
----            -----                   ----                                             
toy             22.34                   2013-12-02

Flynn Handley · Accepted Answer · 2017-03-17 06:24:20Z

2

If you'd like to get the parent node you can try this: ($item.SelectNodes("//item") | where {$_.name -like "toy"}).ParentNode

If you would like to access another attribute within your item element, you can do so like this: ($item.SelectNodes("//item") | where {$_.name -like "toy"}).price

You can access the XmlElement.Name Property property like so:

(($item.SelectNodes("//item")))[0].name

answered Mar 17, 2017 at 6:24

Flynn Handley

4501 gold badge5 silver badges10 bronze badges

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

Comments

har07 · Accepted Answer · 2017-03-17 06:37:49Z

You can get it from XmlElement.LocalName property, for example :

λ $item = [xml]@"
>> <model type="model1" name="default" price="12.12" date="some_value">
>>   <PriceData>
>>     <item name="watch" price="24.28" date="2013-12-01"/>
>>     <item name="toy" price="22.34" date="2013-12-02"/>
>>     <item name="bread" price="24.12" date="2013-12-03"/>
>>   </PriceData>
>>  </model>
>> "@
λ $item.SelectNodes("//item") | where {$_.name -like "toy"} | select LocalName

LocalName
---------
item

λ $item.SelectNodes("//*[contains(@name,'toy')]") | select LocalName   

LocalName                                                              
---------                                                              
item

Collectives™ on Stack Overflow

XML element name of an attribute using Powershell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related