Question

Exporting Call Log Data

  • 24 May 2016
  • 2 replies
  • 7046 views

I have successfully retrieved both simple and detailed call log records from API calls. However, I am interested in obtaining every call log to store in our database. This would allow us to limit the amount of needed calls to the Ring Central API and the data would be much more accessible.


I have already come to the conclusion that Ring Central does not provide any sort of Data Migration (To our sandbox for example) from this post https://devcommunity.ringcentral.com/ringcentraldev/topics/get-company-call-statistics-in-sandbox


Although the API returns data in a JSON format, does Ring Central provide any sort of data export (csv ...)?


I ask this because of the "perPage" limit on the call log request. This looks to be set to a maximum of 1000 even if passed a greater value. Can this limit be increased?


It is possible for us to write a script to call for these logs from the last several months and record the data from each call, so this is just a question, however if either of the options above are available it would greatly help speed up this process.


EDIT: Before this was answered I thought I would add another related question. When requesting call log data via the API I can only retrieve up to a certain date where as here https://service.ringcentral.com I am able to go back much further, is there a date/data limit to the call log request?


Thanks,

Connor


2 replies

There are a couple of ways you can get your Call Log data (keeping in mind RingCentral does not store call logs or recordings indefinitely).

1. Use the RingCentral Online Account Portal (https://service.ringcentral.com) as an admin, view your Call Log data, and download each page (concatenating the data into a single .csv). This is prone to human error and not a very "developer" way of doing things.

2. Using the RingCentral Connect Platform and Call Log resource of our API.

To help you along your way, I have created this demo application which downloads call logs from your account (when logged in as an admin-level user) and converts them to CSV format, then writes it to disk on your local machine.

This is just demo code, but it operates at a basic level, and you can expand as you like (add any issues, and Star/Fork/Watch the repository if you like it and would enjoy contributing to it):

https://github.com/bdeanindy/ringcentral-call-log-download-demo
I ask this because of the "perPage" limit on the call log request. This looks to be set to a maximum of 1000 even if passed a greater value. Can this limit be increased?
1000 is the max perPage setting. If there are more than 1000 records, you will be able to call the nextPage in a URL that's provided in the API response paging property.

An approach you can use to reduce the number of pages is to narrow the scope of your query. For example, if you have 1000 records per day, you can set dateFrom and dateTo to a 1 day range for the following using ISO 8601 dates:
  • dateFrom = 2016-07-01T00:00:00Z
  • dateTo = 2016-07-01T23:59:59Z
Then you can make a separate request per day. You can adjust this as fitting for your call volume and download use case.

Reply