Parsing Invoke-Restmethod XML SOAP Request (Risport70 CUCM if that helps)

Question

I've run into a weird scenario when trying to pull real time info on phones. I can grab the data just fine and drill down into it but run into an issue I'm not sure how to work around.

Here's a sample XML response Cisco provides. After in powershell, I cant drill down further or search the nodes. It turns all the fields underneath into essentially one big string.

Heres my powershell code to invoke the rest-method

$RisBody = "
   
   
      
         
         
            1000
            Phone
            255
            Any
            
            Name
            
               
                  SEPABCDEF123456
               
            
            Any
            Any
         
      
   
"

$RisRequest = Invoke-RestMethod 'https://CUCM:8443/realtimeservice2/services/RISService70?wsdl' -Method 'POST' -Headers $headers -Body $RisBody

To drill down all the way to CMNodes, I use $RisInfo.Envelope.Body.selectCmDeviceResponse.selectCmDeviceReturn.SelectCmDeviceResult.cmnodes

Heres a look into the output I'm given (removed sensitive info for InnerXML and OuterXML but the values above in the cisco picture all smushed together and unreadable)

Name            : ns1:CmNodes
LocalName       : CmNodes
NamespaceURI    : http://schemas.cisco.com/ast/soap
Prefix          : ns1
NodeType        : Element
ParentNode      : SelectCmDeviceResult
OwnerDocument   : #document
IsEmpty         : False
Attributes      : {}
HasAttributes   : False
SchemaInfo      : System.Xml.XmlName
InnerXml        : Phone INFO
NextSibling     : 
PreviousSibling : TotalDevicesFound
Value           : 
ChildNodes      : {Cucm1, cucm2, cucm3, cucm4}
FirstChild      : item
LastChild       : item
HasChildNodes   : True
IsReadOnly      : False
OuterXml        : Phone INFO
BaseURI         : 
PreviousText    :

The results I want to look at our inner/outer xml but they are "strings" (via getType()) which makes it impossible to search via select node. Am I just going to have to parse it out the rough way?

I've tried using invoke-webrequest as well to see if it made any difference but got the same result. Also tried to convert inner/outerxml to [xml] but usually would fail or give me the same structure of string output. Seems like the RisPort70 just puts everything to strings after CMNodes.

Thank you!

Edit-Added .innerxml raw code for view.

    NotFoundIPAddress1falseOkIPAddress1falseSE
PDCC36115199A0435-Registered,0432-RegisteredPhone6835680Yes0trueRegistere
d020John Doe1662497967SIP20432Registered0432Registeredsip88xx.14-1-1-0001-125sip88xx.12-7-1-0001-393SuccessfulIPAddress7IPAddress6ipv4UnknownNotFoundIPAddress3falseNotFound
IPAddress4false<
/ns1:item>NotFoundIPAddress5trueNotFoundIPAddress8trueNotFound
IPAddress9falseNotFoundIPAddress10false

jdweng · Accepted Answer

Here is sample code using Xml Linq

using assembly System
using assembly System.Collections
using assembly System.Xml.Linq

$filename = "c:	emp	est.xml"
$doc = [System.Xml.Linq.XDocument]::Load($filename)
$table = [System.Collections.ArrayList]::new()

$CmNodes = $doc.Descendants().Where( {$_.Name.LocalName -eq "CmNodes"})[0]
$ns1 = $CmNodes.GetNamespaceOfPrefix("ns1")
foreach($item in $CmNodes.Elements($ns1 + "item"))
{
   $newRow = New-Object -TypeName psobject

   foreach($node in $item.Descendants())
   {
      $tagName = $node.Name.LocalName
      if(($node.Value.Length -gt 0) -and (-not $node.HasElements))
      {
         # do not add name if already exists
         if($newRow.$tagName -eq $null)
         {
            $newRow | Add-Member -NotePropertyName $tagName -NotePropertyValue $node.Value
         }
      }
   }

   $table.Add($newRow)  | Out-Null
}
$table | Format-List

Here is the xml I used


  
    
      
        
          1
          
            
              NotFound
              IPAddress1
              false
              
                
                  SEPDCC36115199A
                  0435-Registered,0432-Registered
                  Phone
                  683
                  568
                  0
                  Yes
                  0
                  true
                  
                  Registered
                  0
                  2
                  0
                  John Doe
                  
                    
                    
                    
                    
                    
                    
                    
                    
                    
                    
                  
                  1662497967
                  SIP
                  2
                  
                    
                      0432
                      Registered
                    
                    
                      0432
                      Registered
                    
                  
                  sip88xx.14-1-1-0001-125
                  sip88xx.12-7-1-0001-393
                  Successful
                  
                  IPAddress7
                  
                    
                      IPAddress6
                      ipv4
                      Unknown
                    
                  
                
              
            
            
              NotFound
              IPAddress3
              false
              
            
            
              NotFound
              IPAddress4
              false
              
            
            
              NotFound
              IPAddress5
              true
              
            
            
              NotFound
              IPAddress8
              true
              
            
            
              NotFound
              IPAddress9
              false
              
            
            
              NotFound
              IPAddress10
              false

Here is the results

ReturnCode           : NotFound
Name                 : IPAddress1
NoChange             : false
DirNumber            : 0435-Registered,0432-Registered
DeviceClass          : Phone
Model                : 683
Product              : 568
BoxProduct           : 0
Httpd                : Yes
RegistrationAttempts : 0
IsCtiControllable    : true
Status               : Registered
StatusReason         : 0
PerfMonObject        : 2
DChannel             : 0
Description          : John Doe
TimeStamp            : 1662497967
Protocol             : SIP
NumOfLines           : 2
DirectoryNumber      : 0432
ActiveLoadID         : sip88xx.14-1-1-0001-125
InactiveLoadID       : sip88xx.12-7-1-0001-393
DownloadStatus       : Successful
DownloadServer       : IPAddress7
IP                   : IPAddress6
IPAddrType           : ipv4
Attribute            : Unknown

ReturnCode : NotFound
Name       : IPAddress3
NoChange   : false

ReturnCode : NotFound
Name       : IPAddress4
NoChange   : false

ReturnCode : NotFound
Name       : IPAddress5
NoChange   : true

ReturnCode : NotFound
Name       : IPAddress8
NoChange   : true

ReturnCode : NotFound
Name       : IPAddress9
NoChange   : false

ReturnCode : NotFound
Name       : IPAddress10
NoChange   : false

Parsing Invoke-Restmethod XML SOAP Request (Risport70 CUCM if that helps)

Answers (1)

Related Questions