Salesloft

Prerequisites

• Salesloft Account
• Start date

Setting up the Salesloft connector

No	Item	Required	Example	Notes
1	Credentials	Yes
2	Start Date	Yes	2020-11-16T00:00:00Z	The date from which you'd like to replicate data for Salesloft API, in the format YYYY-MM-DDT00:00:00Z. All data generated after this date will be replicated.

Tables in the Salesloft connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	cadence_memberships	12	id	Full Refresh, Incremental	updated_at
2	crm_users	5	id	Full Refresh
3	notes	7	id	Full Refresh, Incremental	updated_at	API Reference
4	import	6	id	Full Refresh
5	account_stages	5	id	Full Refresh, Incremental
6	groups	3	id	Full Refresh		API Reference
7	email_templates	19	id	Full Refresh, Incremental
8	email_template_attachments	6	id	Full Refresh
9	steps	11	id	Full Refresh		API Reference
10	people	50	id	Full Refresh, Incremental	updated_at	API Reference
11	users	32	id	Full Refresh		API Reference
12	emails	21	id	Full Refresh, Incremental	updated_at	API Reference
13	account_tiers	5	id	Full Refresh
14	successes	13	id	Full Refresh, Incremental	updated_at	API Reference
15	crm_activities	11	id	Full Refresh, Incremental	updated_at
16	phone_number_assignments	3	id	Full Refresh
17	team_template_attachments	6	id	Full Refresh
18	calls	14	id	Full Refresh, Incremental	updated_at	API Reference
19	person_stages	5	id	Full Refresh
20	team_templates	16	id	Full Refresh, Incremental
21	cadences	18	id	Full Refresh, Incremental	updated_at	API Reference
22	accounts	38	id	Full Refresh, Incremental	updated_at	API Reference
23	actions	13	id	Full Refresh, Incremental	updated_at	API Reference

Table: cadence_memberships

No	Column Name	Type	Notes
1	added_at	VARCHAR
2	updated_at	VARCHAR	Incremental sync key
3	person_deleted	BOOLEAN
4	currently_on_cadence	BOOLEAN
5	person	VARCHAR
6	counts	VARCHAR
7	current_state	VARCHAR
8	latest_action	VARCHAR
9	created_at	VARCHAR
10	id	INTEGER	Primary Key
11	user	VARCHAR
12	cadence	VARCHAR

Table: crm_users

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	crm_id	VARCHAR
3	created_at	VARCHAR
4	id	INTEGER	Primary Key
5	user	VARCHAR

Table: notes

No	Column Name	Type	Notes
1	call	VARCHAR
2	updated_at	VARCHAR	Incremental sync key
3	associated_with	VARCHAR
4	created_at	VARCHAR
5	id	INTEGER	Primary Key
6	user	VARCHAR
7	content	VARCHAR

Table: import

No	Column Name	Type	Notes
1	current_people_count	INTEGER
2	updated_at	VARCHAR
3	name	VARCHAR
4	created_at	VARCHAR
5	id	INTEGER	Primary Key
6	imported_people_count	INTEGER

Table: account_stages

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

Table: groups

No	Column Name	Type	Notes
1	parent_id	INTEGER
2	name	VARCHAR
3	id	INTEGER	Primary Key

Table: email_templates

No	Column Name	Type	Notes
1	shared	BOOLEAN
2	archived_at	VARCHAR
3	_links	VARCHAR
4	subject	VARCHAR
5	counts	VARCHAR
6	body_preview	VARCHAR
7	cadence_template	BOOLEAN
8	created_at	VARCHAR
9	groups	VARCHAR
10	title	VARCHAR
11	body	VARCHAR
12	tags	VARCHAR
13	last_used_at	VARCHAR
14	updated_at	VARCHAR
15	template_owner	VARCHAR
16	open_tracking_enabled	BOOLEAN
17	id	INTEGER	Primary Key
18	click_tracking_enabled	BOOLEAN
19	team_template	VARCHAR

Table: email_template_attachments

No	Column Name	Type	Notes
1	attachment_file_size	INTEGER
2	attachment_id	INTEGER
3	name	VARCHAR
4	download_url	VARCHAR
5	id	INTEGER	Primary Key
6	team_template	VARCHAR

Table: steps

No	Column Name	Type	Notes
1	step_number	INTEGER
2	updated_at	VARCHAR
3	name	VARCHAR
4	created_at	VARCHAR
5	disabled	BOOLEAN
6	details	VARCHAR
7	id	INTEGER	Primary Key
8	type	VARCHAR
9	display_name	VARCHAR
10	day	INTEGER
11	cadence	VARCHAR

Table: people

No	Column Name	Type	Notes
1	country	VARCHAR
2	counts	VARCHAR
3	person_stage	VARCHAR
4	most_recent_cadence	VARCHAR
5	contact_restrictions	VARCHAR
6	twitter_handle	VARCHAR
7	work_state	VARCHAR
8	last_replied_at	VARCHAR
9	personal_website	VARCHAR
10	id	INTEGER	Primary Key
11	phone_extension	VARCHAR
12	state	VARCHAR
13	person_company_website	VARCHAR
14	home_phone	VARCHAR
15	work_city	VARCHAR
16	last_completed_step_cadence	VARCHAR
17	custom_fields	VARCHAR
18	last_contacted_at	VARCHAR
19	owner_crm_id	VARCHAR
20	display_name	VARCHAR
21	bouncing	BOOLEAN
22	tags	VARCHAR
23	crm_url	VARCHAR
24	phone	VARCHAR
25	last_completed_step	VARCHAR
26	person_company_name	VARCHAR
27	linkedin_url	VARCHAR
28	secondary_email_address	VARCHAR
29	do_not_contact	BOOLEAN
30	import	VARCHAR
31	city	VARCHAR
32	last_contacted_type	VARCHAR
33	created_at	VARCHAR
34	title	VARCHAR
35	locale	VARCHAR
36	updated_at	VARCHAR	Incremental sync key
37	mobile_phone	VARCHAR
38	work_country	VARCHAR
39	first_name	VARCHAR
40	owner	VARCHAR
41	personal_email_address	VARCHAR
42	last_name	VARCHAR
43	job_seniority	VARCHAR
44	crm_object_type	VARCHAR
45	full_email_address	VARCHAR
46	email_address	VARCHAR
47	crm_id	VARCHAR
48	last_contacted_by	VARCHAR
49	person_company_industry	VARCHAR
50	account	VARCHAR

Table: users

No	Column Name	Type	Notes
1	job_role	VARCHAR
2	role	VARCHAR
3	email_signature_click_tracking_disabled	BOOLEAN
4	phone_client	VARCHAR
5	click_to_call_enabled	BOOLEAN
6	created_at	VARCHAR
7	crm_connected	BOOLEAN
8	slack_username	VARCHAR
9	twitter_handle	VARCHAR
10	email_client_configured	BOOLEAN
11	updated_at	VARCHAR
12	email_signature_type	VARCHAR
13	id	INTEGER	Primary Key
14	first_name	VARCHAR
15	from_address	VARCHAR
16	email	VARCHAR
17	group	VARCHAR
18	phone_number_assignment	VARCHAR
19	email_client_email_address	VARCHAR
20	last_name	VARCHAR
21	active	BOOLEAN
22	email_signature	VARCHAR
23	external_feature_flags	VARCHAR
24	team	VARCHAR
25	time_zone	VARCHAR
26	full_email_address	VARCHAR
27	bcc_email_address	VARCHAR
28	team_admin	BOOLEAN
29	local_dial_enabled	BOOLEAN
30	name	VARCHAR
31	guid	VARCHAR
32	sending_email_address	VARCHAR

Table: emails

No	Column Name	Type	Notes
1	headers	VARCHAR
2	recipient_email_address	VARCHAR
3	click_tracking	BOOLEAN
4	counts	VARCHAR
5	created_at	VARCHAR
6	bounced	BOOLEAN
7	mailing	VARCHAR
8	view_tracking	BOOLEAN
9	cadence	VARCHAR
10	sent_at	VARCHAR
11	crm_activity	VARCHAR
12	personalization	VARCHAR
13	updated_at	VARCHAR	Incremental sync key
14	send_after	VARCHAR
15	recipient	VARCHAR
16	action	VARCHAR
17	step	VARCHAR
18	id	INTEGER	Primary Key
19	user	VARCHAR
20	email_template	VARCHAR
21	status	VARCHAR

Table: account_tiers

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

Table: successes

No	Column Name	Type	Notes
1	success_window_started_at	VARCHAR
2	latest_call	VARCHAR
3	latest_cadence	VARCHAR
4	counts	VARCHAR
5	created_at	VARCHAR
6	succeeded_at	VARCHAR
7	latest_step	VARCHAR
8	updated_at	VARCHAR	Incremental sync key
9	person	VARCHAR
10	latest_action	VARCHAR
11	id	INTEGER	Primary Key
12	user	VARCHAR
13	latest_email	VARCHAR

Table: crm_activities

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	crm_id	VARCHAR
3	subject	VARCHAR
4	person	VARCHAR
5	activity_type	VARCHAR
6	created_at	VARCHAR
7	description	VARCHAR
8	custom_crm_fields	VARCHAR
9	id	INTEGER	Primary Key
10	error	VARCHAR
11	user	VARCHAR

Table: phone_number_assignments

No	Column Name	Type	Notes
1	number	VARCHAR
2	id	INTEGER	Primary Key
3	user	VARCHAR

Table: team_template_attachments

No	Column Name	Type	Notes
1	attachment_file_size	INTEGER
2	attachment_id	INTEGER
3	name	VARCHAR
4	download_url	VARCHAR
5	id	INTEGER	Primary Key
6	team_template	VARCHAR

Table: calls

No	Column Name	Type	Notes
1	sentiment	VARCHAR
2	note	VARCHAR
3	created_at	VARCHAR
4	called_person	VARCHAR
5	cadence	VARCHAR
6	duration	INTEGER
7	crm_activity	VARCHAR
8	disposition	VARCHAR
9	updated_at	VARCHAR	Incremental sync key
10	action	VARCHAR
11	step	VARCHAR
12	id	INTEGER	Primary Key
13	to	VARCHAR
14	user	VARCHAR

Table: person_stages

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

Table: team_templates

No	Column Name	Type	Notes
1	last_modified_user	VARCHAR
2	archived_at	VARCHAR
3	_links	VARCHAR
4	subject	VARCHAR
5	counts	VARCHAR
6	body_preview	VARCHAR
7	created_at	VARCHAR
8	title	VARCHAR
9	body	VARCHAR
10	last_modified_at	VARCHAR
11	tags	VARCHAR
12	last_used_at	VARCHAR
13	updated_at	VARCHAR
14	open_tracking_enabled	BOOLEAN
15	id	VARCHAR	Primary Key
16	click_tracking_enabled	BOOLEAN

Table: cadences

No	Column Name	Type	Notes
1	opt_out_link_included	BOOLEAN
2	owner	VARCHAR
3	shared	BOOLEAN
4	creator	VARCHAR
5	archived_at	VARCHAR
6	counts	VARCHAR
7	finished_stage	VARCHAR
8	remove_bounces_enabled	BOOLEAN
9	created_at	VARCHAR
10	tags	VARCHAR
11	replied_stage	VARCHAR
12	team_cadence	BOOLEAN
13	updated_at	VARCHAR	Incremental sync key
14	name	VARCHAR
15	id	INTEGER	Primary Key
16	bounced_stage	VARCHAR
17	remove_replies_enabled	BOOLEAN
18	added_stage	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	country	VARCHAR
2	company_type	VARCHAR
3	do_not_contact	BOOLEAN
4	city	VARCHAR
5	counts	VARCHAR
6	last_contacted_type	VARCHAR
7	created_at	VARCHAR
8	description	VARCHAR
9	industry	VARCHAR
10	locale	VARCHAR
11	twitter_handle	VARCHAR
12	revenue_range	VARCHAR
13	last_contacted_person	VARCHAR
14	updated_at	VARCHAR	Incremental sync key
15	street	VARCHAR
16	id	INTEGER	Primary Key
17	state	VARCHAR
18	owner	VARCHAR
19	company_stage	VARCHAR
20	website	VARCHAR
21	creator	VARCHAR
22	archived_at	VARCHAR
23	founded	VARCHAR
24	crm_object_type	VARCHAR
25	last_contacted_at	VARCHAR
26	owner_crm_id	VARCHAR
27	tags	VARCHAR
28	crm_url	VARCHAR
29	size	VARCHAR
30	phone	VARCHAR
31	crm_id	VARCHAR
32	last_contacted_by	VARCHAR
33	domain	VARCHAR
34	name	VARCHAR
35	account_tier	VARCHAR
36	linkedin_url	VARCHAR
37	postal_code	VARCHAR
38	conversational_name	VARCHAR

Table: actions

No	Column Name	Type	Notes
1	multitouch_group_id	INTEGER
2	created_at	VARCHAR
3	type	VARCHAR
4	due_on	VARCHAR
5	cadence	VARCHAR
6	action_details	VARCHAR
7	updated_at	VARCHAR	Incremental sync key
8	due	BOOLEAN
9	person	VARCHAR
10	step	VARCHAR
11	id	INTEGER	Primary Key
12	user	VARCHAR
13	status	VARCHAR

External Resources

• Api Key Authentication
• Salesloft Account
• Salesloft
• Api Key
• Cadencememberships
• Account Stages
• Account Tiers
• Emails Templates
• Emails Template Attachements
• Imports
• Person Stages
• Phone Number Assignments
• Team Templates
• Team Template Attachements
• Crm Activities
• Crm Users
• Rate Limits

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.