Close com

Tables in the Close com connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	lead_tasks	23	id	Full Refresh, Incremental	date_created
2	dialer	14	id	Full Refresh		API Reference
3	google_connected_accounts	6	id	Full Refresh
4	roles	7	id	Full Refresh		API Reference
5	custom_email_connected_accounts	7	id	Full Refresh
6	send_as	4	id	Full Refresh
7	email_templates	12	id	Full Refresh
8	opportunity_status_change_activities	26	id	Full Refresh, Incremental	date_created
9	email_thread_activities	19	id	Full Refresh, Incremental	date_created
10	lead_statuses	3	id	Full Refresh
11	email_bulk_actions	13	id	Full Refresh
12	pipelines	7	id	Full Refresh		API Reference
13	incoming_sms_tasks	25	id	Full Refresh, Incremental	date_created
14	incoming_email_tasks	23	id	Full Refresh, Incremental	date_created
15	email_activities	50	id	Full Refresh, Incremental	date_created
16	lead_custom_fields	13	id	Full Refresh
17	events	15	id	Full Refresh, Incremental	date_updated	API Reference
18	sequence_subscription_bulk_actions	17	id	Full Refresh
19	sms_activities	23	id	Full Refresh, Incremental	date_created
20	opportunity_statuses	5	id	Full Refresh
21	custom_activities	8	id	Full Refresh
22	opportunity_custom_fields	12	id	Full Refresh
23	meeting_activities	25	id	Full Refresh, Incremental	date_created
24	task_completed_activities	13	id	Full Refresh, Incremental	date_created
25	activity_custom_fields	13	id	Full Refresh
26	integration_links	9	id	Full Refresh
27	created_activities	16	id	Full Refresh, Incremental	date_created
28	contact_custom_fields	12	id	Full Refresh
29	smart_views	11	id	Full Refresh
30	edit_bulk_actions	17	id	Full Refresh
31	opportunities	30	id	Full Refresh, Incremental	date_updated	API Reference
32	voicemail_tasks	26	id	Full Refresh, Incremental	date_created
33	opportunity_due_tasks	24	id	Full Refresh, Incremental	date_created
34	users	11	id	Full Refresh		API Reference
35	delete_bulk_actions	11	id	Full Refresh
36	email_sequences	11	id	Full Refresh
37	leads	21	id	Full Refresh, Incremental	date_updated	API Reference
38	lead_status_change_activities	19	id	Full Refresh, Incremental	date_created
39	note_activities	14	id	Full Refresh, Incremental	date_created
40	zoom_connected_accounts	6	id	Full Refresh
41	call_activities	45	id	Full Refresh, Incremental	date_created
42	answered_detached_call_tasks	24	id	Full Refresh, Incremental	date_created
43	missed_call_tasks	24	id	Full Refresh, Incremental	date_created
44	contacts	14	id	Full Refresh		API Reference
45	email_followup_tasks	23	id	Full Refresh, Incremental	date_created

Table: lead_tasks

No	Column Name	Type	Notes
1	date	VARCHAR
2	contact_name	VARCHAR
3	date_updated	VARCHAR
4	object_type	VARCHAR
5	date_created	VARCHAR	Incremental sync key
6	_type	VARCHAR
7	due_date	VARCHAR
8	is_dateless	BOOLEAN
9	lead_name	VARCHAR
10	created_by_name	VARCHAR
11	contact_id	VARCHAR
12	created_by	VARCHAR
13	object_id	VARCHAR
14	updated_by_name	VARCHAR
15	view	VARCHAR
16	organization_id	VARCHAR
17	updated_by	VARCHAR
18	id	VARCHAR	Primary Key
19	is_complete	BOOLEAN
20	text	VARCHAR
21	assigned_to_name	VARCHAR
22	lead_id	VARCHAR
23	assigned_to	VARCHAR

Table: dialer

No	Column Name	Type	Notes
1	ring_mode	VARCHAR
2	date_updated	VARCHAR
3	music_preference	VARCHAR
4	date_created	VARCHAR
5	is_user_dependent	BOOLEAN
6	source_type	VARCHAR
7	type	VARCHAR
8	users	VARCHAR
9	user_id	VARCHAR
10	caller_id	VARCHAR
11	organization_id	VARCHAR
12	id	VARCHAR	Primary Key
13	source_value	VARCHAR
14	status	VARCHAR

Table: google_connected_accounts

No	Column Name	Type	Notes
1	synced_calendars	VARCHAR
2	identities	VARCHAR
3	user_id	VARCHAR
4	organization_id	VARCHAR
5	_type	VARCHAR
6	id	VARCHAR	Primary Key

Table: roles

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	date_created	VARCHAR
3	editable	BOOLEAN
4	permissions	VARCHAR
5	organization_id	VARCHAR
6	name	VARCHAR
7	id	VARCHAR	Primary Key

Table: custom_email_connected_accounts

No	Column Name	Type	Notes
1	imap	VARCHAR
2	identities	VARCHAR
3	smtp	VARCHAR
4	user_id	VARCHAR
5	organization_id	VARCHAR
6	_type	VARCHAR
7	id	VARCHAR	Primary Key

Table: send_as

No	Column Name	Type	Notes
1	allowing_user_id	VARCHAR
2	organization_id	VARCHAR
3	allowed_user_id	VARCHAR
4	id	VARCHAR	Primary Key

Table: email_templates

No	Column Name	Type	Notes
1	attachments	VARCHAR
2	date_updated	VARCHAR
3	is_archived	BOOLEAN
4	subject	VARCHAR
5	date_created	VARCHAR
6	organization_id	VARCHAR
7	is_shared	BOOLEAN
8	updated_by	VARCHAR
9	name	VARCHAR
10	id	VARCHAR	Primary Key
11	body	VARCHAR
12	created_by	VARCHAR

Table: opportunity_status_change_activities

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	old_status_id	VARCHAR
3	opportunity_date_won	VARCHAR
4	user_name	VARCHAR
5	opportunity_value	DOUBLE
6	contact_id	VARCHAR
7	created_by_name	VARCHAR
8	opportunity_value_currency	VARCHAR
9	old_pipeline_id	VARCHAR
10	updated_by_name	VARCHAR
11	old_status_label	VARCHAR
12	id	VARCHAR	Primary Key
13	lead_id	VARCHAR
14	new_pipeline_id	VARCHAR
15	date_created	VARCHAR	Incremental sync key
16	new_status_id	VARCHAR
17	_type	VARCHAR
18	new_status_label	VARCHAR
19	created_by	VARCHAR
20	opportunity_value_formatted	VARCHAR
21	opportunity_id	VARCHAR
22	user_id	VARCHAR
23	new_status_type	VARCHAR
24	organization_id	VARCHAR
25	updated_by	VARCHAR
26	old_status_type	VARCHAR

Table: email_thread_activities

No	Column Name	Type	Notes
1	latest_emails	VARCHAR
2	date_updated	VARCHAR
3	date_created	VARCHAR	Incremental sync key
4	user_name	VARCHAR
5	_type	VARCHAR
6	contact_id	VARCHAR
7	created_by_name	VARCHAR
8	created_by	VARCHAR
9	users	VARCHAR
10	activity_at	VARCHAR
11	n_emails	DOUBLE
12	updated_by_name	VARCHAR
13	user_id	VARCHAR
14	latest_normalized_subject	VARCHAR
15	organization_id	VARCHAR
16	updated_by	VARCHAR
17	id	VARCHAR	Primary Key
18	lead_id	VARCHAR
19	participants	VARCHAR

Table: lead_statuses

No	Column Name	Type	Notes
1	organization_id	VARCHAR
2	label	VARCHAR
3	id	VARCHAR	Primary Key

Table: email_bulk_actions

No	Column Name	Type	Notes
1	contact_preference	VARCHAR
2	n_leads_processed	DOUBLE
3	date_updated	VARCHAR
4	send_done_email	BOOLEAN
5	date_created	VARCHAR
6	query	VARCHAR
7	n_leads	DOUBLE
8	created_by	VARCHAR
9	organization_id	VARCHAR
10	updated_by	VARCHAR
11	template_id	VARCHAR
12	id	VARCHAR	Primary Key
13	status	VARCHAR

Table: pipelines

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	date_created	VARCHAR
3	organization_id	VARCHAR
4	name	VARCHAR
5	statuses	VARCHAR
6	id	VARCHAR	Primary Key
7	created_by	VARCHAR

Table: incoming_sms_tasks

No	Column Name	Type	Notes
1	date	VARCHAR
2	date_updated	VARCHAR
3	lead_name	VARCHAR
4	contact_id	VARCHAR
5	created_by_name	VARCHAR
6	remote_phone_formatted	VARCHAR
7	updated_by_name	VARCHAR
8	view	VARCHAR
9	is_complete	BOOLEAN
10	text	VARCHAR
11	id	VARCHAR	Primary Key
12	lead_id	VARCHAR
13	assigned_to	VARCHAR
14	contact_name	VARCHAR
15	object_type	VARCHAR
16	date_created	VARCHAR	Incremental sync key
17	_type	VARCHAR
18	remote_phone	VARCHAR
19	object_id	VARCHAR
20	created_by	VARCHAR
21	local_phone	VARCHAR
22	organization_id	VARCHAR
23	updated_by	VARCHAR
24	assigned_to_name	VARCHAR
25	remote_phone_description	VARCHAR

Table: incoming_email_tasks

No	Column Name	Type	Notes
1	date	VARCHAR
2	contact_name	VARCHAR
3	date_updated	VARCHAR
4	object_type	VARCHAR
5	date_created	VARCHAR	Incremental sync key
6	subject	VARCHAR
7	body_preview	VARCHAR
8	_type	VARCHAR
9	lead_name	VARCHAR
10	view	VARCHAR
11	contact_id	VARCHAR
12	created_by_name	VARCHAR
13	created_by	VARCHAR
14	emails	VARCHAR
15	updated_by_name	VARCHAR
16	cleared_followups	VARCHAR
17	organization_id	VARCHAR
18	updated_by	VARCHAR
19	is_complete	BOOLEAN
20	id	VARCHAR	Primary Key
21	assigned_to_name	VARCHAR
22	lead_id	VARCHAR
23	assigned_to	VARCHAR

Table: email_activities

No	Column Name	Type	Notes
1	body_html	VARCHAR
2	references	VARCHAR
3	body_text	VARCHAR
4	subject	VARCHAR
5	send_as_id	VARCHAR
6	body_text_quoted	VARCHAR
7	created_by_name	VARCHAR
8	thread_id	VARCHAR
9	has_reply	BOOLEAN
10	id	VARCHAR	Primary Key
11	date_sent	VARCHAR
12	need_smtp_credentials	BOOLEAN
13	created_by	VARCHAR
14	users	VARCHAR
15	activity_at	VARCHAR
16	envelope	VARCHAR
17	user_id	VARCHAR
18	opens_summary	VARCHAR
19	sender	VARCHAR
20	organization_id	VARCHAR
21	updated_by	VARCHAR
22	send_attempts	VARCHAR
23	opens	VARCHAR
24	bulk_email_action_id	VARCHAR
25	sequence_subscription_id	VARCHAR
26	status	VARCHAR
27	attachments	VARCHAR
28	bcc	VARCHAR
29	date_updated	VARCHAR
30	user_name	VARCHAR
31	in_reply_to_id	VARCHAR
32	followup_sequence_id	VARCHAR
33	contact_id	VARCHAR
34	sequence_name	VARCHAR
35	updated_by_name	VARCHAR
36	sequence_id	VARCHAR
37	email_account_id	VARCHAR
38	lead_id	VARCHAR
39	direction	VARCHAR
40	cc	VARCHAR
41	followup_sequence_delay	VARCHAR
42	date_created	VARCHAR	Incremental sync key
43	body_preview	VARCHAR
44	_type	VARCHAR
45	body_html_quoted	VARCHAR
46	template_name	VARCHAR
47	date_scheduled	VARCHAR
48	message_ids	VARCHAR
49	template_id	VARCHAR
50	to	VARCHAR

Table: lead_custom_fields

No	Column Name	Type	Notes
1	editable_with_roles	VARCHAR
2	date_created	VARCHAR
3	description	VARCHAR
4	type	VARCHAR
5	created_by	VARCHAR
6	status_id	VARCHAR
7	organization_id	VARCHAR
8	is_shared	VARCHAR
9	name	VARCHAR
10	updated_by	VARCHAR
11	id	VARCHAR	Primary Key
12	accepts_multiple_values	VARCHAR
13	choices	VARCHAR

Table: events

No	Column Name	Type	Notes
1	date_updated	VARCHAR	Incremental sync key
2	data	VARCHAR
3	object_type	VARCHAR
4	previous_data	VARCHAR
5	date_created	VARCHAR
6	object_id	VARCHAR
7	api_key_id	VARCHAR
8	changed_fields	VARCHAR
9	user_id	VARCHAR
10	meta	VARCHAR
11	organization_id	VARCHAR
12	action	VARCHAR
13	id	VARCHAR	Primary Key
14	request_id	VARCHAR
15	lead_id	VARCHAR

Table: sequence_subscription_bulk_actions

No	Column Name	Type	Notes
1	contact_preference	VARCHAR
2	n_leads_processed	DOUBLE
3	date_updated	VARCHAR
4	send_done_email	BOOLEAN
5	action_type	VARCHAR
6	date_created	VARCHAR
7	query	VARCHAR
8	sender_name	VARCHAR
9	n_leads	DOUBLE
10	created_by	VARCHAR
11	organization_id	VARCHAR
12	sequence_id	VARCHAR
13	sender_account_id	VARCHAR
14	updated_by	VARCHAR
15	id	VARCHAR	Primary Key
16	status	VARCHAR
17	sender_email	VARCHAR

Table: sms_activities

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	date_sent	VARCHAR
3	cost	VARCHAR
4	date_created	VARCHAR	Incremental sync key
5	user_name	VARCHAR
6	_type	VARCHAR
7	local_country_iso	VARCHAR
8	remote_phone	VARCHAR
9	contact_id	VARCHAR
10	created_by_name	VARCHAR
11	created_by	VARCHAR
12	local_phone	VARCHAR
13	remote_phone_formatted	VARCHAR
14	updated_by_name	VARCHAR
15	user_id	VARCHAR
16	organization_id	VARCHAR
17	updated_by	VARCHAR
18	remote_country_iso	VARCHAR
19	id	VARCHAR	Primary Key
20	text	VARCHAR
21	lead_id	VARCHAR
22	direction	VARCHAR
23	status	VARCHAR

Table: opportunity_statuses

No	Column Name	Type	Notes
1	organization_id	VARCHAR
2	pipeline_id	VARCHAR
3	label	VARCHAR
4	id	VARCHAR	Primary Key
5	type	VARCHAR

Table: custom_activities

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	editable_with_roles	VARCHAR
3	date_created	VARCHAR
4	description	VARCHAR
5	id	VARCHAR	Primary Key
6	fields	VARCHAR
7	api_create_only	BOOLEAN
8	created_by	VARCHAR

Table: opportunity_custom_fields

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	editable_with_roles	VARCHAR
3	date_created	VARCHAR
4	organization_id	VARCHAR
5	name	VARCHAR
6	updated_by	VARCHAR
7	description	VARCHAR
8	id	VARCHAR	Primary Key
9	choices	VARCHAR
10	type	VARCHAR
11	accepts_multiple_values	VARCHAR
12	created_by	VARCHAR

Table: meeting_activities

No	Column Name	Type	Notes
1	note	VARCHAR
2	starts_at	VARCHAR
3	date_updated	VARCHAR
4	user_name	VARCHAR
5	source	VARCHAR
6	created_by_name	VARCHAR
7	title	VARCHAR
8	duration	DOUBLE
9	updated_by_name	VARCHAR
10	ends_at	VARCHAR
11	id	VARCHAR	Primary Key
12	is_recurring	BOOLEAN
13	lead_id	VARCHAR
14	attendees	VARCHAR
15	date_created	VARCHAR	Incremental sync key
16	_type	VARCHAR
17	created_by	VARCHAR
18	users	VARCHAR
19	calendar_event_link	VARCHAR
20	user_id	VARCHAR
21	organization_id	VARCHAR
22	updated_by	VARCHAR
23	connected_account_id	VARCHAR
24	location	VARCHAR
25	status	VARCHAR

Table: task_completed_activities

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	date_created	VARCHAR	Incremental sync key
3	_type	VARCHAR
4	task_id	VARCHAR
5	created_by_name	VARCHAR
6	created_by	VARCHAR
7	task_text	VARCHAR
8	updated_by_name	VARCHAR
9	user_id	VARCHAR
10	organization_id	VARCHAR
11	updated_by	VARCHAR
12	id	VARCHAR	Primary Key
13	lead_id	VARCHAR

Table: activity_custom_fields

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	editable_with_roles	VARCHAR
3	date_created	VARCHAR
4	description	VARCHAR
5	type	VARCHAR
6	created_by	VARCHAR
7	required	VARCHAR
8	organization_id	VARCHAR
9	name	VARCHAR
10	updated_by	VARCHAR
11	id	VARCHAR	Primary Key
12	accepts_multiple_values	VARCHAR
13	custom_activity_type_id	VARCHAR

Table: integration_links

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	date_created	VARCHAR
3	organization_id	VARCHAR
4	updated_by	VARCHAR
5	name	VARCHAR
6	id	VARCHAR	Primary Key
7	type	VARCHAR
8	created_by	VARCHAR
9	url	VARCHAR

Table: created_activities

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	date_created	VARCHAR	Incremental sync key
3	user_name	VARCHAR
4	import_id	VARCHAR
5	_type	VARCHAR
6	source	VARCHAR
7	contact_id	VARCHAR
8	created_by_name	VARCHAR
9	created_by	VARCHAR
10	users	VARCHAR
11	updated_by_name	VARCHAR
12	user_id	VARCHAR
13	organization_id	VARCHAR
14	updated_by	VARCHAR
15	id	VARCHAR	Primary Key
16	lead_id	VARCHAR

Table: contact_custom_fields

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	editable_with_roles	VARCHAR
3	date_created	VARCHAR
4	organization_id	VARCHAR
5	name	VARCHAR
6	updated_by	VARCHAR
7	description	VARCHAR
8	id	VARCHAR	Primary Key
9	choices	VARCHAR
10	type	VARCHAR
11	accepts_multiple_values	VARCHAR
12	created_by	VARCHAR

Table: smart_views

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	s_query	VARCHAR
3	user_id	VARCHAR
4	date_created	VARCHAR
5	organization_id	VARCHAR
6	query	VARCHAR
7	is_shared	BOOLEAN
8	name	VARCHAR
9	is_user_dependent	BOOLEAN
10	id	VARCHAR	Primary Key
11	type	VARCHAR

Table: edit_bulk_actions

No	Column Name	Type	Notes
1	lead_status_id	VARCHAR
2	custom_field_name	VARCHAR
3	n_leads_processed	DOUBLE
4	date_updated	VARCHAR
5	send_done_email	BOOLEAN
6	date_created	VARCHAR
7	query	VARCHAR
8	n_objects	DOUBLE
9	n_objects_processed	DOUBLE
10	custom_field_value	VARCHAR
11	type	VARCHAR
12	n_leads	DOUBLE
13	created_by	VARCHAR
14	organization_id	VARCHAR
15	updated_by	VARCHAR
16	id	VARCHAR	Primary Key
17	status	VARCHAR

Table: opportunities

No	Column Name	Type	Notes
1	note	VARCHAR
2	date_updated	VARCHAR	Incremental sync key
3	status_type	VARCHAR
4	user_name	VARCHAR
5	lead_name	VARCHAR
6	contact_id	VARCHAR
7	created_by_name	VARCHAR
8	updated_by_name	VARCHAR
9	status_id	VARCHAR
10	id	VARCHAR	Primary Key
11	value_currency	VARCHAR
12	value	DOUBLE
13	lead_id	VARCHAR
14	contact_name	VARCHAR
15	date_won	VARCHAR
16	date_created	VARCHAR
17	integration_links	VARCHAR
18	confidence	DOUBLE
19	created_by	VARCHAR
20	annualized_value	DOUBLE
21	status_label	VARCHAR
22	date_lost	VARCHAR
23	status_display_name	VARCHAR
24	user_id	VARCHAR
25	annualized_expected_value	DOUBLE
26	organization_id	VARCHAR
27	value_formatted	VARCHAR
28	updated_by	VARCHAR
29	value_period	VARCHAR
30	expected_value	DOUBLE

Table: voicemail_tasks

No	Column Name	Type	Notes
1	date	VARCHAR
2	date_updated	VARCHAR
3	lead_name	VARCHAR
4	voicemail_duration	DOUBLE
5	contact_id	VARCHAR
6	created_by_name	VARCHAR
7	updated_by_name	VARCHAR
8	view	VARCHAR
9	phone_formatted	VARCHAR
10	is_complete	BOOLEAN
11	id	VARCHAR	Primary Key
12	lead_id	VARCHAR
13	voicemail_url	VARCHAR
14	assigned_to	VARCHAR
15	contact_name	VARCHAR
16	object_type	VARCHAR
17	date_created	VARCHAR	Incremental sync key
18	_type	VARCHAR
19	created_by	VARCHAR
20	object_id	VARCHAR
21	local_phone	VARCHAR
22	phone_number_description	VARCHAR
23	phone	VARCHAR
24	organization_id	VARCHAR
25	updated_by	VARCHAR
26	assigned_to_name	VARCHAR

Table: opportunity_due_tasks

No	Column Name	Type	Notes
1	date	VARCHAR
2	contact_name	VARCHAR
3	date_updated	VARCHAR
4	object_type	VARCHAR
5	date_created	VARCHAR	Incremental sync key
6	opportunity_value	DOUBLE
7	_type	VARCHAR
8	lead_name	VARCHAR
9	created_by_name	VARCHAR
10	contact_id	VARCHAR
11	object_id	VARCHAR
12	created_by	VARCHAR
13	opportunity_value_formatted	VARCHAR
14	updated_by_name	VARCHAR
15	view	VARCHAR
16	opportunity_value_period	VARCHAR
17	organization_id	VARCHAR
18	updated_by	VARCHAR
19	is_complete	BOOLEAN
20	id	VARCHAR	Primary Key
21	assigned_to_name	VARCHAR
22	lead_id	VARCHAR
23	assigned_to	VARCHAR
24	opportunity_note	VARCHAR

Table: users

No	Column Name	Type	Notes
1	email_verification_token_generated_at	VARCHAR
2	image	VARCHAR
3	date_updated	VARCHAR
4	last_used_timezone	VARCHAR
5	date_created	VARCHAR
6	organizations	VARCHAR
7	last_name	VARCHAR
8	email_verified_at	VARCHAR
9	id	VARCHAR	Primary Key
10	first_name	VARCHAR
11	email	VARCHAR

Table: delete_bulk_actions

No	Column Name	Type	Notes
1	n_leads_processed	DOUBLE
2	date_updated	VARCHAR
3	send_done_email	BOOLEAN
4	date_created	VARCHAR
5	query	VARCHAR
6	organization_id	VARCHAR
7	updated_by	VARCHAR
8	id	VARCHAR	Primary Key
9	n_leads	DOUBLE
10	created_by	VARCHAR
11	status	VARCHAR

Table: email_sequences

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	timezone	VARCHAR
3	date_created	VARCHAR
4	organization_id	VARCHAR
5	name	VARCHAR
6	updated_by_id	VARCHAR
7	id	VARCHAR	Primary Key
8	created_by_id	VARCHAR
9	schedule_id	VARCHAR
10	steps	VARCHAR
11	status	VARCHAR

Table: leads

No	Column Name	Type	Notes
1	addresses	VARCHAR
2	date_updated	VARCHAR	Incremental sync key
3	date_created	VARCHAR
4	integration_links	VARCHAR
5	custom	VARCHAR
6	description	VARCHAR
7	display_name	VARCHAR
8	created_by_name	VARCHAR
9	opportunities	VARCHAR
10	created_by	VARCHAR
11	url	VARCHAR
12	updated_by_name	VARCHAR
13	status_label	VARCHAR
14	status_id	VARCHAR
15	html_url	VARCHAR
16	organization_id	VARCHAR
17	updated_by	VARCHAR
18	name	VARCHAR
19	id	VARCHAR	Primary Key
20	tasks	VARCHAR
21	contacts	VARCHAR

Table: lead_status_change_activities

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	old_status_id	VARCHAR
3	user_name	VARCHAR
4	date_created	VARCHAR	Incremental sync key
5	new_status_id	VARCHAR
6	_type	VARCHAR
7	new_status_label	VARCHAR
8	created_by_name	VARCHAR
9	contact_id	VARCHAR
10	created_by	VARCHAR
11	users	VARCHAR
12	activity_at	VARCHAR
13	updated_by_name	VARCHAR
14	user_id	VARCHAR
15	organization_id	VARCHAR
16	old_status_label	VARCHAR
17	updated_by	VARCHAR
18	id	VARCHAR	Primary Key
19	lead_id	VARCHAR

Table: note_activities

No	Column Name	Type	Notes
1	note	VARCHAR
2	date_updated	VARCHAR
3	date_created	VARCHAR	Incremental sync key
4	user_name	VARCHAR
5	_type	VARCHAR
6	contact_id	VARCHAR
7	created_by_name	VARCHAR
8	created_by	VARCHAR
9	updated_by_name	VARCHAR
10	user_id	VARCHAR
11	organization_id	VARCHAR
12	updated_by	VARCHAR
13	id	VARCHAR	Primary Key
14	lead_id	VARCHAR

Table: zoom_connected_accounts

No	Column Name	Type	Notes
1	identities	VARCHAR
2	user_id	VARCHAR
3	organization_id	VARCHAR
4	_type	VARCHAR
5	id	VARCHAR	Primary Key
6	email	VARCHAR

Table: call_activities

No	Column Name	Type	Notes
1	is_to_group_number	BOOLEAN
2	note	VARCHAR
3	recording_url	VARCHAR
4	date_updated	VARCHAR
5	recording_expires_at	VARCHAR
6	user_name	VARCHAR
7	transferred_to	VARCHAR
8	transferred_to_user_id	VARCHAR
9	local_country_iso	VARCHAR
10	voicemail_duration	DOUBLE
11	source	VARCHAR
12	local_phone_formatted	VARCHAR
13	contact_id	VARCHAR
14	has_recording	BOOLEAN
15	created_by_name	VARCHAR
16	remote_phone_formatted	VARCHAR
17	duration	DOUBLE
18	is_joinable	BOOLEAN
19	updated_by_name	VARCHAR
20	dialer_saved_search_id	VARCHAR
21	id	VARCHAR	Primary Key
22	lead_id	VARCHAR
23	voicemail_url	VARCHAR
24	dialer_id	VARCHAR
25	direction	VARCHAR
26	cost	VARCHAR
27	date_created	VARCHAR	Incremental sync key
28	_type	VARCHAR
29	remote_phone	VARCHAR
30	transferred_from	VARCHAR
31	created_by	VARCHAR
32	users	VARCHAR
33	local_phone	VARCHAR
34	activity_at	VARCHAR
35	disposition	VARCHAR
36	phone	VARCHAR
37	transferred_from_user_id	VARCHAR
38	user_id	VARCHAR
39	organization_id	VARCHAR
40	updated_by	VARCHAR
41	date_answered	VARCHAR
42	coach_legs	VARCHAR
43	remote_country_iso	VARCHAR
44	call_method	VARCHAR
45	status	VARCHAR

Table: answered_detached_call_tasks

No	Column Name	Type	Notes
1	date	VARCHAR
2	recording_url	VARCHAR
3	contact_name	VARCHAR
4	date_updated	VARCHAR
5	object_type	VARCHAR
6	date_created	VARCHAR	Incremental sync key
7	_type	VARCHAR
8	lead_name	VARCHAR
9	contact_id	VARCHAR
10	created_by_name	VARCHAR
11	object_id	VARCHAR
12	created_by	VARCHAR
13	updated_by_name	VARCHAR
14	view	VARCHAR
15	phone_number_description	VARCHAR
16	phone	VARCHAR
17	organization_id	VARCHAR
18	phone_formatted	VARCHAR
19	updated_by	VARCHAR
20	is_complete	BOOLEAN
21	id	VARCHAR	Primary Key
22	assigned_to_name	VARCHAR
23	lead_id	VARCHAR
24	assigned_to	VARCHAR

Table: missed_call_tasks

No	Column Name	Type	Notes
1	date	VARCHAR
2	contact_name	VARCHAR
3	date_updated	VARCHAR
4	object_type	VARCHAR
5	date_created	VARCHAR	Incremental sync key
6	_type	VARCHAR
7	lead_name	VARCHAR
8	contact_id	VARCHAR
9	created_by_name	VARCHAR
10	object_id	VARCHAR
11	created_by	VARCHAR
12	local_phone	VARCHAR
13	updated_by_name	VARCHAR
14	view	VARCHAR
15	phone_number_description	VARCHAR
16	phone	VARCHAR
17	organization_id	VARCHAR
18	phone_formatted	VARCHAR
19	updated_by	VARCHAR
20	is_complete	BOOLEAN
21	id	VARCHAR	Primary Key
22	assigned_to_name	VARCHAR
23	lead_id	VARCHAR
24	assigned_to	VARCHAR

Table: contacts

No	Column Name	Type	Notes
1	date_updated	VARCHAR
2	date_created	VARCHAR
3	integration_links	VARCHAR
4	phones	VARCHAR
5	title	VARCHAR
6	display_name	VARCHAR
7	created_by	VARCHAR
8	emails	VARCHAR
9	urls	VARCHAR
10	organization_id	VARCHAR
11	name	VARCHAR
12	updated_by	VARCHAR
13	id	VARCHAR	Primary Key
14	lead_id	VARCHAR

Table: email_followup_tasks

No	Column Name	Type	Notes
1	date	VARCHAR
2	email_id	VARCHAR
3	contact_name	VARCHAR
4	date_updated	VARCHAR
5	object_type	VARCHAR
6	date_created	VARCHAR	Incremental sync key
7	subject	VARCHAR
8	body_preview	VARCHAR
9	_type	VARCHAR
10	lead_name	VARCHAR
11	contact_id	VARCHAR
12	created_by_name	VARCHAR
13	updated_by_name	VARCHAR
14	created_by	VARCHAR
15	object_id	VARCHAR
16	view	VARCHAR
17	organization_id	VARCHAR
18	updated_by	VARCHAR
19	is_complete	BOOLEAN
20	id	VARCHAR	Primary Key
21	assigned_to_name	VARCHAR
22	lead_id	VARCHAR
23	assigned_to	VARCHAR

External Resources

• Close.com Api Keys Page
• This Guide
• Created Activities
• Opportunity Status Change Activities
• Note Activities
• Meeting Activities
• Call Activities
• Email Activities
• Email Thread Activities
• Lead Status Change Activities
• Sms Activities
• Task Completed Activities
• Lead Tasks
• Incoming Email Tasks
• Email Followup Tasks
• Missed Call Tasks
• Answered Detached Call Tasks
• Voicemail Tasks
• Opportunity Due Tasks
• Incoming Sms Tasks
• Lead Custom Fields
• Contact Custom Fields
• Opportunity Custom Fields
• Activity Custom Fields
• Lead Statuses
• Opportunity Statuses
• Email Templates
• Google Connected Accounts
• Custom Email Connected Accounts
• Zoom Connected Accounts
• Send As
• Email Sequences
• Smart Views
• Email Bulk Actions
• Sequence Subscription Bulk Actions
• Delete Bulk Actions
• Edit Bulk Actions
• Integration Links
• Custom Activities
• Close.com Api
• Jsonschema
• 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.