Pipedrive

Prerequisites

• A Pipedrive account;
• An API token;
• A client_id, client_secret, and refresh_token.

Tables in the Pipedrive connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	person_fields	20		Full Refresh, Incremental	update_time
2	notes	20	id	Full Refresh, Incremental	update_time	API Reference
3	roles	8	id	Full Refresh		API Reference
4	product_fields	23	id	Full Refresh
5	filters	10	id	Full Refresh, Incremental	update_time	API Reference
6	users	20		Full Refresh, Incremental	modified	API Reference
7	deal_products	22	id	Full Refresh
8	products	18	id	Full Refresh, Incremental	update_time	API Reference
9	persons	43		Full Refresh, Incremental	update_time	API Reference
10	organization_fields	20		Full Refresh, Incremental	update_time
11	pipelines	9		Full Refresh, Incremental	update_time	API Reference
12	leads	15		Full Refresh		API Reference
13	activities	63		Full Refresh, Incremental	update_time	API Reference
14	activity_types	10	id	Full Refresh, Incremental	update_time
15	deals	57		Full Refresh, Incremental	update_time	API Reference
16	organizations	46		Full Refresh, Incremental	update_time	API Reference
17	permission_sets	5	id	Full Refresh
18	stages	12		Full Refresh, Incremental	update_time	API Reference
19	files	31	id	Full Refresh, Incremental	update_time	API Reference
20	activity_fields	20		Full Refresh
21	lead_labels	5	id	Full Refresh
22	deal_fields	20		Full Refresh, Incremental	update_time
23	currencies	7	id	Full Refresh		API Reference

Table: person_fields

No	Column Name	Type	Notes
1	bulk_edit_allowed	BOOLEAN
2	edit_flag	BOOLEAN
3	add_visible_flag	BOOLEAN
4	order_nr	INTEGER
5	active_flag	BOOLEAN
6	index_visible_flag	BOOLEAN
7	filtering_allowed	BOOLEAN
8	mandatory_flag	BOOLEAN
9	update_time	VARCHAR	Incremental sync key
10	details_visible_flag	BOOLEAN
11	sortable_flag	BOOLEAN
12	searchable_flag	BOOLEAN
13	name	VARCHAR
14	options	VARCHAR
15	last_updated_by_user_id	INTEGER
16	id	INTEGER
17	field_type	VARCHAR
18	add_time	VARCHAR
19	key	VARCHAR
20	important_flag	BOOLEAN

Table: notes

No	Column Name	Type	Notes
1	deal	VARCHAR
2	active_flag	BOOLEAN
3	last_update_user_id	INTEGER
4	pinned_to_person_flag	BOOLEAN
5	content	VARCHAR
6	pinned_to_deal_flag	BOOLEAN
7	lead	VARCHAR
8	update_time	VARCHAR	Incremental sync key
9	pinned_to_organization_flag	BOOLEAN
10	user_id	INTEGER
11	org_id	INTEGER
12	person	VARCHAR
13	organization	VARCHAR
14	id	INTEGER	Primary Key
15	pinned_to_lead_flag	BOOLEAN
16	deal_id	INTEGER
17	add_time	VARCHAR
18	user	VARCHAR
19	lead_id	INTEGER
20	person_id	INTEGER

Table: roles

No	Column Name	Type	Notes
1	level	INTEGER
2	name	VARCHAR
3	description	VARCHAR
4	parent_role_id	INTEGER
5	active_flag	BOOLEAN
6	id	INTEGER	Primary Key
7	assignment_count	VARCHAR
8	sub_role_count	VARCHAR

Table: product_fields

No	Column Name	Type	Notes
1	bulk_edit_allowed	BOOLEAN
2	edit_flag	BOOLEAN
3	add_visible_flag	BOOLEAN
4	order_nr	INTEGER
5	link	VARCHAR
6	active_flag	BOOLEAN
7	json_column_flag	BOOLEAN
8	use_field	VARCHAR
9	index_visible_flag	BOOLEAN
10	filtering_allowed	BOOLEAN
11	mandatory_flag	BOOLEAN
12	update_time	VARCHAR
13	details_visible_flag	BOOLEAN
14	sortable_flag	BOOLEAN
15	searchable_flag	BOOLEAN
16	name	VARCHAR
17	options	VARCHAR
18	last_updated_by_user_id	INTEGER
19	id	INTEGER	Primary Key
20	field_type	VARCHAR
21	add_time	VARCHAR
22	key	VARCHAR
23	important_flag	BOOLEAN

Table: filters

No	Column Name	Type	Notes
1	update_time	VARCHAR	Incremental sync key
2	custom_view_id	INTEGER
3	user_id	INTEGER
4	visible_to	VARCHAR
5	name	VARCHAR
6	active_flag	BOOLEAN
7	id	INTEGER	Primary Key
8	temporary_flag	VARCHAR
9	type	VARCHAR
10	add_time	VARCHAR

Table: users

No	Column Name	Type	Notes
1	icon_url	VARCHAR
2	signup_flow_variation	VARCHAR
3	is_you	BOOLEAN
4	last_login	VARCHAR
5	created	VARCHAR
6	timezone_offset	VARCHAR
7	active_flag	BOOLEAN
8	locale	VARCHAR
9	is_admin	INTEGER
10	phone	VARCHAR
11	role_id	INTEGER
12	name	VARCHAR
13	timezone_name	VARCHAR
14	modified	VARCHAR	Incremental sync key
15	id	INTEGER
16	has_created_company	BOOLEAN
17	default_currency	VARCHAR
18	lang	INTEGER
19	email	VARCHAR
20	activated	BOOLEAN

Table: deal_products

No	Column Name	Type	Notes
1	sum_formatted	VARCHAR
2	quantity	INTEGER
3	comments	VARCHAR
4	sum_no_discount	INTEGER
5	item_price	INTEGER
6	order_nr	INTEGER
7	product_variation_id	INTEGER
8	sum	INTEGER
9	active_flag	BOOLEAN
10	last_edit	VARCHAR
11	tax	DOUBLE
12	discount_percentage	INTEGER
13	quantity_formatted	VARCHAR
14	duration_unit	VARCHAR
15	enabled_flag	BOOLEAN
16	duration	INTEGER
17	product_id	INTEGER
18	name	VARCHAR
19	currency	VARCHAR
20	id	INTEGER	Primary Key
21	deal_id	INTEGER
22	add_time	VARCHAR

Table: products

No	Column Name	Type	Notes
1	code	VARCHAR
2	files_count	INTEGER
3	owner_name	VARCHAR
4	owner_id	INTEGER
5	selectable	BOOLEAN
6	first_char	VARCHAR
7	description	VARCHAR
8	tax	INTEGER
9	active_flag	BOOLEAN
10	unit	VARCHAR
11	update_time	VARCHAR	Incremental sync key
12	visible_to	VARCHAR
13	followers_count	INTEGER
14	name	VARCHAR
15	id	INTEGER	Primary Key
16	category	VARCHAR
17	prices	VARCHAR
18	add_time	VARCHAR

Table: persons

No	Column Name	Type	Notes
1	related_closed_deals_count	INTEGER
2	email_messages_count	INTEGER
3	owner_id	INTEGER
4	open_deals_count	INTEGER
5	cc_email	VARCHAR
6	last_outgoing_mail_time	VARCHAR
7	active_flag	BOOLEAN
8	picture_id	VARCHAR
9	last_activity_id	INTEGER
10	next_activity_date	VARCHAR
11	update_time	VARCHAR	Incremental sync key
12	participant_open_deals_count	INTEGER
13	activities_count	INTEGER
14	id	INTEGER
15	org_name	VARCHAR
16	first_name	VARCHAR
17	email	VARCHAR
18	won_deals_count	INTEGER
19	files_count	INTEGER
20	owner_name	VARCHAR
21	company_id	INTEGER
22	related_won_deals_count	INTEGER
23	last_incoming_mail_time	VARCHAR
24	undone_activities_count	INTEGER
25	first_char	VARCHAR
26	closed_deals_count	INTEGER
27	last_name	VARCHAR
28	last_activity_date	VARCHAR
29	label	INTEGER
30	related_open_deals_count	INTEGER
31	related_lost_deals_count	INTEGER
32	next_activity_id	INTEGER
33	phone	VARCHAR
34	visible_to	VARCHAR
35	org_id	INTEGER
36	notes_count	INTEGER
37	followers_count	INTEGER
38	name	VARCHAR
39	participant_closed_deals_count	INTEGER
40	lost_deals_count	INTEGER
41	next_activity_time	VARCHAR
42	add_time	VARCHAR
43	done_activities_count	INTEGER

Table: organization_fields

No	Column Name	Type	Notes
1	bulk_edit_allowed	BOOLEAN
2	edit_flag	BOOLEAN
3	add_visible_flag	BOOLEAN
4	order_nr	INTEGER
5	active_flag	BOOLEAN
6	index_visible_flag	BOOLEAN
7	filtering_allowed	BOOLEAN
8	mandatory_flag	BOOLEAN
9	update_time	VARCHAR	Incremental sync key
10	details_visible_flag	BOOLEAN
11	sortable_flag	BOOLEAN
12	searchable_flag	BOOLEAN
13	name	VARCHAR
14	options	VARCHAR
15	last_updated_by_user_id	INTEGER
16	id	INTEGER
17	field_type	VARCHAR
18	add_time	VARCHAR
19	key	VARCHAR
20	important_flag	BOOLEAN

Table: pipelines

No	Column Name	Type	Notes
1	update_time	VARCHAR	Incremental sync key
2	url_title	VARCHAR
3	order_nr	INTEGER
4	name	VARCHAR
5	active	BOOLEAN
6	deal_probability	BOOLEAN
7	id	INTEGER
8	add_time	VARCHAR
9	selected	BOOLEAN

Table: leads

No	Column Name	Type	Notes
1	expected_close_date	VARCHAR
2	owner_id	INTEGER
3	label_ids	VARCHAR
4	was_seen	BOOLEAN
5	title	VARCHAR
6	next_activity_id	INTEGER
7	update_time	VARCHAR
8	is_archived	BOOLEAN
9	organization_id	INTEGER
10	creator_id	INTEGER
11	id	VARCHAR
12	value	VARCHAR
13	add_time	VARCHAR
14	source_name	VARCHAR
15	person_id	INTEGER

Table: activities

No	Column Name	Type	Notes
1	last_notification_time	VARCHAR
2	location_street_number	VARCHAR
3	type_name	VARCHAR
4	reference_id	INTEGER
5	public_description	VARCHAR
6	location_route	VARCHAR
7	notification_language_id	INTEGER
8	subject	VARCHAR
9	type	VARCHAR
10	google_calendar_etag	VARCHAR
11	google_calendar_id	VARCHAR
12	deal_title	VARCHAR
13	id	INTEGER
14	deal_id	INTEGER
15	gcal_event_id	VARCHAR
16	location_lat	DOUBLE
17	busy_flag	BOOLEAN
18	person_id	INTEGER
19	location_long	DOUBLE
20	owner_name	VARCHAR
21	attendees	VARCHAR
22	person_name	VARCHAR
23	rec_rule_extension	VARCHAR
24	done	BOOLEAN
25	created_by_user_id	INTEGER
26	location_sublocality	VARCHAR
27	rec_rule	VARCHAR
28	location_admin_area_level_2	VARCHAR
29	user_id	INTEGER
30	location_admin_area_level_1	VARCHAR
31	org_id	INTEGER
32	conference_meeting_client	VARCHAR
33	due_time	VARCHAR
34	rec_master_activity_id	INTEGER
35	note	VARCHAR
36	location_country	VARCHAR
37	active_flag	BOOLEAN
38	duration	VARCHAR
39	location_postal_code	VARCHAR
40	update_time	VARCHAR	Incremental sync key
41	file	VARCHAR
42	update_user_id	INTEGER
43	source_timezone	VARCHAR
44	conference_meeting_id	VARCHAR
45	person_dropbox_bcc	VARCHAR
46	location_locality	VARCHAR
47	org_name	VARCHAR
48	assigned_to_user_id	INTEGER
49	lead_id	VARCHAR
50	participants	VARCHAR
51	location_subpremise	VARCHAR
52	company_id	INTEGER
53	due_date	VARCHAR
54	reference_type	VARCHAR
55	last_notification_user_id	INTEGER
56	calendar_sync_include_context	BOOLEAN
57	marked_as_done_time	VARCHAR
58	location_formatted_address	VARCHAR
59	conference_meeting_url	VARCHAR
60	series	VARCHAR
61	location	VARCHAR
62	deal_dropbox_bcc	VARCHAR
63	add_time	VARCHAR

Table: activity_types

No	Column Name	Type	Notes
1	icon_key	VARCHAR
2	update_time	VARCHAR	Incremental sync key
3	is_custom_flag	BOOLEAN
4	key_string	VARCHAR
5	color	VARCHAR
6	order_nr	INTEGER
7	name	VARCHAR
8	active_flag	BOOLEAN
9	id	INTEGER	Primary Key
10	add_time	VARCHAR

Table: deals

No	Column Name	Type	Notes
1	email_messages_count	INTEGER
2	cc_email	VARCHAR
3	products_count	INTEGER
4	next_activity_date	VARCHAR
5	next_activity_type	VARCHAR
6	next_activity_duration	VARCHAR
7	id	INTEGER
8	person_id	INTEGER
9	creator_user_id	INTEGER
10	expected_close_date	VARCHAR
11	participants_count	INTEGER
12	owner_name	VARCHAR
13	stage_id	INTEGER
14	probability	DOUBLE
15	undone_activities_count	INTEGER
16	active	BOOLEAN
17	last_activity_date	VARCHAR
18	person_name	VARCHAR
19	close_time	VARCHAR
20	next_activity_id	INTEGER
21	weighted_value_currency	VARCHAR
22	org_hidden	BOOLEAN
23	stage_order_nr	INTEGER
24	next_activity_subject	VARCHAR
25	rotten_time	VARCHAR
26	user_id	INTEGER
27	visible_to	VARCHAR
28	org_id	INTEGER
29	notes_count	INTEGER
30	next_activity_time	VARCHAR
31	formatted_value	VARCHAR
32	status	VARCHAR
33	formatted_weighted_value	VARCHAR
34	first_won_time	VARCHAR
35	last_outgoing_mail_time	VARCHAR
36	title	VARCHAR
37	last_activity_id	INTEGER
38	update_time	VARCHAR	Incremental sync key
39	activities_count	INTEGER
40	pipeline_id	INTEGER
41	lost_time	VARCHAR
42	currency	VARCHAR
43	weighted_value	DOUBLE
44	org_name	VARCHAR
45	value	DOUBLE
46	next_activity_note	VARCHAR
47	person_hidden	BOOLEAN
48	files_count	INTEGER
49	last_incoming_mail_time	VARCHAR
50	label	VARCHAR
51	lost_reason	VARCHAR
52	deleted	BOOLEAN
53	won_time	VARCHAR
54	followers_count	INTEGER
55	stage_change_time	VARCHAR
56	add_time	VARCHAR
57	done_activities_count	INTEGER

Table: organizations

No	Column Name	Type	Notes
1	related_closed_deals_count	DOUBLE
2	address_route	VARCHAR
3	email_messages_count	DOUBLE
4	owner_id	VARCHAR
5	open_deals_count	DOUBLE
6	cc_email	VARCHAR
7	active_flag	BOOLEAN
8	picture_id	VARCHAR
9	people_count	DOUBLE
10	last_activity_id	DOUBLE
11	next_activity_date	VARCHAR
12	update_time	VARCHAR	Incremental sync key
13	activities_count	DOUBLE
14	id	DOUBLE
15	address_admin_area_level_2	VARCHAR
16	won_deals_count	DOUBLE
17	address_admin_area_level_1	VARCHAR
18	address_street_number	VARCHAR
19	files_count	DOUBLE
20	address	VARCHAR
21	owner_name	VARCHAR
22	company_id	DOUBLE
23	address_formatted_address	VARCHAR
24	related_won_deals_count	DOUBLE
25	address_postal_code	VARCHAR
26	address_country	VARCHAR
27	undone_activities_count	DOUBLE
28	first_char	VARCHAR
29	closed_deals_count	DOUBLE
30	last_activity_date	VARCHAR
31	address_subpremise	VARCHAR
32	label	DOUBLE
33	related_open_deals_count	DOUBLE
34	related_lost_deals_count	DOUBLE
35	next_activity_id	DOUBLE
36	country_code	VARCHAR
37	visible_to	DOUBLE
38	notes_count	DOUBLE
39	followers_count	DOUBLE
40	name	VARCHAR
41	address_sublocality	VARCHAR
42	address_locality	VARCHAR
43	lost_deals_count	DOUBLE
44	next_activity_time	VARCHAR
45	add_time	VARCHAR
46	done_activities_count	DOUBLE

Table: permission_sets

No	Column Name	Type	Notes
1	app	VARCHAR
2	name	VARCHAR
3	id	VARCHAR	Primary Key
4	type	VARCHAR
5	assignment_count	INTEGER

Table: stages

No	Column Name	Type	Notes
1	update_time	VARCHAR	Incremental sync key
2	pipeline_deal_probability	BOOLEAN
3	order_nr	INTEGER
4	name	VARCHAR
5	pipeline_id	INTEGER
6	deal_probability	INTEGER
7	active_flag	BOOLEAN
8	rotten_flag	BOOLEAN
9	id	INTEGER
10	add_time	VARCHAR
11	rotten_days	INTEGER
12	pipeline_name	VARCHAR

Table: files

No	Column Name	Type	Notes
1	description	VARCHAR
2	active_flag	BOOLEAN
3	lead_name	VARCHAR
4	s3_bucket	VARCHAR
5	update_time	VARCHAR	Incremental sync key
6	inline_flag	BOOLEAN
7	file_type	VARCHAR
8	product_id	INTEGER
9	activity_id	INTEGER
10	id	INTEGER	Primary Key
11	remote_location	VARCHAR
12	people_name	VARCHAR
13	deal_id	INTEGER
14	org_name	VARCHAR
15	mail_template_id	INTEGER
16	lead_id	INTEGER
17	person_id	INTEGER
18	log_id	INTEGER
19	file_name	VARCHAR
20	mail_message_id	INTEGER
21	remote_id	VARCHAR
22	person_name	VARCHAR
23	product_name	VARCHAR
24	file_size	INTEGER
25	url	VARCHAR
26	user_id	INTEGER
27	org_id	INTEGER
28	deal_name	VARCHAR
29	name	VARCHAR
30	add_time	VARCHAR
31	cid	INTEGER

Table: activity_fields

No	Column Name	Type	Notes
1	bulk_edit_allowed	BOOLEAN
2	edit_flag	BOOLEAN
3	add_visible_flag	BOOLEAN
4	order_nr	INTEGER
5	active_flag	BOOLEAN
6	index_visible_flag	BOOLEAN
7	filtering_allowed	BOOLEAN
8	mandatory_flag	BOOLEAN
9	update_time	VARCHAR
10	details_visible_flag	BOOLEAN
11	sortable_flag	BOOLEAN
12	searchable_flag	BOOLEAN
13	name	VARCHAR
14	options	VARCHAR
15	last_updated_by_user_id	INTEGER
16	id	INTEGER
17	field_type	VARCHAR
18	add_time	VARCHAR
19	key	VARCHAR
20	important_flag	BOOLEAN

Table: lead_labels

No	Column Name	Type	Notes
1	update_time	VARCHAR
2	color	VARCHAR
3	name	VARCHAR
4	id	VARCHAR	Primary Key
5	add_time	VARCHAR

Table: deal_fields

No	Column Name	Type	Notes
1	bulk_edit_allowed	BOOLEAN
2	edit_flag	BOOLEAN
3	add_visible_flag	BOOLEAN
4	order_nr	INTEGER
5	active_flag	BOOLEAN
6	index_visible_flag	BOOLEAN
7	filtering_allowed	BOOLEAN
8	mandatory_flag	VARCHAR
9	update_time	VARCHAR	Incremental sync key
10	details_visible_flag	BOOLEAN
11	sortable_flag	BOOLEAN
12	searchable_flag	BOOLEAN
13	name	VARCHAR
14	options	VARCHAR
15	last_updated_by_user_id	INTEGER
16	id	INTEGER
17	field_type	VARCHAR
18	add_time	VARCHAR
19	key	VARCHAR
20	important_flag	BOOLEAN

Table: currencies

No	Column Name	Type	Notes
1	symbol	VARCHAR
2	decimal_points	INTEGER
3	code	VARCHAR
4	is_custom_flag	BOOLEAN
5	name	VARCHAR
6	active_flag	BOOLEAN
7	id	INTEGER	Primary Key

External Resources

• Enabling Api For Company Users
• How To Find The Api Token
• Instructions
• Activityfields
• Activitytypes
• Dealfields
• Dealproducts
• Leadlabels
• Organizationfields
• Permissionsets
• Personfields
• Productfields
• The Pipedrive Docs For Rate Limitations

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.