question

Iain Jones avatar image
Iain Jones asked Iain Jones commented

VBA integration

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

integrations
1 |1500 characters needed characters left characters exceeded

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 Iain Jones commented

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

1 comment
1 |1500 characters needed characters left characters exceeded

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

Hi - We are thinking of building a middleware piece between Access and RingCentral - A console app (c#) to trigger the Access piece - would anyone suggest webhook to perform this action?

Thanks

0 Likes 0 ·

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