Query XML file for a value in Powershell

Question

Hi I am trying to query below Displayname in XML file using powershell

<DeploymentConfiguration PackageId="dce78f0d-d8d4-4a89-9f5d-c37fbf95ee7a" DisplayName="Beyond-Compare-3-3-8" IgnorableNamespaces="" xmlns="http://schemas.microsoft.com/appv/2010/deploymentconfiguration">

I did try

$Xml = Select-Xml -Path "C:\temp\Beyond-Compare-3-3-8_DeploymentConfig.xml"  -Namespace $Namespace -XPath "DisplayName="

I get error

Select-Xml : Cannot validate argument on parameter 'Namespace'. The argument is null or empty. Supply an argument that is not null or empty and then try the command again. At line:1 char:191 + ... l" -Namespace $Namespace -XPath "DisplayName=" + ~~~~~~~~~~ + CategoryInfo : InvalidData: (:) [Select-Xml], ParameterBindingValidationException + FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.PowerShell.Commands.SelectXmlCommand

The error means that your variable $Namespace is either null or empty — Paul
– Paul, Commented Oct 21, 2014 at 12:40
Sorry I was just editing post to include XML file I just need syntax to query what displayname value = and set to a variable — Zen
– Zen, Commented Oct 21, 2014 at 12:42

Paul · Accepted Answer · 2014-10-21 13:30:32Z

1

First of all, your xml is invalid since the node does not get closed. Here is a valid version:

<DeploymentConfiguration PackageId="dce78f0d-d8d4-4a89-9f5d-c37fbf95ee7a" DisplayName="Beyond-Compare-3-3-8" IgnorableNamespaces="" xmlns="http://schemas.microsoft.com/appv/2010/deploymentconfiguration"/>

Now in powershell:

[xml]$xml = Get-content c:\path\xmlFile.xml
$DisplayName= $xml.DeploymentConfiguration.Displayname

edited Oct 21, 2014 at 13:30

answered Oct 21, 2014 at 12:55

Paul

5,9412 gold badges27 silver badges42 bronze badges

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

1 Comment

Zen Over a year ago

100% Works, thank you so much for your time and help.

har07 · Accepted Answer · 2014-10-21 13:02:55Z

0

Using the same approach, you need to register prefix mapped to the default namespace URI, pass the mapping as -Namespace parameter, and use the registered prefix -ns in this example- in your XPath. The XPath expression you tried is also invalid :

$Namespace = @{ ns = 'http://schemas.microsoft.com/appv/2010/deploymentconfiguration'; };
$Xml = Select-Xml -Path "C:\temp\Beyond-Compare-3-3-8_DeploymentConfig.xml"  -Namespace $Namespace -XPath "//ns:DeploymentConfiguration/@DisplayName"

answered Oct 21, 2014 at 13:02

har07

89.5k12 gold badges87 silver badges143 bronze badges

Collectives™ on Stack Overflow

Query XML file for a value in Powershell

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related