Snapshot

Pre-requisites

1. Generate Freshdesk API Key for Daton

2. Read more on Where to find Freshdesk API Keys

Integrate FreshDesk with Daton

1. Signin to Daton

2. Select FreshDesk from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide FreshDesk Subdomain and API Key to authorize Daton to periodically extract data from FreshDesk

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

FreshDesk Data

Agents

Purpose: Gives the list of all “full-time” and “occasional” agents in organization.

Replication: Full Replication

Replication Key: NA

Fields

Roles

Purpose: Gives the list of all the various roles created in the organization.

Replication: Full Replication

Replication Key: NA

Fields

Groups

Purpose: Groups table contains all the details about various groups present.

Replication: Full Replication

Replication Key: NA

Fields

Companies

Purpose: Companies table consists of details about various companies in contact with you.

Replication: Full Replication

Replication Key: NA

Fields

Contacts

Purpose: Groups table contains all the details about various groups present.

Replication: Key-Based Replication

Replication Key: updated_since

Fields

Tickets

Purpose: This table contains details about various tickets raised.

Replication: Key-Based Replication

Replication Key: updated_since

Fields