frevvo was designed to integrate with your back-end systems. The form server is built using industry-standard such as XSD, XML and Restlet. This chapter covers the built-in connectors as well as how to add your own connectors to the form server.
Integrating Connectors with frevvo Cloud Server
Connectors are most commonly installed behind your firewall where they can access (connect) to your back-end systems in order to read/write data. If you use the frevvo Cloud hosted server you must ensure that your Connectors are accessible from our servers. This is done by opening up one of the following ports on your firewall:
We recommend that you use HTTPS and not HTTP. HTTPS is a secure channel.
- HTTP Ports: 80, 8082 or 19080
- HTTPs Ports: 443, 8443 or 19443
For customers that use firewall white-listing, also make sure the frevvo cloud outgoing server IP Addresses 18.104.22.168 and 22.214.171.124 (host outgoing.frevvo.com) are added to the list.
The Database Connector makes it very easy to connect frevvo to most databases. You can save form submissions in your database or initialize forms from a database. Note that this connector uses XML schema.
See Database Connector for help installing and using this connector.
The Filesystem Connector saves frevvo submissions to a local or remote filesystem or an Enterprise Content Management system (ECM). See Filesystem Connector for easy installation and configuration information.
Connecting your frevvo to Google sheets and drive is very easy to do with the frevvo Google Connector. See the Google Connector chapter for help installing and using this connector.
Store documents and information to a secure Microsoft SharePoint website. Configure the frevvo SharePoint Connector for your frevvo tenant then use the SharePoint wizard to connect your forms/workflows to the SharePoint website for document storage. Refer to the SharePoint Connector topic for the details.
Connect your frevvo forms/workflows to Docuware. Visit the Docuware Connector chapter for help configuring and using this connector.
DocuShare Flex Connector
Connect your frevvo forms/workflows to DocuShare Flex. Visit the DocuShare Flex Connector chapter for help configuring and using this connector.
frevvo connectors installed on-premise should only be accessible to the frevvo server and should not be remotely accessible. frevvo recommends only allowing HTTPS access to the server (not external HTTP access). Since the connector(s) is not exposed over HTTPS, remote code execution vulnerability can be mitigated (a remote attacker cannot exploit this vulnerability as it is not exposed).
If you choose to allow external access to HTTP, you should only allow requests with paths starting with /frevvo for port 8082 (or the port you are using for frevvo and the Connector(s)).
See also Database Connector Security.
Templatized Strings for Integration
When using the Document Action: Send Documents feature for data integration with an external system, you may use templatized strings to send control values. The templatized string will send the value in ISO-format, which is a common standard for integration. This is most important for date and datetime controls, which will resolve to a user's locale format, or the format set in the designer, for any display use but will always resolve to ISO-format for Doc Action integrations. (This does not apply to Form/Workflow Actions, Doc URIs or email.)
If you need to send control values in a non-ISO format, you should add a hidden text control to your form. Add a business rule that sets the hidden text control to the date control value in the desired format. Then, use the template for the hidden text control in your integration.
Moving Forms/Workflows that use Connectors
If you move a form/workflow that is configured to use a Connector in a Doc Action to a tenant that is not set up with that connector, you will see the form/workflow in the list with a salmon background and an error icon. Clicking the error icon will show the error detail message "Missing Connector. Edit to view details."
When you edit the form/workflow, the Settings icon will show a red exclamation point, and the Document Actions tab will appear in red text indicating the location of the error. For example, this could occur if you designed a form in a tenant configured with the Docuware Connector, then download it and upload to a different tenant that does not have the Docuware Connector configured. Coordinate with your tenant admin to configure the appropriate connector.