Schema Information of Freshdesk Connector
This topic provides a structured reference to assist you in working with Daton's Freshdesk connector and the associated fields and tables.
Schema Information of Freshdesk Connector
This topic provides a structured reference to assist you in working with Daton's Freshdesk connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Freshdesk connector:
- Agents
- Roles
- Groups
- Companies
- Contacts
- Tickets
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 |
