Fetching data from XML in Powershell - Xpath usage

Question

I have a config XML , from which I am trying to read the information in Powershell script. The Powershell script takes input from user and then would need to navigate to each of the path. My configuration XML is as below:

<?xml version="1.0"?>
<Config>   
  <Action Name="Deploy">
            <CommandPath>path to navigate</CommandPath>
            <PackagePath>path of Application package</PackagePath>
        <ModelName>Name of model to be deployed</ModelName>
        <ServiceName>Name of Service</ServiceName>
            <DeploymentServer>
                <Server Name = 'Server1'></Server>
                <Server Name = 'Server2'></Server>
            </DeploymentServer>
  </Action>
  <Action Name="Update">
            <CommandPath>path to navigate</CommandPath>
            <PackagePath>path of Application package</PackagePath>
        <ModelName>Name of model to be updated</ModelName>
            <ServiceName>Name of Service</ServiceName>
            <DeploymentServer>
                <Server Name = 'Server1'></Server>                
            </DeploymentServer>
  </Action>     
</Config>

If the user inputs Deploy, the nodes under deploy need to be considered, if the user input is update, then the update path. The Powershell code should execute for each of the items under the DeploymentServer node for each of the action item. I have tried as below, but I am not able to get the correct node information in Powershell.

Set-ExecutionPolicy RemoteSigned

function RunConfiguration()
{
$XML = Select-Xml -Path $configFile -XPath 'Action' | Select-Object -ExpandProperty Node
do {
 $Answer = Read-Host -Prompt "Select required action ""$($XML.Action.Name -join '", "')"" "
} Until ($Answer -in ($XML.Action.Name))
Write-Host $XML.Action

$SelectedAnswer = $XML.Action | Where-Object {$_.Name -eq $UserOpt}
Write-Host $SelectedAnswer
$SelectedAnswer.DeploymentServer.Server | ForEach-Object {
    $ServerName = $_.Name
    Write-Host $ServerName
    Invoke-Command -ComputerName $ServerName -ScriptBlock {
        $Configuration = $args[0]   
        $Configuration.CommandPath
        $Configuration.PackagePath
        $Configuration.ModelName
        $Configuration.ServiceName
    } -ArgumentList $SelectedAnswer
   }
   }
}
}

$spAdminServiceName = "SPAdminV4"
$currentDir=(split-path $myinvocation.mycommand.path -parent)
$configFile = $currentDir
$configFile += "\DeployConfig.xml"
Execute-Commands $configFile

RunConfiguration()

Write-Host -f White "Press Enter key to exit..."
Read-Host

How to read the data? Thanks

Try changing -XPath 'Action' to -XPath '//Action' or -XPath './/Action' and see if it makes a difference. — Jack Fleeting
– Jack Fleeting, Commented Jul 13, 2020 at 13:51

Theo · Accepted Answer · 2020-07-13 13:59:24Z

1

Your XPath indeed needs //Action (see XPath Syntax), but most of all you need to be more consistent with the variable names.

At one point you capture the user input in variable $Answer, but next you use an undefined variable $UserOpt..

Try:

$configfile = 'D:\Test\config.xml'
# get an array of 'Action' XmlElements
$actionNodes = (Select-Xml -Path $configFile -XPath '//Action').Node

do {
    $Answer = Read-Host -Prompt "Select required action '$($actionNodes.Name -join "', '")'"
} Until ($Answer -in ($actionNodes.Name))

$selectedNode = $actionNodes | Where-Object {$_.Name -eq $Answer}
Write-Host $selectedNode.Name

$selectedNode.DeploymentServer.Server | ForEach-Object {
    $ServerName = $_.Name
    Write-Host $ServerName

    # do your Invoke-Command on the $ServerName here
}

answered Jul 13, 2020 at 13:59

Theo

61.9k8 gold badges28 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Fetching data from XML in Powershell - Xpath usage

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related