Freshdesk

Prerequisites

To set up the Freshdesk source connector, you'll need the Freshdesk domain URL and the API key.

Tables in the Freshdesk connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	business_hours	8		Full Refresh
2	solution_folders	9		Full Refresh
3	scenario_automations	7		Full Refresh
4	discussion_categories	5		Full Refresh
5	tickets	34		Full Refresh, Incremental	updated_at	API Reference
6	roles	6		Full Refresh		API Reference
7	surveys	6		Full Refresh		API Reference
8	conversations	18		Full Refresh		API Reference
9	products	5				API Reference
10	ticket_fields	21		Full Refresh
11	skills	8				API Reference
12	companies	12		Full Refresh		API Reference
13	solution_articles	15		Full Refresh
14	discussion_comments	11		Full Refresh
15	sla_policies	9		Full Refresh
16	time_entries	12		Full Refresh
17	settings	3		Full Refresh		API Reference
18	discussion_forums	10		Full Refresh
19	groups	10		Full Refresh		API Reference
20	canned_responses	8		Full Refresh
21	satisfaction_ratings	10		Full Refresh
22	solution_categories	6		Full Refresh
23	agents	11		Full Refresh		API Reference
24	discussion_topics	15		Full Refresh
25	email_configs	10		Full Refresh
26	email_mailboxes	17		Full Refresh
27	canned_response_folders	6		Full Refresh
28	contacts	20		Full Refresh, Incremental	updated_at	API Reference

Table: business_hours

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	working_hours	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	created_at	VARCHAR
6	id	INTEGER
7	is_default	BOOLEAN
8	time_zone	VARCHAR

Table: solution_folders

No	Column Name	Type	Notes
1	company_ids	VARCHAR
2	visibility	INTEGER
3	updated_at	VARCHAR
4	company_segment_ids	VARCHAR
5	name	VARCHAR
6	description	VARCHAR
7	created_at	VARCHAR
8	id	INTEGER
9	contact_segment_ids	VARCHAR

Table: scenario_automations

No	Column Name	Type	Notes
1	private	BOOLEAN
2	updated_at	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	created_at	VARCHAR
6	id	INTEGER
7	actions	VARCHAR

Table: discussion_categories

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	name	VARCHAR
3	description	VARCHAR
4	created_at	VARCHAR
5	id	INTEGER

Table: tickets

No	Column Name	Type	Notes
1	to_emails	VARCHAR
2	responder_id	INTEGER
3	subject	VARCHAR
4	due_by	VARCHAR
5	fr_escalated	BOOLEAN
6	created_at	VARCHAR
7	description	VARCHAR
8	source	INTEGER
9	association_type	INTEGER
10	type	VARCHAR
11	cc_emails	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	stats	VARCHAR
14	reply_cc_emails	VARCHAR
15	product_id	INTEGER
16	id	INTEGER
17	fwd_emails	VARCHAR
18	associated_tickets_count	INTEGER
19	email_config_id	INTEGER
20	requester	VARCHAR
21	company_id	INTEGER
22	custom_fields	VARCHAR
23	description_text	VARCHAR
24	fr_due_by	VARCHAR
25	priority	INTEGER
26	tags	VARCHAR
27	is_escalated	BOOLEAN
28	nr_escalated	BOOLEAN
29	group_id	INTEGER
30	ticket_cc_emails	VARCHAR
31	spam	BOOLEAN
32	requester_id	INTEGER
33	status	INTEGER
34	nr_due_by	VARCHAR

Table: roles

No	Column Name	Type	Notes
1	default	BOOLEAN
2	updated_at	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	created_at	VARCHAR
6	id	INTEGER

Table: surveys

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	questions	VARCHAR
3	active	BOOLEAN
4	created_at	VARCHAR
5	id	INTEGER
6	title	VARCHAR

Table: conversations

No	Column Name	Type	Notes
1	to_emails	VARCHAR
2	incoming	BOOLEAN
3	private	BOOLEAN
4	from_email	VARCHAR
5	attachments	VARCHAR
6	body_text	VARCHAR
7	created_at	VARCHAR
8	source	INTEGER
9	bcc_emails	VARCHAR
10	body	VARCHAR
11	ticket_id	INTEGER
12	support_email	VARCHAR
13	cc_emails	VARCHAR
14	updated_at	VARCHAR
15	user_id	INTEGER
16	id	INTEGER
17	category	INTEGER
18	source_additional_info	VARCHAR

Table: products

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	name	VARCHAR
3	description	VARCHAR
4	created_at	VARCHAR
5	id	INTEGER

Table: ticket_fields

No	Column Name	Type	Notes
1	is_fsm	BOOLEAN
2	portal_cc	BOOLEAN
3	label_for_customers	VARCHAR
4	description	VARCHAR
5	created_at	VARCHAR
6	label	VARCHAR
7	type	VARCHAR
8	portal_cc_to	VARCHAR
9	default	BOOLEAN
10	displayed_to_customers	BOOLEAN
11	required_for_agents	BOOLEAN
12	updated_at	VARCHAR
13	dependent_fields	VARCHAR
14	customers_can_edit	BOOLEAN
15	field_update_in_progress	BOOLEAN
16	name	VARCHAR
17	required_for_closure	BOOLEAN
18	id	INTEGER
19	position	INTEGER
20	choices	VARCHAR
21	required_for_customers	BOOLEAN

Table: skills

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	name	VARCHAR
3	rank	INTEGER
4	created_at	VARCHAR
5	match_type	VARCHAR
6	id	INTEGER
7	conditions	VARCHAR
8	agents	VARCHAR

Table: companies

No	Column Name	Type	Notes
1	note	VARCHAR
2	updated_at	VARCHAR
3	renewal_date	VARCHAR
4	custom_fields	VARCHAR
5	health_score	VARCHAR
6	name	VARCHAR
7	description	VARCHAR
8	domains	VARCHAR
9	created_at	VARCHAR
10	account_tier	VARCHAR
11	industry	VARCHAR
12	id	INTEGER

Table: solution_articles

No	Column Name	Type	Notes
1	thumbs_down	INTEGER
2	agent_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	description_text	VARCHAR
6	title	VARCHAR
7	thumbs_up	INTEGER
8	tags	VARCHAR
9	hits	INTEGER
10	category_id	INTEGER
11	updated_at	VARCHAR
12	id	INTEGER
13	folder_id	INTEGER
14	seo_data	VARCHAR
15	status	INTEGER

Table: discussion_comments

No	Column Name	Type	Notes
1	answer	BOOLEAN
2	updated_at	VARCHAR
3	user_id	INTEGER
4	created_at	VARCHAR
5	id	INTEGER
6	published	BOOLEAN
7	topic_id	INTEGER
8	body	VARCHAR
9	spam	BOOLEAN
10	forum_id	INTEGER
11	trash	BOOLEAN

Table: sla_policies

No	Column Name	Type	Notes
1	sla_target	VARCHAR
2	escalation	VARCHAR
3	name	VARCHAR
4	active	BOOLEAN
5	description	VARCHAR
6	id	INTEGER
7	position	INTEGER
8	is_default	BOOLEAN
9	applicable_to	VARCHAR

Table: time_entries

No	Column Name	Type	Notes
1	note	VARCHAR
2	start_time	VARCHAR
3	agent_id	INTEGER
4	company_id	INTEGER
5	updated_at	VARCHAR
6	executed_at	VARCHAR
7	timer_running	BOOLEAN
8	created_at	VARCHAR
9	id	INTEGER
10	ticket_id	INTEGER
11	billable	BOOLEAN
12	time_spent	VARCHAR

Table: settings

No	Column Name	Type	Notes
1	supported_languages	VARCHAR
2	primary_language	VARCHAR
3	portal_languages	VARCHAR

Table: discussion_forums

No	Column Name	Type	Notes
1	forum_category_id	INTEGER
2	company_ids	VARCHAR
3	topics_count	INTEGER
4	forum_type	INTEGER
5	name	VARCHAR
6	description	VARCHAR
7	id	INTEGER
8	position	INTEGER
9	forum_visibility	INTEGER
10	posts_count	INTEGER

Table: groups

No	Column Name	Type	Notes
1	escalate_to	INTEGER
2	unassigned_for	VARCHAR
3	updated_at	VARCHAR
4	business_hour_id	INTEGER
5	name	VARCHAR
6	auto_ticket_assign	INTEGER
7	description	VARCHAR
8	created_at	VARCHAR
9	id	INTEGER
10	group_type	VARCHAR

Table: canned_responses

No	Column Name	Type	Notes
1	attachments	VARCHAR
2	updated_at	VARCHAR
3	created_at	VARCHAR
4	id	INTEGER
5	title	VARCHAR
6	folder_id	INTEGER
7	content	VARCHAR
8	content_html	VARCHAR

Table: satisfaction_ratings

No	Column Name	Type	Notes
1	feedback	VARCHAR
2	survey_id	INTEGER
3	agent_id	INTEGER
4	updated_at	VARCHAR
5	user_id	INTEGER
6	group_id	INTEGER
7	ratings	VARCHAR
8	created_at	VARCHAR
9	id	INTEGER
10	ticket_id	INTEGER

Table: solution_categories

No	Column Name	Type	Notes
1	visible_in_portals	VARCHAR
2	updated_at	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	created_at	VARCHAR
6	id	INTEGER

Table: agents

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	signature	VARCHAR
3	last_active_at	VARCHAR
4	ticket_scope	INTEGER
5	contact	VARCHAR
6	available	BOOLEAN
7	created_at	VARCHAR
8	occasional	BOOLEAN
9	id	INTEGER
10	available_since	VARCHAR
11	type	VARCHAR

Table: discussion_topics

No	Column Name	Type	Notes
1	created_at	VARCHAR
2	message	VARCHAR
3	title	VARCHAR
4	forum_id	INTEGER
5	user_votes	INTEGER
6	hits	INTEGER
7	updated_at	VARCHAR
8	user_id	INTEGER
9	sticky	BOOLEAN
10	id	INTEGER
11	locked	BOOLEAN
12	merged_topic_id	INTEGER
13	replied_by	INTEGER
14	posts_count	INTEGER
15	stamp_type	INTEGER

Table: email_configs

No	Column Name	Type	Notes
1	to_email	VARCHAR
2	updated_at	VARCHAR
3	group_id	INTEGER
4	primary_role	BOOLEAN
5	reply_email	VARCHAR
6	product_id	INTEGER
7	name	VARCHAR
8	active	BOOLEAN
9	created_at	VARCHAR
10	id	INTEGER

Table: email_mailboxes

No	Column Name	Type	Notes
1	custom_mailbox	VARCHAR
2	incoming	VARCHAR
3	mailbox_type	VARCHAR
4	access_type	VARCHAR
5	use_ssl	BOOLEAN
6	default_reply_email	BOOLEAN
7	delete_from_server	BOOLEAN
8	password	VARCHAR
9	support_email	VARCHAR
10	group_id	INTEGER
11	port	INTEGER
12	product_id	INTEGER
13	name	VARCHAR
14	id	INTEGER
15	mail_server	VARCHAR
16	authentication	VARCHAR
17	username	VARCHAR

Table: canned_response_folders

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	responses_count	INTEGER
3	name	VARCHAR
4	created_at	VARCHAR
5	personal	BOOLEAN
6	id	INTEGER

Table: contacts

No	Column Name	Type	Notes
1	address	VARCHAR
2	company_id	INTEGER
3	custom_fields	VARCHAR
4	mobile	VARCHAR
5	active	BOOLEAN
6	description	VARCHAR
7	created_at	VARCHAR
8	language	VARCHAR
9	preferred_source	VARCHAR
10	time_zone	VARCHAR
11	facebook_id	INTEGER
12	csat_rating	INTEGER
13	updated_at	VARCHAR	Incremental sync key
14	phone	VARCHAR
15	name	VARCHAR
16	unique_external_id	VARCHAR
17	id	INTEGER
18	twitter_id	VARCHAR
19	job_title	VARCHAR
20	email	VARCHAR

External Resources

• Domain Url
• Api Key
• Freshdesk Domain Url
• Freshdesk Api Key
• Business Hours
• Canned Responses
• Canned Response Folders
• Discussion Categories
• Discussion Comments
• Discussion Forums
• Discussion Topics
• Email Configs
• Email Mailboxes
• Satisfaction Ratings
• Scenario Automations
• Sla Policies
• Solution Articles
• Solution Categories
• Solution Folders
• Ticket Fields
• Time Entries
• Here

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.