VB code - issue with returned data from AXL/SOAP listLine

[John Watkins]

Hello, and thank you for looking at this!

I have the following code I'm executing against CUCM 11.5.1 AXL SOAP. I get the Reponse as  <line uuid="{0395BCFF-18F9-00FE-0015-C037F977F08A}"><description>John Watkins (Jrwatkins)</description><routePartitionName uuid="{313DD3B9-CA80-4793-9D9F-F606D1A5F0E9}">INTERNAL-PT</routePartitionName></line>. However, I never get the Associated Devices.....

----Code Snippit-----

Function ListLine(strName As String) As String

        Dim strPostData As String

        Dim strPostReturn As String

        strPostData = strSOAPHeader & "<ns:listLine sequence=""?"">

         <searchCriteria>

             <pattern>" & strName & "</pattern>

            <routePartitionName>INTERNAL-PT</routePartitionName>

         </searchCriteria>

         <returnedTags ctii=""?"" uuid=""?"">

              <associatedDevices>

                <device></device>

             </associatedDevices>

              <routePartitionName uuid=""?""/>

             <description/>

             </returnedTags>

      </ns:listLine>" & strSOAPFooter

        strPostReturn = GetDataFromURL(strUCMAXLURL, "POST", strPostData, strUCMbase64creds)

        Return strPostReturn

    End Function

/----Code Snippit-----

----Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/11.0">

                                      <soapenv:Header/>

                                      <soapenv:Body><ns:listLine sequence="?">

         <searchCriteria>

             <pattern>%12065551000</pattern>

            <routePartitionName>INTERNAL-PT</routePartitionName>

         </searchCriteria>

         <returnedTags ctii="?" uuid="?">

              <associatedDevices>

                <device></device>

             </associatedDevices>

              <routePartitionName uuid="?"/>

             <description/>

             </returnedTags>

      </ns:listLine>   </soapenv:Body>

</soapenv:Envelope>

/---EndRequest

----Response

<line uuid="{0395BCFF-18F9-00FE-0015-C037F977F08A}"><description>John Watkins (Jrwatkins)</description><routePartitionName uuid="{313DD3B9-CA80-4793-9D9F-F606D1A5F0E9}">INTERNAL-PT</routePartitionName></line>

/----Response

[dstaudt]

I can confirm this behaviour on my 10.5 and 11.5 systems, and have opened defect CSCvc79941 for tracking.  As a workaround, it should be possible to use <executeSqlQuery> to retrieve device->line association information, for example:

<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <ns:executeSQLQuery xmlns:ns="http://www.cisco.com/AXL/API/11.5">
      <sql xsi:type="xsd:string">select device.name from device, devicenumplanmap, numplan
        where device.pkid = devicenumplanmap.fkdevice and numplan.pkid = devicenumplanmap.fknumplan
        and numplan.dnorpattern = "1000"</sql>
    </ns:executeSQLQuery>
  </soap:Body>
</soap:Envelope>