SQL INTEGRATION - unanswered outgoing calls

[alexis41818544158]

Good morning everyone,

I have an installation that has CRM integration to MySQL active that I use to send data via api from the call log.

All calls are correctly sent to the database EXCEPT the unanswered outgoing calls. Why?

This is the query I use in the Call Journaling SQL Statement
INSERT INTO calls (calltype, contactnumber, calldirection, queueextension,agentextension, duration, calldatetime) VALUES (@CallType, @number, @CallDirection, @QueueExtension, @Agent, @Duration, DATE_FORMAT(@CallEstablishedTimeUTC, '%Y-%m-%dT%H:%i:%s%Z'))

How can I also send the unanswered outgoing calls?

Thanks

 

[edossantos_sipcaller]

You need to enable verbose logs, reproduce the issue, and then check the 3cxSystemService.log so you can understand why this is happening.

 

[alexis41818544158]

You need to enable verbose logs, reproduce the issue, and then check the 3cxSystemService.log so you can understand why this is happening.

MySqlConnector.MySqlException (0x80004005): Parameter '@CallEstablishedTimeUTC' must be defined.

The problem was on the use of this variable, rightly if the call is not established it does not have a start date.

I solved it using the variable @CallStartTimeUTC.

 

[edossantos_sipcaller]

You can use a different SQL query for established calls and not established calls. You will need a custom template, but doable.