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.
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.
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.