write info from outbound call on crm database

[sciaparro]

Hi,
few weeks ago I have correctly integrate 3cx with my crm database (mysql) and everything work well (if called number is on db, I could see directly on 3cx info about contact).
Now I'd like to improve this project: for outbound call, i want to write on db if someone answer ed the call time. I try to do this by cfd:
- user call internal app callflow
- user insert crm id
- cfd return the number and transfer the call
In this callflow, i'm not able to find a way for obtain info about the transfered call:
- answered, not answered
- call time
I'd like to receive this info to update crm db (writing for example that a lead has been called corretly).

Have you some ideas to obtain my desired result?

 

[edossantos]

Hello @sciaparro,

From the CFD app you don't have any feedback about the transfer result. But you can use the MySQL integration you have to log the call to this customer, including the result and duration. This will be logged as any other inbound or outbound call.

 

[sciaparro]

In mysql integration, I try to use call journaling with an Update query ... but nothing is happening. Do you mean something else with "log the call to this customer"?

 

[edossantos]

In mysql integration, I try to use call journaling with an Update query ... but nothing is happening. Do you mean something else with "log the call to this customer"?

No, that's what you need to do. Check your update statement manually to confirm that it's doing what you need. And ensure that this is being executed with the appropriate parameters, you can check the SQL query executed from the 3cxSystemService.log file in verbose mode.