Extract call logs via SQL query or API

[fabio.abbiati]

Dear All,
I need to extract all the call logs (outgoing, incoming, losed, ...) from my 3CX.
I have already read from other threads that it's not allowed to access to 3CX database.
There are other ways to get the information I need?

I need to create a custom report with Power Bi and for the other reports I read data from an out datawarehouse (extract informations from different system and save there).
Maybe there are API features that allow me to extract all the call logs or a standard feature that allow me to schedule a file export or maybe create a database copy which can be accessed, ...

Thanks in advance for any suggestion,
Fabio

 

[edossantos]

The proper way to do this is by checking the CDRs generated by 3CX:
https://www.3cx.com/docs/cdr-call-data-records/

 

[VoIPTools]

As @edossantos mentioned, the only supported ways of getting call history information are (1) CDR data (Settings --> CDR) or (2) generating reports, exporting the report data to CSV, and importing the data into SQL. Both of these approaches are labor intensive.

If the CDR data contains the information you need, then that's the direction I would recommend. If you need data that is not available via CDR, then we can help with our REST API, and our 3CX Exporter tools. Exporter can automatically parse the CDR files 3CX generates and put the data into a SQL / MySQL database. If you need additional data including queue statistics for example, Exporter can leverage our API to automatically replicate the 3CX data into SQL. Exporter, by default, runs every 60 seconds to ensure your database is always up-to-date.

If you need real-time data, we also provide an "Events" API where you can subscribe to all 3CX events in real-time. I will say, however, that interpreting the events is complicated and will take some effort to understand.