question

Mark Humphreys avatar image
Mark Humphreys asked Phong Vu answered

Data Extract Via API Step by Step

Hi There,

Do you have any step by step guides for using your API to extract call data for use within a Data Warehouse. I would like to extract data on a regular basis, probably using Azure Datafactory and then load into an on premise SQL Server.

Thanks

rest apianalytics and reporting
1 |3000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Phong Vu avatar image
Phong Vu answered

You can get started by reading this article. It would give you a big picture about how to access the call log data via API, parse the call metadata. It's up to you what you want to do with the data and how you want to store it.

Also this app and the source code is available in my Github repo. The app also allows a super admin to access the message store to export data. It processes and converts the data and save to a .csv file. You can convert it to a SQL data format and store in your database.

1 |3000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Developer sandbox tools

Using the RingCentral Phone for Desktop, you can dial or receive test calls, send and receive test SMS or Fax messages in your sandbox environment.

Download RingCentral Phone for Desktop:

Tip: switch to the "sandbox mode" before logging in the app:

  • On MacOS: press "fn + command + f2" keys
  • On Windows: press "Ctrl + F2" keys