Freshsales

Prerequisites

• Freshsales Account
• Freshsales API Key
• Freshsales Domain Name

Please read How to find your API key.

Tables in the Freshsales connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	open_tasks	17	id	Full Refresh
2	won_deals	48	id	Full Refresh
3	lost_deals	48	id	Full Refresh
4	completed_tasks	17	id	Full Refresh
5	past_appointments	32	id	Full Refresh
6	open_deals	48	id	Full Refresh
7	accounts	60	id	Full Refresh		API Reference
8	upcoming_appointments	32	id	Full Refresh
9	contacts	76	id	Full Refresh		API Reference

Table: open_tasks

No	Column Name	Type	Notes
1	outcome_id	INTEGER
2	Possible	VARCHAR
3	owner_id	INTEGER
4	due_date	VARCHAR
5	description	VARCHAR
6	created_at	VARCHAR
7	title	VARCHAR
8	creater_id	INTEGER
9	completed_date	VARCHAR
10	task_type_id	INTEGER
11	updated_at	VARCHAR
12	targetable_type	VARCHAR
13	updater_id	INTEGER
14	id	INTEGER	Primary Key
15	targetables	VARCHAR
16	targetable_id	INTEGER
17	status	VARCHAR

Table: won_deals

No	Column Name	Type	Notes
1	closed_date	VARCHAR
2	last_deal_prediction	VARCHAR
3	owner_id	INTEGER
4	completed_sales_sequences	VARCHAR
5	deal_stage_id	INTEGER
6	forecast_category	INTEGER
7	has_products	BOOLEAN
8	created_at	VARCHAR
9	upcoming_activities_time	VARCHAR
10	stage_updated_time	VARCHAR
11	team_user_ids	VARCHAR
12	deal_pipeline_id	INTEGER
13	products	VARCHAR
14	is_deleted	BOOLEAN
15	updated_at	VARCHAR
16	last_contacted_via_sales_activity	VARCHAR
17	deal_payment_status_id	INTEGER
18	freddy_forecast_metrics	VARCHAR
19	deal_reason_id	INTEGER
20	links	VARCHAR
21	id	INTEGER	Primary Key
22	campaign_id	INTEGER
23	territory_id	INTEGER
24	deal_prediction	INTEGER
25	custom_field	VARCHAR
26	amount	DOUBLE
27	web_form_id	INTEGER
28	deal_type_id	INTEGER
29	fc_widget_collaboration	VARCHAR
30	probability	INTEGER
31	active_sales_sequences	VARCHAR
32	avatar	VARCHAR
33	base_currency_amount	DOUBLE
34	tags	VARCHAR
35	lead_source_id	INTEGER
36	sales_account_id	INTEGER
37	deal_product_id	INTEGER
38	collaboration	VARCHAR
39	last_assigned_at	VARCHAR
40	expected_deal_value	DOUBLE
41	name	VARCHAR
42	deal_prediction_last_updated_at	VARCHAR
43	recent_note	VARCHAR
44	currency_id	INTEGER
45	expected_close	VARCHAR
46	age	INTEGER
47	rotten_days	INTEGER
48	last_contacted_sales_activity_mode	VARCHAR

Table: lost_deals

No	Column Name	Type	Notes
1	closed_date	VARCHAR
2	last_deal_prediction	VARCHAR
3	owner_id	INTEGER
4	completed_sales_sequences	VARCHAR
5	deal_stage_id	INTEGER
6	forecast_category	INTEGER
7	has_products	BOOLEAN
8	created_at	VARCHAR
9	upcoming_activities_time	VARCHAR
10	stage_updated_time	VARCHAR
11	team_user_ids	VARCHAR
12	deal_pipeline_id	INTEGER
13	products	VARCHAR
14	is_deleted	BOOLEAN
15	updated_at	VARCHAR
16	last_contacted_via_sales_activity	VARCHAR
17	deal_payment_status_id	INTEGER
18	freddy_forecast_metrics	VARCHAR
19	deal_reason_id	INTEGER
20	links	VARCHAR
21	id	INTEGER	Primary Key
22	campaign_id	INTEGER
23	territory_id	INTEGER
24	deal_prediction	INTEGER
25	custom_field	VARCHAR
26	amount	DOUBLE
27	web_form_id	INTEGER
28	deal_type_id	INTEGER
29	fc_widget_collaboration	VARCHAR
30	probability	INTEGER
31	active_sales_sequences	VARCHAR
32	avatar	VARCHAR
33	base_currency_amount	DOUBLE
34	tags	VARCHAR
35	lead_source_id	INTEGER
36	sales_account_id	INTEGER
37	deal_product_id	INTEGER
38	collaboration	VARCHAR
39	last_assigned_at	VARCHAR
40	expected_deal_value	DOUBLE
41	name	VARCHAR
42	deal_prediction_last_updated_at	VARCHAR
43	recent_note	VARCHAR
44	currency_id	INTEGER
45	expected_close	VARCHAR
46	age	INTEGER
47	rotten_days	INTEGER
48	last_contacted_sales_activity_mode	VARCHAR

Table: completed_tasks

No	Column Name	Type	Notes
1	outcome_id	INTEGER
2	Possible	VARCHAR
3	owner_id	INTEGER
4	due_date	VARCHAR
5	description	VARCHAR
6	created_at	VARCHAR
7	title	VARCHAR
8	creater_id	INTEGER
9	completed_date	VARCHAR
10	task_type_id	INTEGER
11	updated_at	VARCHAR
12	targetable_type	VARCHAR
13	updater_id	INTEGER
14	id	INTEGER	Primary Key
15	targetables	VARCHAR
16	targetable_id	INTEGER
17	status	VARCHAR

Table: past_appointments

No	Column Name	Type	Notes
1	date	VARCHAR
2	end_date	VARCHAR
3	checkedout_at	VARCHAR
4	is_allday	VARCHAR
5	Start	VARCHAR
6	checkedin_duration	VARCHAR
7	can_checkin	BOOLEAN
8	latitude	VARCHAR
9	description	VARCHAR
10	created_at	VARCHAR
11	title	VARCHAR
12	updated_at	VARCHAR
13	can_checkin_checkout	BOOLEAN
14	provider	VARCHAR
15	targetable_type	VARCHAR
16	checkedin_at	VARCHAR
17	id	INTEGER	Primary Key
18	targetable_id	INTEGER
19	longitude	VARCHAR
20	outcome_id	INTEGER
21	from_date	VARCHAR
22	Possible	VARCHAR
23	time_zone	VARCHAR
24	creater_id	INTEGER
25	checkedout_location	VARCHAR
26	conference_id	VARCHAR
27	End	VARCHAR
28	location	VARCHAR
29	appointment_attendees_attributes	VARCHAR
30	checkedout_latitude	VARCHAR
31	targetables	VARCHAR
32	checkedout_longitude	VARCHAR

Table: open_deals

No	Column Name	Type	Notes
1	closed_date	VARCHAR
2	last_deal_prediction	VARCHAR
3	owner_id	INTEGER
4	completed_sales_sequences	VARCHAR
5	deal_stage_id	INTEGER
6	forecast_category	INTEGER
7	has_products	BOOLEAN
8	created_at	VARCHAR
9	upcoming_activities_time	VARCHAR
10	stage_updated_time	VARCHAR
11	team_user_ids	VARCHAR
12	deal_pipeline_id	INTEGER
13	products	VARCHAR
14	is_deleted	BOOLEAN
15	updated_at	VARCHAR
16	last_contacted_via_sales_activity	VARCHAR
17	deal_payment_status_id	INTEGER
18	freddy_forecast_metrics	VARCHAR
19	deal_reason_id	INTEGER
20	links	VARCHAR
21	id	INTEGER	Primary Key
22	campaign_id	INTEGER
23	territory_id	INTEGER
24	deal_prediction	INTEGER
25	custom_field	VARCHAR
26	amount	DOUBLE
27	web_form_id	INTEGER
28	deal_type_id	INTEGER
29	fc_widget_collaboration	VARCHAR
30	probability	INTEGER
31	active_sales_sequences	VARCHAR
32	avatar	VARCHAR
33	base_currency_amount	DOUBLE
34	tags	VARCHAR
35	lead_source_id	INTEGER
36	sales_account_id	INTEGER
37	deal_product_id	INTEGER
38	collaboration	VARCHAR
39	last_assigned_at	VARCHAR
40	expected_deal_value	DOUBLE
41	name	VARCHAR
42	deal_prediction_last_updated_at	VARCHAR
43	recent_note	VARCHAR
44	currency_id	INTEGER
45	expected_close	VARCHAR
46	age	INTEGER
47	rotten_days	INTEGER
48	last_contacted_sales_activity_mode	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	country	VARCHAR
2	last_seen	VARCHAR
3	owner_id	INTEGER
4	open_deals_count	INTEGER
5	team_user_ids	VARCHAR
6	industry_type_id	INTEGER
7	parent_sales_account_id	INTEGER
8	twitter	VARCHAR
9	subscription_status	INTEGER
10	won_deals_amount	DOUBLE
11	links	VARCHAR
12	id	INTEGER	Primary Key
13	state	VARCHAR
14	keyword	VARCHAR
15	job_title	VARCHAR
16	territory_id	INTEGER
17	customer_fit	VARCHAR
18	active_sales_sequences	VARCHAR
19	display_name	VARCHAR
20	last_contacted_mode	VARCHAR
21	tags	VARCHAR
22	zipcode	VARCHAR
23	work_number	VARCHAR
24	last_contacted	VARCHAR
25	lead_score	INTEGER
26	phone	VARCHAR
27	whatsapp_subscription_status	VARCHAR
28	name	VARCHAR
29	recent_note	VARCHAR
30	annual_revenue	DOUBLE
31	business_type_id	INTEGER
32	last_contacted_sales_activity_mode	VARCHAR
33	work_email	VARCHAR
34	city	VARCHAR
35	completed_sales_sequences	VARCHAR
36	created_at	VARCHAR
37	external_id	VARCHAR
38	linkedin	VARCHAR
39	medium	VARCHAR
40	emails	VARCHAR
41	is_deleted	BOOLEAN
42	updated_at	VARCHAR
43	last_contacted_via_sales_activity	VARCHAR
44	web_form_ids	VARCHAR
45	first_name	VARCHAR
46	email	VARCHAR
47	won_deals_count	INTEGER
48	custom_field	VARCHAR
49	website	VARCHAR
50	address	VARCHAR
51	facebook	VARCHAR
52	last_name	VARCHAR
53	avatar	VARCHAR
54	subscription_types	VARCHAR
55	time_zone	VARCHAR
56	phone_numbers	VARCHAR
57	number_of_employees	INTEGER
58	last_assigned_at	VARCHAR
59	mobile_number	VARCHAR
60	open_deals_amount	DOUBLE

Table: upcoming_appointments

No	Column Name	Type	Notes
1	date	VARCHAR
2	end_date	VARCHAR
3	checkedout_at	VARCHAR
4	is_allday	VARCHAR
5	Start	VARCHAR
6	checkedin_duration	VARCHAR
7	can_checkin	BOOLEAN
8	latitude	VARCHAR
9	description	VARCHAR
10	created_at	VARCHAR
11	title	VARCHAR
12	updated_at	VARCHAR
13	can_checkin_checkout	BOOLEAN
14	provider	VARCHAR
15	targetable_type	VARCHAR
16	checkedin_at	VARCHAR
17	id	INTEGER	Primary Key
18	targetable_id	INTEGER
19	longitude	VARCHAR
20	outcome_id	INTEGER
21	from_date	VARCHAR
22	Possible	VARCHAR
23	time_zone	VARCHAR
24	creater_id	INTEGER
25	checkedout_location	VARCHAR
26	conference_id	VARCHAR
27	End	VARCHAR
28	location	VARCHAR
29	appointment_attendees_attributes	VARCHAR
30	checkedout_latitude	VARCHAR
31	targetables	VARCHAR
32	checkedout_longitude	VARCHAR

Table: contacts

No	Column Name	Type	Notes
1	country	VARCHAR
2	last_seen	VARCHAR
3	owner_id	INTEGER
4	open_deals_count	INTEGER
5	latest_medium	VARCHAR
6	team_user_ids	VARCHAR
7	twitter	VARCHAR
8	subscription_status	VARCHAR
9	won_deals_amount	DOUBLE
10	links	VARCHAR
11	first_source	VARCHAR
12	id	INTEGER	Primary Key
13	state	VARCHAR
14	keyword	VARCHAR
15	job_title	VARCHAR
16	territory_id	INTEGER
17	campaign_id	INTEGER
18	customer_fit	INTEGER
19	latest_source	VARCHAR
20	contact_status_id	INTEGER
21	active_sales_sequences	VARCHAR
22	display_name	VARCHAR
23	last_contacted_mode	VARCHAR
24	total_sessions	VARCHAR
25	sms_subscription_status	VARCHAR
26	tags	VARCHAR
27	work_number	VARCHAR
28	zipcode	VARCHAR
29	lifecycle_stage_id	INTEGER
30	last_campaign	VARCHAR
31	last_contacted	VARCHAR
32	lead_score	INTEGER
33	sales_account_id	INTEGER
34	whatsapp_subscription_status	INTEGER
35	mcr_id	VARCHAR
36	first_seen_chat	VARCHAR
37	recent_note	VARCHAR
38	other_unsubscription_reason	VARCHAR
39	last_contacted_sales_activity_mode	VARCHAR
40	unsubscription_reason	VARCHAR
41	work_email	VARCHAR
42	city	VARCHAR
43	completed_sales_sequences	VARCHAR
44	created_at	VARCHAR
45	external_id	VARCHAR
46	medium	VARCHAR
47	linkedin	VARCHAR
48	locale	VARCHAR
49	sales_accounts	VARCHAR
50	emails	VARCHAR
51	is_deleted	BOOLEAN
52	updated_at	VARCHAR
53	last_contacted_via_sales_activity	VARCHAR
54	system_tags	VARCHAR
55	web_form_ids	VARCHAR
56	first_medium	VARCHAR
57	first_name	VARCHAR
58	last_seen_chat	VARCHAR
59	email	VARCHAR
60	won_deals_count	INTEGER
61	custom_field	VARCHAR
62	address	VARCHAR
63	facebook	VARCHAR
64	last_name	VARCHAR
65	latest_campaign	VARCHAR
66	subscription_types	VARCHAR
67	avatar	VARCHAR
68	time_zone	VARCHAR
69	lead_source_id	INTEGER
70	phone_numbers	VARCHAR
71	last_source	VARCHAR
72	last_assigned_at	VARCHAR
73	first_campaign	VARCHAR
74	last_medium	VARCHAR
75	mobile_number	VARCHAR
76	open_deals_amount	DOUBLE

External Resources

• How To Find Your Api Key
• These Steps
• Open Deals
• Won Deals
• Lost Deals
• Open Tasks
• Completed Tasks
• Past Appointments
• Upcoming Appointments

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.