VBA integration

Question

Hi - I am in need of some advice - We have an MS Access application with a SQL backend - on an inbound call to Ringcentral Office we want an access form to pop-up with the caller ID which has been passed - we have a CRM we have developed in SQL which we will query to present the user with the clients history. Any ideas which would be the most efficient method? as a side note we will be utilising the API to pause and resume automated call recording for PCI compliance on open and close of an Access form.

Hoping you can help

Iain

Phong1426275020 · Answer

You can access RingCentral platform via RESTful API. Unfortunately, we don't have SDK nor sample code for VBA. But if you are a VBA programmer, you should find it easy to implement code to access the platform. Here is a little help for you from a VBA developer who shared some code to authenticate and send SMS messages.

For your particular requirements, I recommend you go over the API references listed below to learn about the call control APIs which help you achieve your goals. But you have to convert the sample code to VBA yourself.

Start a call recording

Pause/resume a call recording

Get incoming call notification and detect the caller id

1. https://developers.ringcentral.com/api-reference/Subscriptions/createSubscription

2. https://developers.ringcentral.com/api-reference/Account-Telephony-Sessions-Event

Also for your reference, check out this article about the telephony session event notification.

Hope this helps