Hubspot

Prerequisites

You can use OAuth, API key, or Private App to authenticate your HubSpot account. If you choose to use OAuth or Private App, you need to configure the appropriate scopes for the following streams:

Stream	Required Scope
campaigns	content
companies	crm.objects.companies.read, crm.schemas.companies.read
contact_lists	crm.objects.lists.read
contacts	crm.objects.contacts.read
contacts_list_memberships	crm.objects.contacts.read
deal_pipelines	either the crm.objects.contacts.read scope (to fetch deals pipelines) or the tickets scope.
deals	crm.objects.deals.read, crm.schemas.deals.read
email_events	content
engagements	crm.objects.companies.read, crm.objects.contacts.read, crm.objects.deals.read, tickets, e-commerce
engagements_emails	sales-email-read
forms	forms
form_submissions	forms
line_items	e-commerce
owners	crm.objects.owners.read
products	e-commerce
property_history	crm.objects.contacts.read
subscription_changes	content
tickets	tickets
workflows	automation

Tables in the Hubspot connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	tickets	7				API Reference
2	marketing_emails	85
3	ticket_pipelines	6
4	property_history	9
5	owners	9				API Reference
6	workflows	8				API Reference
7	line_items	4
8	email_events	39
9	products	4				API Reference
10	companies	5				API Reference
11	campaigns	12				API Reference
12	engagements_tasks	9
13	engagements	23				API Reference
14	deal_pipelines	10
15	engagements_meetings	9
16	form_submissions	5
17	contact_lists	14
18	subscription_changes	4
19	engagements_calls	9
20	feedback_submissions	7
21	engagements_notes	9
22	contacts_list_memberships	6
23	deals	8				API Reference
24	engagements_emails	9
25	forms	10				API Reference
26	contacts	5				API Reference

Table: tickets

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	companies	VARCHAR
4	deals	VARCHAR
5	id	VARCHAR
6	contacts	VARCHAR
7	updatedAt	VARCHAR

Table: marketing_emails

No	Column Name	Type	Notes
1	emailBody	VARCHAR
2	subject	VARCHAR
3	absoluteUrl	VARCHAR
4	vidsIncluded	VARCHAR
5	publishDate	INTEGER
6	canSpamSettingsId	INTEGER
7	metaDescription	VARCHAR
8	isLocalTimezoneSend	BOOLEAN
9	authorUserId	INTEGER
10	unpublishedAt	INTEGER
11	htmlTitle	VARCHAR
12	publishImmediately	BOOLEAN
13	emailType	VARCHAR
14	stats	VARCHAR
15	fromName	VARCHAR
16	publishedUrl	VARCHAR
17	id	INTEGER
18	state	VARCHAR
19	primaryEmailCampaignId	INTEGER
20	createdById	INTEGER
21	selected	INTEGER
22	slug	VARCHAR
23	clonedFrom	INTEGER
24	ab	BOOLEAN
25	freezeDate	INTEGER
26	isGraymailSuppressionEnabled	BOOLEAN
27	currentlyPublished	BOOLEAN
28	abVariation	BOOLEAN
29	created	INTEGER
30	publishedById	INTEGER
31	contentTypeCategory	INTEGER
32	updatedById	INTEGER
33	folderId	INTEGER
34	createPage	BOOLEAN
35	processingStatus	VARCHAR
36	abSamplingDefault	VARCHAR
37	leadFlowId	INTEGER
38	analyticsPageId	VARCHAR
39	customReplyTo	VARCHAR
40	authorName	VARCHAR
41	domain	VARCHAR
42	name	VARCHAR
43	replyTo	VARCHAR
44	campaign	VARCHAR
45	subcategory	VARCHAR
46	analyticsPageType	VARCHAR
47	updated	INTEGER
48	abSuccessMetric	VARCHAR
49	transactional	BOOLEAN
50	vidsExcluded	VARCHAR
51	feedbackSurveyId	INTEGER
52	abSampleSizeDefault	VARCHAR
53	abTestPercentage	INTEGER
54	subscription	INTEGER
55	resolvedDomain	VARCHAR
56	emailNote	VARCHAR
57	archived	BOOLEAN
58	blogEmailType	VARCHAR
59	publishedByName	VARCHAR
60	abStatus	VARCHAR
61	liveDomain	VARCHAR
62	portalId	INTEGER
63	emailbodyPlaintext	VARCHAR
64	allEmailCampaignIds	VARCHAR
65	isRecipientFatigueSuppressionEnabled	BOOLEAN
66	emailTemplateMode	VARCHAR
67	feedbackEmailCategory	VARCHAR
68	isPublished	BOOLEAN
69	mailingListsIncluded	VARCHAR
70	customReplyToEnabled	BOOLEAN
71	pageExpiryEnabled	BOOLEAN
72	templatePath	VARCHAR
73	url	VARCHAR
74	maxRssEntries	INTEGER
75	mailingListsExcluded	VARCHAR
76	previewKey	VARCHAR
77	authorAt	INTEGER
78	subscriptionName	VARCHAR
79	abHoursToWait	INTEGER
80	pageRedirected	BOOLEAN
81	currentState	VARCHAR
82	campaignName	VARCHAR
83	categoryId	INTEGER
84	smartEmailFields	VARCHAR
85	useRssHeadlineAsSubject	BOOLEAN

Table: ticket_pipelines

No	Column Name	Type	Notes
1	archived	BOOLEAN
2	createdAt	VARCHAR
3	stages	VARCHAR
4	label	VARCHAR
5	id	VARCHAR
6	updatedAt	VARCHAR

Table: property_history

No	Column Name	Type	Notes
1	updated-by-user-id	INTEGER
2	vid	INTEGER
3	source-label	VARCHAR
4	source-type	VARCHAR
5	property	VARCHAR
6	value	VARCHAR
7	source-id	VARCHAR
8	selected	BOOLEAN
9	timestamp	INTEGER

Table: owners

No	Column Name	Type	Notes
1	firstName	VARCHAR
2	lastName	VARCHAR
3	createdAt	VARCHAR
4	archived	BOOLEAN
5	teams	VARCHAR
6	id	VARCHAR
7	userId	INTEGER
8	email	VARCHAR
9	updatedAt	VARCHAR

Table: workflows

No	Column Name	Type	Notes
1	contactListIds	VARCHAR
2	insertedAt	INTEGER
3	name	VARCHAR
4	id	INTEGER
5	type	VARCHAR
6	personaTagIds	VARCHAR
7	enabled	BOOLEAN
8	updatedAt	INTEGER

Table: line_items

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	id	VARCHAR
4	updatedAt	VARCHAR

Table: email_events

No	Column Name	Type	Notes
1	sourceId	VARCHAR
2	portalSubscriptionStatus	VARCHAR
3	referer	VARCHAR
4	dropMessage	VARCHAR
5	subject	VARCHAR
6	source	VARCHAR
7	type	VARCHAR
8	attempt	INTEGER
9	sentBy	VARCHAR
10	duration	INTEGER
11	hmid	VARCHAR
12	obsoletedBy	VARCHAR
13	filteredEvent	BOOLEAN
14	appId	INTEGER
15	browser	VARCHAR
16	portalId	INTEGER
17	from	VARCHAR
18	id	VARCHAR
19	deviceType	VARCHAR
20	smtpId	VARCHAR
21	dropReason	VARCHAR
22	appName	VARCHAR
23	created	INTEGER
24	requestedByUserId	INTEGER
25	ipAddress	VARCHAR
26	causedBy	VARCHAR
27	userAgent	VARCHAR
28	bounced	BOOLEAN
29	emailCampaignGroupId	INTEGER
30	url	VARCHAR
31	requestedBy	VARCHAR
32	linkId	INTEGER
33	response	VARCHAR
34	recipient	VARCHAR
35	replyTo	VARCHAR
36	location	VARCHAR
37	emailCampaignId	INTEGER
38	category	VARCHAR
39	status	VARCHAR

Table: products

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	id	VARCHAR
4	updatedAt	VARCHAR

Table: companies

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	id	VARCHAR
4	contacts	VARCHAR
5	updatedAt	VARCHAR

Table: campaigns

No	Column Name	Type	Notes
1	counters	VARCHAR
2	appName	VARCHAR
3	numIncluded	INTEGER
4	subject	VARCHAR
5	appId	INTEGER
6	contentId	INTEGER
7	name	VARCHAR
8	numQueued	INTEGER
9	subType	VARCHAR
10	lastUpdatedTime	INTEGER
11	id	INTEGER
12	type	VARCHAR

Table: engagements_tasks

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	companies	VARCHAR
4	tickets	VARCHAR
5	deals	VARCHAR
6	id	VARCHAR
7	properties	VARCHAR
8	contacts	VARCHAR
9	updatedAt	VARCHAR

Table: engagements

No	Column Name	Type	Notes
1	sourceId	VARCHAR
2	associations	VARCHAR
3	metadata	VARCHAR
4	attachments	VARCHAR
5	bodyPreviewIsTruncated	BOOLEAN
6	active	BOOLEAN
7	bodyPreview	VARCHAR
8	source	VARCHAR
9	ownerId	INTEGER
10	type	VARCHAR
11	bodyPreviewHtml	VARCHAR
12	uid	VARCHAR
13	createdAt	INTEGER
14	lastUpdated	INTEGER
15	createdBy	INTEGER
16	teamId	INTEGER
17	portalId	INTEGER
18	gdprDeleted	BOOLEAN
19	modifiedBy	INTEGER
20	id	INTEGER
21	activityType	VARCHAR
22	timestamp	INTEGER
23	allAccessibleTeamIds	VARCHAR

Table: deal_pipelines

No	Column Name	Type	Notes
1	createdAt	INTEGER
2	default	BOOLEAN
3	objectTypeId	VARCHAR
4	displayOrder	INTEGER
5	stages	VARCHAR
6	active	BOOLEAN
7	label	VARCHAR
8	objectType	VARCHAR
9	pipelineId	VARCHAR
10	updatedAt	INTEGER

Table: engagements_meetings

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	companies	VARCHAR
4	tickets	VARCHAR
5	deals	VARCHAR
6	id	VARCHAR
7	properties	VARCHAR
8	contacts	VARCHAR
9	updatedAt	VARCHAR

Table: form_submissions

No	Column Name	Type	Notes
1	formId	VARCHAR
2	values	VARCHAR
3	pageUrl	VARCHAR
4	submittedAt	INTEGER
5	updatedAt	INTEGER

Table: contact_lists

No	Column Name	Type	Notes
1	readOnly	BOOLEAN
2	filters	VARCHAR
3	internalListId	INTEGER
4	listType	VARCHAR
5	parentId	INTEGER
6	listId	INTEGER
7	metaData	VARCHAR
8	createdAt	INTEGER
9	archived	BOOLEAN
10	deleteable	BOOLEAN
11	portalId	INTEGER
12	name	VARCHAR
13	dynamic	BOOLEAN
14	updatedAt	INTEGER

Table: subscription_changes

No	Column Name	Type	Notes
1	portalId	INTEGER
2	recipient	VARCHAR
3	changes	VARCHAR
4	timestamp	INTEGER

Table: engagements_calls

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	companies	VARCHAR
4	tickets	VARCHAR
5	deals	VARCHAR
6	id	VARCHAR
7	properties	VARCHAR
8	contacts	VARCHAR
9	updatedAt	VARCHAR

Table: feedback_submissions

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	archivedAt	VARCHAR
4	id	VARCHAR
5	properties	VARCHAR
6	contacts	VARCHAR
7	updatedAt	VARCHAR

Table: engagements_notes

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	companies	VARCHAR
4	tickets	VARCHAR
5	deals	VARCHAR
6	id	VARCHAR
7	properties	VARCHAR
8	contacts	VARCHAR
9	updatedAt	VARCHAR

Table: contacts_list_memberships

No	Column Name	Type	Notes
1	vid	INTEGER
2	internal-list-id	INTEGER
3	canonical-vid	INTEGER
4	is-member	BOOLEAN
5	static-list-id	INTEGER
6	timestamp	INTEGER

Table: deals

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	companies	VARCHAR
4	id	VARCHAR
5	line_items	VARCHAR
6	properties	VARCHAR
7	contacts	VARCHAR
8	updatedAt	VARCHAR

Table: engagements_emails

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	companies	VARCHAR
4	tickets	VARCHAR
5	deals	VARCHAR
6	id	VARCHAR
7	properties	VARCHAR
8	contacts	VARCHAR
9	updatedAt	VARCHAR

Table: forms

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	fieldGroups	VARCHAR
4	deletedAt	VARCHAR
5	configuration	VARCHAR
6	name	VARCHAR
7	id	VARCHAR
8	legalConsentOptions	VARCHAR
9	updatedAt	VARCHAR
10	displayOptions	VARCHAR

Table: contacts

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	archived	BOOLEAN
3	companies	VARCHAR
4	id	VARCHAR
5	updatedAt	VARCHAR

External Resources

• Scopes
• Api Key
• Contacts List Memberships
• Deal Pipelines
• Email Events
• Engagements Calls
• Engagements Emails
• Engagements Meetings
• Engagements Notes
• Engagements Tasks
• Form Submissions
• Line Items
• Marketing Emails
• Property History
• Subscription Changes
• Ticket Pipelines
• Rate Limitations
• Rate Limit

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.