.NET WSDL & AXL

Version 1
    This document was generated from CDN thread

    Created by: Peter Cresswell on 27-10-2009 01:27:35 PM
    Hi,

    I'm just starting to play with AXL and have followed (to the best of my understanding) the instructions to create the .Net helper class for Visual Studio.
     
    I'm trying to get a list of devices in a device pool, and perform an update on them. However I'm stuck on just finding the DevicePool in the first place! All of the other objects seem to have a GetXXX method, but there is no getDevicePool method in my helper class.

    Has the conversion not worked correctly or should DevicePools be queried in a different way?

    Thanks,

    Peter

    Subject: RE: .NET WSDL & AXL
    Replied by: Anitha V on 27-10-2009 02:07:14 PM
    hi Peter,
     
    Could you please let me know which callManager version are you using?
     
    Regards,
    Anitha

    Subject: RE: .NET WSDL & AXL
    Replied by: Peter Cresswell on 27-10-2009 02:08:08 PM
    Hi,

    I'm using 7.0,

    Thanks,

    Peter

    Subject: RE: .NET WSDL & AXL
    Replied by: David Staudt on 28-10-2009 05:17:13 AM
    While there may not be dedicated requests for retrieving device pools, you can usually accomplish just about any kind of data query via the AXL <executeSQLQuery> request.  This request allows you to submit a SQL query directly to the database (which is an Informix IDS.)  See the Data Dictionary document for details on the UCM tables and fields - I think you will want to look at the 'devicepool' table, and the 'device' table, specifically the 'fkdevicepool' field.  Something like:
     
    select name from device where fkdevicepool=[pkid_of_device_pool]
     
    You can get the list of device pools names and pkid's by:
     
    select pkid,name from devicepool

     
    Take care as this query could return a large number of rows on a system with many phones and impact call processing performance - AXL will fail any request that generates a response >8MB.  You may need to narrow the query into smaller 'chunks' of data, or as last result use SQL skip/first commands.
     
    One note, using .NET auto-generated WSDL code with <executeSQLQuery> will not work as-is, as the XML that can be returned can vary depending on the nature of the SQL statement.  You may need to use DOM or more basic XML parsing mechanisms to use the result (which is just fieldsXrows in XML format.)

    Subject: RE: .NET WSDL & AXL
    Replied by: Anitha V on 28-10-2009 04:24:45 AM
    Hi Peter,
     
    AXL doesn't support getting list of devices in a device pool and so we don't have any AXL request to get the list of devices in a device pool.
     
    Thanks and Regards,
    Anitha
     
     

    Subject: RE: .NET WSDL & AXL
    Replied by: Dan-Anders Hook on 28-10-2009 09:00:16 AM
    Hi Peter,
     
    Have You seen the AXL Interface Spec available on http://developer.cisco.com/web/axl/docs? There is both a listDevicePoolByName as well as a getDevicePool available, so it looks like there is something wrong with Your class. You will not be able to get a list of associated devices from them though, You will probably have better luck using SQL as David described to get that.
     
    Kind regards,
     
    //Dan

    Subject: RE: .NET WSDL & AXL
    Replied by: Peter Cresswell on 30-10-2009 10:25:19 AM
    Thanks very much for your help, I'll give that a go.

    Peter