topic Re: Generating lists via AXL (API/9.1) in Management

Generating lists via AXL (API/9.1)

Petr Kriz — Fri, 14 Feb 2014 16:18:47 GMT

Hello,
I try to have a few days to find, how I can read through AXL list of all devices (phones) and their associated lines. Can you please help?

System version: 9.1.2.10000-28

Used AXL WSDL version: http://www.cisco.com/AXL/API/9.1

The only method what I found on websites is through SQL, but I want use Cisco recommended action through AXL.

Note, if I run SQL like this (see below), I get devices what i want (but later I must find in next N sql queries lines etc.). I don't want to go through SQL queries, but I want to obtain lists of partition, CSS, PhoneTypes etc. through the AXL interface.

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

<soapenv:Header/>

<soapenv:Body>

<ns:executeSQLQuery sequence="?">

<sql>select d.name,d.description,dmap.numplanindex, n.dnorpattern

from device as d

inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid

inner join numplan as n on dmap.fknumplan = n.pkid</sql>

</ns:executeSQLQuery>

</soapenv:Body>

</soapenv:Envelope>

Thank you and best regards,

Peter

Re: Generating lists via AXL (API/9.1)

tinghche — Fri, 14 Feb 2014 20:23:40 GMT

Peter,

You can try using listPhone.

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

<soapenv:Header/>

<soapenv:Body>

<ns:listPhone sequence="?">

</searchCriteria>

<name/>

</returnedTags>

</ns:listPhone>

</soapenv:Body>

</soapenv:Envelope>

You can refer to listPhone API for more details

https://developer.cisco.com/media/axl-schema-10-0/AXLSoap_ListPhoneReq.html

Re: Generating lists via AXL (API/9.1)

Petr Kriz — Sun, 16 Feb 2014 17:38:14 GMT

Hello Chen,

I tried the method listPhone (and others listSomething methods), but it seems that these methods are not fully functional (or I am doing something explicitly wrong). I am running tests in application: SoapUI 4.6.4.

1. When I modify your code, it works fine (but I don't see CSS):

Input:

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

<soapenv:Header/>

<soapenv:Body>

<ns:listPhone sequence="?">

</searchCriteria>

<name/>

</returnedTags>

</ns:listPhone>

</soapenv:Body>

</soapenv:Envelope>

Output:

...

<model>Cisco 7965</model>

<phoneTemplateName uuid="{SOME-UUID}">Standard 7965 SCCP</phoneTemplateName>

</phone>

...

2. If I want see all methods what returns, I run generated code from WSDL - no success (I tried many combinations):

Input:

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

<soapenv:Header/>

<soapenv:Body>

<ns:listPhone sequence="?">

</searchCriteria>

</currentConfig>

</returnedTags>

</ns:listPhone>

</soapenv:Body>

</soapenv:Envelope>

Output (I always saw this output)

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<soapenv:Fault>

<faultcode>soapenv:Server</faultcode>

<faultstring>Invalid integer value: ?</faultstring>

<axlmessage>Invalid integer value: ?</axlmessage>

<request>listPhone</request>

</axlError>

</detail>

</soapenv:Fault>

</soapenv:Body>

</soapenv:Envelope>

Is there any way to find detail bugs why this happens? I tried set AXL Trace Logs (Cisco Unified Communications Manager XML Developers Guide, Release 9.1(1) - Administrative XML API [Cisco Unified Commun…) but I can't see any errors.

Thank you and best regards,

Peter

Re: Generating lists via AXL (API/9.1)

tinghche — Mon, 17 Feb 2014 18:05:18 GMT

Hi Peter,

Have you checked the CSS has indeed been assigned on this particular phone?

I ran it on my lab (10.0 using AXL 9.1) it appears to be working fine.

Howard

Re: Generating lists via AXL (API/9.1)

Petr Kriz — Wed, 19 Feb 2014 20:04:10 GMT

Hello Chen,

finnaly I found a probably error. If I removed lines (see strong text) all works fine.

</returnedTags>

<skip>?</skip>

<first>?</first>

</ns:listPhone>

Thank you and best regards,

Peter