Axl response from listGateway uuid, cannot use for getGatewaySccpEndpoints (what about mgcp) or any gatGatewayEndpoint(Digital, T1,Pri,Bri) or Analog Axl calls, Item not valid

[Evanchik]

On the topic of AXL API endpoint

listGateway - provides you with all the gateway in all versions of cucm correctly, when I take the uuid, and then try to figure out its endpoints with getGatewaySccpEndpoints. (Fyi there is no getGatewayMgcpEndpoints, thats another question too), to then call the final AXL call getGatewayEndpointDigitalAccessT1 or getGatewayEndpointDigitalAccessPri or getGatewayEndpointDigitalAccessBri or getGatewayEndpointAnalogAccess. Every single AXL call I try (even on the latest CUCM 12.5) none of these calls accept the uuid or name, and return the error <axlmessage>Item not valid:

Doing some research this has been a problem for a while, in which the work around is to query the underlying database executeSqlQuery AXL call to the CUCM database, to get the CORRECT uuid. IS this hack , the only way to do this? Can somebody please who has knowledge of this, or in the department enlighten me as to what I am doing wrong, or how it should be done? Here is ALL I found on cisco forums

https://community.cisco.com/t5/management/finding-analog-endpoints-and-lines-associated-to-a-vg-gateway/td-p/3570238

[Evanchik]

update:   I even checked on 12.5, and no endpoint uuid is given and must use manual sql axl to propagate for data.

why does 

1)

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/12.5">
<soapenv:Header></soapenv:Header>
<soapenv:Body>
<ns:executeSQLQuery sequence="0">
<sql>select fkdevice as uuid from mgcpdevicemember where fkmgcp={uuid_from_listGateway}</sql>
</ns:executeSQLQuery>
</soapenv:Body>
</soapenv:Envelope>

when getting the response from getSccpEndpoints, I add a Bri endpoint (phone) but no data returns from getDigitalEndpointAccessBri, only getDigitalEndpoingAccessT1 and getDigitalEndpointAnalog access for a Cisco 3945 - Sccp?  Basically what im saying based on the response from getSccpEndpoints, there is no identifier for me to know the next Axl call to make, right now it only makes sense to call all of them, in which two basically have the same data T1 and Analog endpoints

[matt4923]

I've had this same problem.  I've never been able to get those gateway endpoint calls to work.  I've only been able to get what I've needed through the 'hack' you mentioned, building custom queries and using the executeSQLQuery call.