Freshdesk

Freshdesk ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

v2

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

FreshDesk Subdomain API Key

Replication Type

Full Replication Key Based Replication

Replication Key

Date

Suggested Replication Frequency

24 hrs

Tables/APIs Supported

Agents

Roles

Groups

Companies

Contacts

Tickets

Pre-requisites

  1. Generate Freshdesk API Key for Daton

  2. Read more on Where to find Freshdesk API Keys here

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.

Source API Documentation https://developers.freshdesk.com/api/#list_all_agents

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

available

BOOLEAN

occasional

BOOLEAN

id

NUMERIC

signature

STRING

ticket_scope

NUMERIC

created_at

STRING

updated_at

STRING

available_since

STRING

type

STRING

contact

RECORD

Roles

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

Source API Documentation https://developers.freshdesk.com/api/#list_all_roles

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

id

NUMERIC

name

STRING

description

STRING

default

BOOLEAN

created_at

STRING

updated_at

STRING

Groups

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

Source API Documentation https://developers.freshdesk.com/api/#list_all_groups

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

id

NUMERIC

name

STRING

description

STRING

escalate_to

STRING

unassigned_for

STRING

business_hour_id

STRING

group_type

STRING

created_at

STRING

updated_at

STRING

auto_ticket_assign

BOOLEAN

Companies

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

Source API Documentation https://developers.freshdesk.com/api/#list_all_companies

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

id

NUMERIC

name

STRING

description

STRING

note

STRING

domains

STRING

created_at

STRING

updated_at

STRING

custom_fields

RECORD

health_score

STRING

account_tier

STRING

renewal_date

STRING

industry

STRING

Contacts

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

Source API Documentation https://developers.freshdesk.com/api/#list_all_contacts

Replication: Key-Based Replication

Replication Key: updated_since

Fields

Name

Target Datatype

active

BOOLEAN

address

STRING

company_id

STRING

description

STRING

email

STRING

id

NUMERIC

job_title

STRING

language

STRING

mobile

STRING

name

STRING

phone

STRING

time_zone

STRING

twitter_id

STRING

custom_fields

RECORD

facebook_id

STRING

created_at

STRING

updated_at

STRING

unique_external_id

STRING

Tickets

Purpose: This table contains details about various tickets raised.

Source API Documentation https://developers.freshdesk.com/api/#list_all_tickets

Replication: Key-Based Replication

Replication Key: updated_since

Fields

Name

Target Datatype

cc_emails

STRING

fwd_emails

STRING

reply_cc_emails

STRING

fr_escalated

BOOLEAN

spam

BOOLEAN

email_config_id

STRING

group_id

STRING

priority

NUMERIC

requester_id

NUMERIC

responder_id

NUMERIC

source

NUMERIC

company_id

STRING

status

NUMERIC

subject

STRING

association_type

STRING

to_emails

STRING

product_id

STRING

id

NUMERIC

type

STRING

due_by

STRING

fr_due_by

STRING

is_escalated

BOOLEAN

custom_fields

RECORD

created_at

STRING

updated_at

STRING

associated_tickets_count

STRING

tags

STRING