Freshservice

Tables in the Freshservice connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	requesters	23	id	Full Refresh	updated_at	API Reference
2	tickets	36	id	Full Refresh, Incremental	updated_at	API Reference
3	assets	17	id	Full Refresh	updated_at	API Reference
4	software	14	id	Full Refresh	updated_at	API Reference
5	purchase_orders	21	id	Full Refresh	updated_at
6	changes	24	id	Full Refresh, Incremental	updated_at	API Reference
7	locations	12	id	Full Refresh	updated_at	API Reference
8	vendors	11	id	Full Refresh	updated_at	API Reference
9	agents	34	id	Full Refresh	updated_at	API Reference
10	problems	21	id	Full Refresh, Incremental	updated_at	API Reference
11	releases	22	id	Full Refresh, Incremental	updated_at	API Reference
12	products	11	id	Full Refresh	updated_at	API Reference

Table: requesters

No	Column Name	Type	Notes
1	address	VARCHAR
2	time_format	VARCHAR
3	reporting_manager_id	INTEGER
4	custom_fields	VARCHAR
5	last_name	VARCHAR
6	active	BOOLEAN
7	created_at	VARCHAR
8	language	VARCHAR
9	secondary_emails	VARCHAR
10	time_zone	VARCHAR
11	department_ids	VARCHAR
12	location_id	INTEGER
13	mobile_phone_number	INTEGER
14	can_see_all_tickets_from_associated_departments	BOOLEAN
15	has_logged_in	BOOLEAN
16	updated_at	VARCHAR	Incremental sync key
17	work_phone_number	INTEGER
18	background_information	VARCHAR
19	primary_email	VARCHAR
20	id	INTEGER	Primary Key
21	is_agent	BOOLEAN
22	first_name	VARCHAR
23	job_title	VARCHAR

Table: tickets

No	Column Name	Type	Notes
1	to_emails	VARCHAR
2	attachments	VARCHAR
3	sub_category	VARCHAR
4	responder_id	INTEGER
5	due_by	VARCHAR
6	subject	VARCHAR
7	description	VARCHAR
8	fr_escalated	BOOLEAN
9	created_at	VARCHAR
10	source	INTEGER
11	type	VARCHAR
12	item_category	VARCHAR
13	cc_emails	VARCHAR
14	updated_at	VARCHAR	Incremental sync key
15	urgency	INTEGER
16	reply_cc_emails	VARCHAR
17	id	INTEGER	Primary Key
18	fwd_emails	VARCHAR
19	email	VARCHAR
20	email_config_id	INTEGER
21	department_id	INTEGER
22	custom_fields	VARCHAR
23	impact	INTEGER
24	description_text	VARCHAR
25	fr_due_by	VARCHAR
26	priority	INTEGER
27	tags	VARCHAR
28	is_escalated	BOOLEAN
29	deleted	BOOLEAN
30	group_id	INTEGER
31	phone	VARCHAR
32	name	VARCHAR
33	category	INTEGER
34	spam	BOOLEAN
35	requester_id	INTEGER
36	status	INTEGER

Table: assets

No	Column Name	Type	Notes
1	asset_tag	VARCHAR
2	assigned_on	VARCHAR
3	agent_id	INTEGER
4	display_id	INTEGER
5	department_id	INTEGER
6	impact	VARCHAR
7	description	VARCHAR
8	created_at	VARCHAR
9	author_type	VARCHAR
10	location_id	INTEGER
11	asset_type_id	INTEGER
12	updated_at	VARCHAR	Incremental sync key
13	usage_type	VARCHAR
14	user_id	INTEGER
15	group_id	INTEGER
16	name	VARCHAR
17	id	INTEGER	Primary Key

Table: software

No	Column Name	Type	Notes
1	publisher_id	INTEGER
2	notes	VARCHAR
3	sources	VARCHAR
4	application_type	VARCHAR
5	description	VARCHAR
6	created_at	VARCHAR
7	installation_count	INTEGER
8	user_count	INTEGER
9	updated_at	VARCHAR	Incremental sync key
10	name	VARCHAR
11	managed_by_id	INTEGER
12	id	INTEGER	Primary Key
13	category	VARCHAR
14	status	VARCHAR

Table: purchase_orders

No	Column Name	Type	Notes
1	department_id	INTEGER
2	shipping_cost	INTEGER
3	custom_fields	VARCHAR
4	expected_delivery_date	VARCHAR
5	created_at	VARCHAR
6	billing_address	VARCHAR
7	discount_percentage	INTEGER
8	created_by	VARCHAR
9	currency_code	VARCHAR
10	po_number	VARCHAR
11	purchase_items	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	vendor_id	INTEGER
14	billing_same_as_shipping	INTEGER
15	name	VARCHAR
16	tax_percentage	INTEGER
17	vendor_details	VARCHAR
18	id	INTEGER	Primary Key
19	shipping_address	VARCHAR
20	conversion_rate	DOUBLE
21	status	INTEGER

Table: changes

No	Column Name	Type	Notes
1	blackout_window	VARCHAR
2	planned_end_date	VARCHAR
3	agent_id	INTEGER
4	department_id	INTEGER
5	sub_category	VARCHAR
6	approval_status	INTEGER
7	subject	VARCHAR
8	custom_fields	VARCHAR
9	impact	INTEGER
10	maintenance_window	VARCHAR
11	description	VARCHAR
12	created_at	VARCHAR
13	description_text	VARCHAR
14	change_type	INTEGER
15	priority	INTEGER
16	item_category	VARCHAR
17	updated_at	VARCHAR	Incremental sync key
18	group_id	INTEGER
19	planned_start_date	VARCHAR
20	risk	INTEGER
21	id	INTEGER	Primary Key
22	category	VARCHAR
23	requester_id	INTEGER
24	status	INTEGER

Table: locations

No	Column Name	Type	Notes
1	zipcode	VARCHAR
2	primary_contact_id	INTEGER
3	country	VARCHAR
4	updated_at	VARCHAR	Incremental sync key
5	city	VARCHAR
6	name	VARCHAR
7	parent_location_id	INTEGER
8	created_at	VARCHAR
9	id	INTEGER	Primary Key
10	state	VARCHAR
11	line2	VARCHAR
12	line1	VARCHAR

Table: vendors

No	Column Name	Type	Notes
1	zipcode	VARCHAR
2	primary_contact_id	INTEGER
3	country	VARCHAR
4	updated_at	VARCHAR	Incremental sync key
5	city	VARCHAR
6	name	VARCHAR
7	description	VARCHAR
8	created_at	VARCHAR
9	id	INTEGER	Primary Key
10	state	VARCHAR
11	line1	VARCHAR

Table: agents

No	Column Name	Type	Notes
1	last_login_at	VARCHAR
2	scoreboard_level_id	INTEGER
3	roles	VARCHAR
4	created_at	VARCHAR
5	occasional	BOOLEAN
6	language	VARCHAR
7	location_id	INTEGER
8	role_ids	VARCHAR
9	updated_at	VARCHAR	Incremental sync key
10	work_phone_number	INTEGER
11	background_information	VARCHAR
12	group_ids	VARCHAR
13	id	INTEGER	Primary Key
14	member_of	VARCHAR
15	first_name	VARCHAR
16	job_title	VARCHAR
17	email	VARCHAR
18	change_scope	VARCHAR
19	observer_of	VARCHAR
20	address	VARCHAR
21	time_format	VARCHAR
22	reporting_manager_id	INTEGER
23	problem_scope	VARCHAR
24	custom_fields	VARCHAR
25	last_name	VARCHAR
26	active	BOOLEAN
27	time_zone	VARCHAR
28	department_ids	VARCHAR
29	mobile_phone_number	INTEGER
30	can_see_all_tickets_from_associated_departments	BOOLEAN
31	has_logged_in	BOOLEAN
32	release_scope	VARCHAR
33	last_active_at	VARCHAR
34	ticket_scope	VARCHAR

Table: problems

No	Column Name	Type	Notes
1	agent_id	INTEGER
2	department_id	INTEGER
3	sub_category	VARCHAR
4	subject	VARCHAR
5	due_by	VARCHAR
6	custom_fields	VARCHAR
7	impact	INTEGER
8	known_error	BOOLEAN
9	description	VARCHAR
10	created_at	VARCHAR
11	description_text	VARCHAR
12	priority	INTEGER
13	item_category	VARCHAR
14	updated_at	VARCHAR	Incremental sync key
15	group_id	INTEGER
16	analysis_fields	VARCHAR
17	id	INTEGER	Primary Key
18	associated_change	INTEGER
19	category	VARCHAR
20	requester_id	INTEGER
21	status	INTEGER

Table: releases

No	Column Name	Type	Notes
1	planned_end_date	VARCHAR
2	agent_id	INTEGER
3	department_id	INTEGER
4	sub_category	VARCHAR
5	subject	VARCHAR
6	custom_fields	VARCHAR
7	associated_changes	VARCHAR
8	release_type	INTEGER
9	description	VARCHAR
10	created_at	VARCHAR
11	priority	INTEGER
12	work_start_date	VARCHAR
13	item_category	VARCHAR
14	work_end_date	VARCHAR
15	associated_assets	VARCHAR
16	updated_at	VARCHAR	Incremental sync key
17	group_id	INTEGER
18	planned_start_date	VARCHAR
19	id	INTEGER	Primary Key
20	category	VARCHAR
21	status	INTEGER
22	planning_fields	VARCHAR

Table: products

No	Column Name	Type	Notes
1	asset_type_id	INTEGER
2	depreciation_type_id	INTEGER
3	updated_at	VARCHAR	Incremental sync key
4	mode_of_procurement	VARCHAR
5	name	VARCHAR
6	description	VARCHAR
7	created_at	VARCHAR
8	description_text	VARCHAR
9	id	INTEGER	Primary Key
10	manufacturer	VARCHAR
11	status	VARCHAR

External Resources

• Purchaseorders
• How To Find Your Api Key

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.