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.

Need help with something?

Talk to data expert

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.
 
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.
 
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.
 
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.
 
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.
 
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.
 
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

Table of Contents