XML Parsing in Powershell - Specific value

Question

I'm trying to get the values , I need to retrieve all httpurl & count under all result tag

Below is my sample XML :

<?xml version='1.0' encoding='UTF-8'?>
<results preview='0'>`enter code here`
<meta>
<fieldOrder>
<field>http_url</field>
<field>count</field>
</fieldOrder>
</meta>
  <result offset='0'>
    <field k='http_url'>
      <value h='1'><text>sample/1</text></value>
    </field>
    <field k='count'>
      <value><text>1</text></value>
    </field>
  </result>
  <result offset='1'>
    <field k='http_url'>
      <value h='1'><text>sample/2</text></value>
    </field>
    <field k='count'>
      <value><text>1</text></value>
    </field>
  </result>
  <result offset='2'>
    <field k='http_url'>
      <value h='1'><text>sample/3</text></value>
    </field>
    <field k='count'>
      <value><text>1</text></value>
    </field>
  </result>
  <result offset='3'>
    <field k='http_url'>
      <value h='1'><text>sample/4</text></value>
    </field>
    <field k='count'>
      <value><text>1</text></value>
    </field>
  </result>
  <result offset='4'>
    <field k='http_url'>
      <value h='1'><text>sample/5</text></value>
    </field>
    <field k='count'>
      <value><text>1</text></value>
    </field>
  </result>
</results>

score 3 · Answer 1 · edited Dec 27 '20 at 16:31

Using your example xml, you can do this to get an array of objects that have the url and the count:

[xml]$xml = Get-Content -Path 'D:\Test\test.xml' -Raw

# loop through the tags and return an array of PSObjects
# each having two properties: 'http_url' and 'count'
$xml.results.result | ForEach-Object {
    [PsCustomObject] @{
        http_url = ($_.field | Where-Object { $_.k -eq 'http_url' }).value.text
        count    = [int]($_.field | Where-Object { $_.k -eq 'count' }).value.text
    }
}

Result:

http_url count
-------- -----
sample/1     1
sample/2     1
sample/3     1
sample/4     1
sample/5     1

Using `Get-Content` can mess up the encoding of the XML file, see https://stackoverflow.com/a/65264118/7571258 — zett42, Dec 27 '20 at 17:21

score 1 · Answer 2 · answered Dec 27 '20 at 23:24


$xmlDoc = [xml]@"
<?xml version="1.0" encoding="UTF-8"?>
<results preview="0">
   'enter code here'
   <meta>
      <fieldOrder>
         <field>http_url</field>
         <field>count</field>
      </fieldOrder>
   </meta>
   <result offset="0">
      <field k="http_url">
         <value h="1">
            <text>sample/1</text>
         </value>
      </field>
      <field k="count">
         <value>
            <text>1</text>
         </value>
      </field>
   </result>
   <result offset="1">
      <field k="http_url">
         <value h="1">
            <text>sample/2</text>
         </value>
      </field>
      <field k="count">
         <value>
            <text>1</text>
         </value>
      </field>
   </result>
   <result offset="2">
      <field k="http_url">
         <value h="1">
            <text>sample/3</text>
         </value>
      </field>
      <field k="count">
         <value>
            <text>1</text>
         </value>
      </field>
   </result>
   <result offset="3">
      <field k="http_url">
         <value h="1">
            <text>sample/4</text>
         </value>
      </field>
      <field k="count">
         <value>
            <text>1</text>
         </value>
      </field>
   </result>
   <result offset="4">
      <field k="http_url">
         <value h="1">
            <text>sample/5</text>
         </value>
      </field>
      <field k="count">
         <value>
            <text>1</text>
         </value>
      </field>
   </result>
</results>
"@

$xmlDoc.SelectNodes("//results/result[field[@k='http_url' or 'count']/value/text]") | ForEach-Object {
    [PSCustomObject]@{
        http_url = $_.SelectSingleNode("field[@k='http_url']/value/text")."#text"
        count = $_.SelectSingleNode("field[@k='count']/value/text")."#text"
    }
}

Awesome !! Thanks a Lot , its working as expected !! – Dhanz Jayakumar Dec 28 '20 at 01:23 — Dhanz Jayakumar, Dec 28 '20 at 01:23

score 0 · Answer 3 · edited Dec 27 '20 at 15:53

You can use the Get-Contet function to retrieve a file data to a string. Afterwards you can cast the string to an XML object via [xml]. Here is an example using a Microsoft XML example file:

> $xmlObject = [xml] (Get-Content .\books.xml)

Following command will list you all books:

> $xmlObject.catalog.book

id           : bk101
author       : Gambardella, Matthew
title        : XML Developer's Guide
genre        : Computer
price        : 44.95
publish_date : 2000-10-01
description  : An in-depth look at creating applications
                     with XML.

id           : bk102
author       : Ralls, Kim
title        : Midnight Rain
genre        : Fantasy
price        : 5.95
publish_date : 2000-12-16
description  : A former architect battles corporate zombies,
                     an evil sorceress, and her own childhood to become queen
                     of the world.

...

If you want to select certain properties you can use Select-Object:

> $xmlObject.catalog.book | Select-Object id, author

id    author
--    ------
bk101 Gambardella, Matthew
bk102 Ralls, Kim
bk103 Corets, Eva
bk104 Corets, Eva
bk105 Corets, Eva
bk106 Randall, Cynthia
bk107 Thurman, Paula
bk108 Knorr, Stefan
bk109 Kress, Peter
bk110 O'Brien, Tim
bk111 O'Brien, Tim
bk112 Galos, Mike

as suggested added my sample XML, please check and let me know — Dhanz Jayakumar, Dec 27 '20 at 15:54
`[xml] (Get-Content ...)` can mess up the encoding of the XML file, see https://stackoverflow.com/a/65264118/7571258 — zett42, Dec 27 '20 at 16:45

XML Parsing in Powershell - Specific value

3 Answers3