You can connect to web services of popular sites like CallRail using the CallRail
connection type. To enable this connection, follow the given steps:
Click the Data Source
button in the configuration panel to add a new data connection.
Click CREATE NEW
to launch a new connection from the connection type panel.
Select the CallRail
connection button in the connection type panel.
The NEW DATA SOURCE
configuration window will open.
Enter an API in the URL text box, which must be a valid REST API.
Refer to the CallRail API documentation
Choose an appropriate method for the REST API; it can either be GET
or POST
in the type combo box.
Add header information by clicking ADD
, if required.
Choose an appropriate Refresh Setting
for the REST API; it can be any one of the time intervals shown in the combo box.
Please choose an appropriate Data Format
for the REST API; it can be either JSON
or CSV
in the type combo box.
Choose an appropriate authentication type for the REST API; it can be either Basic HTTP Authentication
or None
(No Authentication) in the type combo box.
Click the Preview & Connect
button in the NEW DATA SOURCE
configuration panel.
The Choose Schema(s)
window will open. You can select the schema and click Connect
.
Now, you can enter the data design view window with the selected table schema. Drag and drop the table.
Click the Save
button to save the data source with a valid name.