Freshdesk

Freshdesk is a cloud-hosted customer support software and helpdesk solution. It is a platform with a comprehensive set of tools and features to help businesses support all the needs of their customers. Companies around the world use it to deliver exceptional customer service and experience. They are able to streamline their processes and provide multi-channel support. The software also helps customer agents become more productive through automation and game mechanics.

How to Connect

There are two ways to connect to Freshdesk: 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 Freshdesk button in the list of connectors or type ‘freshdesk’ in the search field:

3. Enter the datasource name, your API Key, and your domain, and click Connect:

Usage 

The Freshdesk API connector introduces a new virtual schema freshdesk that contains the following stored procedures:

In addition to these public API procedures, there is the freshdesk_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 freshdesk_examples.