
RC2FM Help Docs
Last release was version: 1.1.1 (released 6/13/2017) and discontinued effective 5/31/2024.
Download our free, open-source, 100% FileMaker native code from our RC2FM v2 Git repository.
Version history: Refer to our Version History topic below in this same section of the Help.
Known Issues: Refer to the Support section of the Help.
RC2FM Connector is a web service for integrating FileMaker with RingCentral Office® – a best of breed VoIP Cloud PBX from RingCentral Inc. (NYSE:RNG). RC2FM Connector enables bolt-on FileMaker Cloud Telephony Integration (CTI) for all custom apps developed in FileMaker and running on iOS, Mac, Windows and the Web.
RC2FM Connector is an authorized RingCentral Public App designed to allow FileMaker custom apps to leverage most of the functionality of RingCentral's REST APIs using native FileMaker Scripts. Once configured and activated, this web service serves as middleware and enables the following features and functions of a RingCentral phone system extension:
• Click/Tap to dial any phone number stored in FileMaker. • Send outbound calls to your cell phone, personal phone, or RingCentral extension. • Send/receive SMS to/from any contact stored in FileMaker in near real time. • Send/receive MMS to/from any contact stored in FileMaker in near real time. • Send/receive Faxes directly from FileMaker containers or from your device's file system. • Download call log and message log history and store them as FileMaker records. • Download voicemails and store them as MP3's in FileMaker containers. • Download call recordings and store them as MP3's in FileMaker containers. • Download sent/received Faxes and store them as PDFs in FileMaker containers. • Set “Read” status of unread SMS, voicemails, and fax messages. • Trigger scripts in your FileMaker custom app on incoming calls (Pro/Advanced only).** RC2FM Connector pre-processes API responses to strip out extraneous information. We also provide a fully unlocked demo file complete with ready-made modular FileMaker Scripts and field-mapped data tables to make the process of working with JSON virtually unnecessary.
RC2FM Connector requires no locked connector files, no custom functions, no plugins, and works on locally stored custom apps as well as on apps hosted on FileMaker Server. Integration into a compatible FileMaker solution is as simple as 1-2-3:
1) Import all required tables with their associated records from our demo file; 2) Import (or copy/paste) all required scripts from our demo file; 3) Copy/paste the required layout objects from our demo file.
Once you have connected the table occurrences and the scripts, all that is left to do is modify a single configuration script. For more details, refer to the Getting Connected section of this documentation.
**Requires RingCentral Desktop app.
RC2FM Connector supports Claris FileMaker versions 13 and above running on iOS, macOS, Windows, and WebDirect.
Although RC2FM Connector can be made to work on FileMaker 12, we do not recommend or officially support it. Automation USA strongly recommends developers implement RC2FM Connector on the most current release of FileMaker or minimally on version 16.0.3.302 or higher.
RC2FM Connector supports all versions of FileMaker currently supported by Claris International. As Claris discontinues support for older releases of FileMaker, Automation USA will discontinue support for them as well.
• RingCentral Office Standard, Premium or Enterprise Edition
• NEW! Support for TELUS Business Connect and AT&T Office@Hand accounts
• FileMaker Pro, Go, WebDirect versions 16+ (iOS, Windows, Mac)
• Internet Explorer 11+ (Windows 8+)
• Firefox 46+ (Windows, Mac),
• Chrome 50+ (Windows, Mac)
• Safari 10.1+ (Mac), Safari 11+ preferred
New Open Source project: https://github.com/Automation-USA/RC2FM-v2-cURL
Last production version: 1.1.1 - released 6/13/2017 (Discontinued 5/31/2024). XML source code: https://github.com/Automation-USA/RC2FM/releases/tag/1.1.1
Support for cURL options in all API calls:
Updated all remaining API calls which were still passing parameters in the url with conditional branching to support cURL options. This completes FileMaker 16 compatibility for all RC2FM endpoints.
The nine (9) modifed scripts are: 1. 'RC2FM__Login' -- [calls "login.php" endpoint] 2. 'RC2FM__Logout' -- [calls "logout.php" endpoint)] 3. 'RC2FM__Check_Session_Status' -- [calls "get_token.php" endpoint] 4. 'RC2FM__Function__GetMessages_SUBMIT ( param )' -- [calls "msg.php" endpoint] 5. 'RC2FM__Function__GetCallLog_SUBMIT ( param )' -- [calls "calllog.php" endpoint] 6. 'RC2FM__Function__GetCallLogPro_SUBMIT ( param )' -- [calls "calllog_pro.php" endpoint] 7. 'RC2FM__Function__Fetch_Attachment ( param )' -- [calls "get_attachments.php" endpoint] 8. 'RC2FM__Function__Fetch_Recording' -- [calls "get_call_attachments.php" endpoint] 9. 'RC2FM__Update_ReadStatus' -- [calls "readstatus.php" endpoint]
Previous Version: 1.1.0 - released 6/6/2017 XML source code: https://github.com/Automation-USA/RC2FM/releases/tag/1.1.0
New MMS functionality:
Enhanced the "sms.php" API to support new MMS capabilities in RingCentral's REST APIs. For details on mms, refer to the "sms" documentation under the "API Reference Guide" topic, located in the "Protocols" section.
New Account-level call log reporting:
Released new "calllog_pro.php" API for account level call reporting (company wide call history). For details on account level call log, refer to the "calllog_pro" documentation under the "API Reference Guide" topic, located in the "Protocols" section.
New Message log search parameters:
Enhanced the "msg.php" API to support three (3) additional optional parameters to exclude undesired messages.
1. 'messageType' = filter messages by type (acceptable values are "SMS", "Fax" , "VoiceMail") 2. 'direction' = filter messages by direction (acceptable values are "Inbound", "Outbound") 3. 'readStatus' = filter messages by status (acceptable values are "Read", "Unread")
New AT&T Office@Hand compatibility: Effective May 31st 2017, RC2FM Connector has been approved and enabled to support subscribers of RingCentral Office@Hand from AT&T.
New FileMaker 16+ compatibility:
Most RC2FM API calls have been updated with conditional branching to support cURL options and the new Insert From URL script step options available in FileMaker 16+, while still retaining backwards compatibilty with versions 13 thru 15. Where appropriate, response targets have been changed from global fields to local or global variables.
Schema modifications: --------------------------------------- 'RC2FM_LOGS' table added two (2) new text fields in support of mms attachments: 1. 'attachmentType' 2. 'mmscount'
added one (1) number field in support of mms attachments: 1. 'size'
added one (1) calculation field in support of mms attachments: 1. 'sizeCalc'
modified one (1) calculation field to correct "php unserialize" function error: 1. 'sms_message' ---------------------------------------
'RC2FM_ATTACHMENTS' table added one (1) new calculation field: 1. 'binaryCalc' ---------------------------------------
RC2FM_GLOBALS' table added one (1) global container field in support of MMS functionality: 1. 'MMS_Utility_Container'
added three (3) non-essential global text fields in support of the demo file UI: 1. '_kftg_attachment_id' 2. '_kftg_chat_phone' 3. 'Email_To' ---------------------------------------
Previous Version: 1.0.3 - released 12/12/2016
XML source code: https://github.com/Automation-USA/RC2FM/releases/tag/1.0.3
Enhanced extension level call log reporting:
Introduced optional 'phone_number' parameter in RC2FM's 'calllog' API, allowing FileMaker to selectively request: - all call activity for the logged in user (including extension-to-extension calls) - selected call activity for any one of the user's possible secondary DID numbers - default call activity (calls to/from the user's default phone number only)
For details,on extension level call log, refer to the "calllog" documentation under the "API Reference Guide" topic, located in the "Protocols" section.
Schema and data parsing modifications:
In support of enhanced call log reporting, added two (2) new text fields ('toExtensionNumber' and 'fromExtensionNumber') to the 'RC2FM_LOGS' table and modified the "Parse Message/Call Logs" data operation to accept the additional values returned by the call log API reponse.
Performance tuning for server-side Data Operations:
Implemented a 1.1 second pause when executing recursive Remote Procedure Calls (looping Perform Script On Server script steps) to insert log records for large data sets.
When executing "Create Log records" data operations in hosted environments, a brief pause once every five (5) RPC calls has been implemented to allow the server time to process the queued payloads. This modification reduces RC2FM's potential impact on server performance when parsing and inserting payloads in excess of 2,240 records. --------------------------------------
Previous Version: 1.0 - released 6/15/2016 XML source code: https://github.com/Automation-USA/RC2FM/releases/tag/1.0.0 Initial release