Fountain

Fountain offers a REST API that allows to programmatically manage the applicants. These API's can be used to automate tasks, trigger actions when changes occur, or synchronize external systems with Fountain. 

How to Connect

There are two ways to connect to Fountain: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Fountain button in the list of connectors or type ‘fountain’ in the search field and select it:

3. Click the button, change the data source name if needed, enter the API security token, and click 'Connect':

Usage 

The Fountain APIconnector introduces a new virtual schema fountain that contains the following stored procedures:

In addition to these public API procedures, there is the fountain_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping fountain_examples.