Skip to main content
New Participant
May 29, 2018
Question

Connecting API to Report page

I'm creating a basic API to pull our call logs to a csv. Easy enough except I'm trying to match the format. Right now the call log API extracts all the data exactly as it comes into the 'Call Log' page.


The issue is that our manual process was copying from the 'Call Detail' tab on the Reports page. I can go through the call log json and format everything so that the exported csv is pretty close to the format my only concern there is the logic for the "legs" to produce the same accurate output for the "Users" and "Queue Name" as the Reports page does.


Is there a way to just connect the API directly to the Reports page rather than the call log and formatting the data?


If not how do I set up the Reporting in my sandbox so that I can confirm my output vs the Report page.

2 replies

The First Step
May 29, 2018
Have you tried scheduling these reports to be emailed as a csv instead of using the API to build this function? Depending on the plan you are subscribed to you should have this option. This is a much easier way and you can generate reports by extensions and email them to any email address. 
PhongVu
Community Manager
Community Manager
May 29, 2018
Hi Kevin,

Just to confirm with you that there is no API to access the report page as you wish. However, with the call-log API, you can access the same call log dataset and can convert the JSON response to CSV format similar to the one you can download from the service web.

If you extract the format of your current report and let me know which fields you want to add into your db, I can help you write some sample code to convert the JSON response into CSV the way you want.

+ Phong