cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
218
Views
0
Helpful
3
Replies
Beginner

SOAPUI AXL toolkit 11.5 showing calls made and received

Hi all,

I would like get the details from CUCM page using SOAPUI about a given persons call history using AXLtoolkit SOAP API 11.5 I would like to be able to retrieve calls made and received.

 

Can anyone please suggest or even better show an example of what request using the 11.5 toolkit I should use to load a given users call history. 

 

thank you in advance for any help, it is much appreciated. 

Everyone's tags (2)
3 REPLIES 3
Highlighted
Beginner

Re: SOAPUI AXL toolkit 11.5 showing calls made and received

I'm note sure if you can do that over the AXL API.

But you can do it with a SSH connection on your cucm server.

 

Example (on cucm terminal):

run sql car select callingpartynumber, lastredirectdn, destdevicename, datetimestampconnect, datetimestampdisconnect, datetimestamporigination, originalcalledpartypattern from tbl_billing_data where (lastredirectdn like '%PHONENUMBER' or callingpartynumber like '%PHONENUMBER') 

Gives you all ingoing / outgoing calls for a specific phone number. note that the CAR database only saves the call data for 3 months.

Beginner

Re: SOAPUI AXL toolkit 11.5 showing calls made and received

Thank you for the reply OSPMMeyer, could I do this via the toolkit using executeSQLQuery?

such as this:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/11.5"> 
  <soapnv:Header/>
  <soapnv:Body>
    <ns:executeSQLQuery>
      <sql>
        SELECT
                    callingpartynumber, 
                    lastredirectdn,
                    destdevicename,
                    datetimestampconnect,
                    datetimestampdisconnect,                                                                                                    
                    datetimestamporigination, 
                    originalcalledpartypattern
        FROM
                    tbl_billing_data
        WHERE
                    %PHONENUMBER
      </sql>
    </ns:executeSQLQuery>
  </soap:Body>
</soap:Envelope>

As i jsut tried above and could not get it to work in soapui, sorry i am restricted at the moment to SOAPUI

 

thank you for replies. 

Beginner

Re: SOAPUI AXL toolkit 11.5 showing calls made and received

Sorry for the shameless bump but can anyone help at all?

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards