CRM Integration - Incomplete Data from 3CX

[Kazui]

Hello,
I have a business that runs on PRN's. I've built a custom panel for tracking all call data that goes through my 3CX system. However there is a problem with data reporting. In the picture below, you can see that the integration between 3CX and my database only transfers the last part of the call flow.

This is a sample call (In 3CX call reports) that was not accepted. You can see that the call consists of 3 parts. The first IVR, then my operator and then the last IVR since 444 was on "Do not disturb".
View attachment 44905

However, in my custom call system I only see the last part of the call. The 802 IVR. This is the same for every single call- doesn't matter if the call was accepted or not. 3CX sends me only the last part of the call flow.


Another example of two calls that were accepted.
1. 3CX:
2. My system:


My integration:




Lookup By Number SQL Statement:

 

[Evolute IT]

The data is accurate. Only the last agent/extension is provided as agent, so in this case, the IVR.

 

[edossantos_sipcaller]

The current behavior is what you should expect. You will not get all the details from Call Journaling, because this is intended to report calls to agents, not all calls in the system. If you need to get all the data, you will need to use a different approach, for example reading the CDRs.