topic Re: How to get the directory and the contacts stored in CUCM using AXL API..? in Management

How to get the directory and the contacts stored in CUCM using AXL API..?

YouTee — Thu, 02 Apr 2020 10:42:41 GMT

Is there a way to get the directory using the AXL API..?

I have done the below steps:

In CUCM, go to Application->Plugins, then click Find and download the Cisco AXL Toolkit. Unzip it, and import the WSDL file into SoapUI.

I am unable to find any request method which can get me the directory. I tried to work with different versions on AXL (from 9.0 to 11.5) for executing a SQL query using the 'executeSQLQuery' method but it gives me the below error.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server</faultcode>
<faultstring>java.lang.NoClassDefFoundError: Could not initialize class com.cisco.www.axl.api._8_0.ExecuteSQLQueryDocument</faultstring>
<detail/>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

How can I overcome this error..?

Is there any specific method in AXL API which can help me in getting the CUCM directory..?

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

Anusha B R — Fri, 03 Apr 2020 12:09:59 GMT

Hi,

Are you talking about LDAP directory, if so, you can use getLdapDirectory AXL API, below is the schema reference for the same,

https://pubhub.devnetcloud.com/media/axl-schema-reference/docs/Files/AXLSoap_GetLdapDirectoryReq.html#Link449

Regards,

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

dstaudt — Fri, 03 Apr 2020 22:44:42 GMT

Can you provide some more details on what you mean by getting the directory? If you want to search the CUCM users, for example by name or to get a complete listing, see the AXL <listUser> request: https://developer.cisco.com/docs/axl-schema-reference/

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

thedd — Thu, 07 May 2020 07:44:40 GMT

What was the request you sent to CUCM?
Your Faulty Response does not give any hint to what you were trying to do

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

YouTee — Tue, 23 Jun 2020 14:38:48 GMT

Hi,

Thanks for your reply. It turned out to be an issue with my CUCM configuration.

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

YouTee — Tue, 23 Jun 2020 14:40:51 GMT

Hi Anusha,

Thanks for your reply. It turned out to be an issue with my CUCM configuration.

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

YouTee — Tue, 23 Jun 2020 14:41:14 GMT

Hi,

Thanks for your reply. It turned out to be an issue with my CUCM configuration.

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

Hazem Fouda — Thu, 12 Nov 2020 05:17:35 GMT

Hi,

I'm facing the same issue,

could you tell me what was the issue with your CUCM configuration ?

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

Anusha B R — Thu, 12 Nov 2020 11:03:54 GMT

Hey Hazem,

Are you trying to retrieve the users? Could you explain what you were trying and where you are hitting issue?

Thanks,
Anusha B R

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

Hazem Fouda — Thu, 12 Nov 2020 13:21:57 GMT

Hey Anusha,

I treing to do any axl request with java e.x ExecuteSQLQuery but I got this

exception:Client received SOAP Fault from server: java.lang.NoClassDefFoundError: Could not initialize class com.cisco.www.axl.api._8_0.ExecuteSQLQueryDocument Please see the server log to find more detail regarding exact cause of the failure.

and the trace looks like that:

2020-11-12 11:59:20,034 DEBUG [http-bio-1027-exec-8] servletRouters.AXLAlpha - Request processed by AXIS
2020-11-12 11:59:20,038 DEBUG [http-bio-1027-exec-8] servletRouters.AXLAlpha - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Server</faultcode><faultstring>java.lang.NoClassDefFoundError: Could not initialize class com.cisco.www.axl.api._8_0.AddRoutePartitionDocument</faultstring><detail /></soapenv:Fault></soapenv:Body></soapenv:Envelope>
2020-11-12 11:59:20,039 DEBUG [http-bio-1027-exec-8] servletRouters.AXLAlpha - Finished processing request
2020-11-12 11:59:20,039 INFO [http-bio-1027-exec-8] filters.TimingFilter - Request 1421170167997 received from AXL_User at ip 172.27.8.92 was processed in 32ms
2020-11-12 11:59:20,072 DEBUG [http-bio-81-exec-24] filters.TimingFilter - Received request 1421170167998 from AXL_User at IP 172.27.8.92
2020-11-12 11:59:20,072 DEBUG [http-bio-81-exec-24] wrappers.RequestHeaderWrapper - Inside Request Header Wrapper
2020-11-12 11:59:20,072 DEBUG [http-bio-81-exec-24] filters.AuthenticationFilter - Operation:executeSQLQuery api:executeSQLQuery
2020-11-12 11:59:20,073 DEBUG [http-bio-81-exec-24] filters.ThrottlingFilter - Successfully set the value of counter: 4 value: 0
2020-11-12 11:59:20,073 DEBUG [http-bio-81-exec-24] servletRouters.AXLAlpha - Checking request version [12.5]
2020-11-12 11:59:20,073 DEBUG [http-bio-81-exec-24] servletRouters.AXLAlpha - Checking if requested api [executeSQLQuery] the implementedHandlers list
2020-11-12 11:59:20,073 DEBUG [http-bio-81-exec-24] servletRouters.AXLAlpha - [executeSQLQuery] is not in the implementedHandlers list
2020-11-12 11:59:20,073 DEBUG [http-bio-81-exec-24] servletRouters.AXLAlpha - Checking if version is 8.x or 9.x
2020-11-12 11:59:20,073 DEBUG [http-bio-81-exec-24] servletRouters.AXLAlpha - function to check if the version is 8.x or 9.x
2020-11-12 11:59:20,073 DEBUG [http-bio-81-exec-24] servletRouters.AXLAlpha - version is not 8.x or 9.x
2020-11-12 11:59:20,073 INFO [http-bio-81-exec-24] servletRouters.AXLAlpha - Executing api: executeSQLQuery in axis
2020-11-12 11:59:20,073 DEBUG [http-bio-81-exec-24] wrappers.RequestNamespaceWrapper - Inside Request Wrapper
2020-11-12 11:59:20,074 DEBUG [http-bio-81-exec-24] servletRouters.AXLAlpha - AXL REQUEST :

<?xml version="1.0" ?><S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"><S:Body><ns2:executeSQLQuery xmlns:ns2="http://www.cisco.com/AXL/API/12.5"><sql>select count(Device.name) from Device inner join DevicePool on Device.fkDevicePool=DevicePool.pkid where DevicePool.name ='test_123__Tenant__DP1'</sql></ns2:executeSQLQuery></S:Body></S:Envelope>

I don't know what to do ?

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

Anusha B R — Tue, 17 Nov 2020 14:35:01 GMT

Hi Hazem,

It looks like java error. Did you had a chance to check this link https://community.cisco.com/t5/management/demo-java-error-for-cucm-10/td-p/3513343

Probably you would get some clue.

Regards,
Anusha B R

Re: How to get the directory and the contacts stored in CUCM using AXL API..?

dstaudt — Wed, 18 Nov 2020 00:37:09 GMT

Might take a look at <listUser>:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/10.5">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:listUser>
         <searchCriteria>
            <firstName>David</firstName>
            <lastName>%</lastName>
            <userid>%staudt%</userid>
            <department></department>
         </searchCriteria>
         <returnedTags>
            <userid/>
            <telephoneNumber/>
         </returnedTags>
      </ns:listUser>
   </soapenv:Body>
</soapenv:Envelope>
------------------------
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<ns:listUserResponse xmlns:ns="http://www.cisco.com/AXL/API/11.5">
<return>
<user uuid="{C83500BE-3606-A43A-F5E3-BAC93E6C3475}">
<userid>dstaudt</userid>
<telephoneNumber/>
</user>
<user uuid="{F0509AAF-BB47-D4C7-D56C-78CC3B114A72}">
<userid>dstaudt2</userid>
<telephoneNumber/>
</user>
<user uuid="{2A661528-0C7D-D820-A241-58965586B4CA}">
<userid>dstaudt4</userid>
<telephoneNumber/>
</user>
</return>
</ns:listUserResponse>
</soapenv:Body>
</soapenv:Envelope>

If you want to get further details, you can use <getUser> to retrieve individual user details.