AXL - CUCM10.5 - Can't execute SQLQuerry

[Enric92]

Hello,

I try to querry the AXL but i receive a SoapEnv: Fault

Send:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

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

    <SOAP-ENV:Body>

        <executeSQLQuery sequence="1416839392254">

            <sql>select pkid, name from devicepool</sql>

        </executeSQLQuery>

    </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

Response:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

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

    <soapenv:Body>

        <soapenv:Fault>

            <faultcode>soapenv:Server</faultcode>

            <faultstring>error: The document is not a executeSQLQuery@http://www.cisco.com/AXL/API/8.5: document element namespace mismatch expected &quot;http://www.cisco.com/AXL/API/8.5" got &quot;&quot;</faultstring>

            <detail/>

        </soapenv:Fault>

    </soapenv:Body>

</soapenv:Envelope>

Something seems wrong?

Thanks !

[dstaudt · Accepted solution]

I believe the way the namespace is declared, as 'ns', that the request element name should be 'ns:executeSQLQuery'

<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:executeSQLQuery sequence="?">

         <sql>?</sql>

      </ns:executeSQLQuery>

   </soapenv:Body>

</soapenv:Envelope>

[Enric92]

That's right, it's working,

Thanks a lot!