This version of HubSpot reached end of life on November 22, 2017 and is no longer functioning.
Upgrade to the latest version (v3) to continue replicating data.
HubSpot feature snapshot
A high-level look at Stitch's HubSpot (v01-03-2017) integration, including release status, useful links, and the features supported in Stitch.
| STITCH | |||
| Release status |
Sunset on November 22, 2017 |
Supported by | |
| Stitch plan |
Standard |
API availability |
Not available |
| Singer GitHub repository | |||
| REPLICATION SETTINGS | |||
| Anchor Scheduling |
Unsupported |
Advanced Scheduling |
Unsupported |
| Table-level reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
| DATA SELECTION | |||
| Table selection |
Unsupported |
Column selection |
Unsupported |
| Select all |
Unsupported |
||
| TRANSPARENCY | |||
| Extraction Logs |
Unsupported |
Loading Reports |
Supported |
HubSpot table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 01-03-2017 of this integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.
campaigns
The campaigns table contains info about the campaigns in your HubSpot account.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
appId INTEGER |
||||
|
appName STRING |
||||
|
contentId INTEGER |
||||
|
counters OBJECT
|
||||
|
id
INTEGER |
||||
|
name STRING |
||||
|
numIncluded INTEGER |
||||
|
numQueued INTEGER |
||||
|
subType STRING |
||||
|
subject STRING |
||||
|
type STRING |
companies
The companies table contains info about the companies your HubSpot contacts belong to.
|
Full Table |
|
|
Primary Key |
companyId |
| Useful links |
|
companyId
INTEGER |
|
isDeleted BOOLEAN |
|
portalId INTEGER |
contact_lists
The contact_lists table contains info about the contacts lists in your HubSpot account. Contact lists are used to segment contacts into groups, and there are two types: dynamic (smart lists) and static.
|
Key-based Incremental |
|
|
Primary Key |
listId |
|
Replication Key |
updatedAt |
| Useful links |
|
archived BOOLEAN |
||||||||
|
createdAt DATE-TIME |
||||||||
|
deleteable BOOLEAN |
||||||||
|
dynamic BOOLEAN |
||||||||
|
filters ARRAY
|
||||||||
|
internalListId INTEGER |
||||||||
|
listId
INTEGER |
||||||||
|
listType STRING |
||||||||
|
metaData OBJECT |
||||||||
|
name STRING |
||||||||
|
parentId INTEGER |
||||||||
|
portalId INTEGER |
||||||||
|
updatedAt
DATE-TIME |
contacts
The contacts table contains info about individual contacts in HubSpot.
|
Full Table |
|
|
Primary Key |
canonical-vid |
| Useful links |
|
canonical-vid
INTEGER |
|||||||||||||||||||||
|
form-submissions ARRAY
|
|||||||||||||||||||||
|
identity-profiles ARRAY
|
|||||||||||||||||||||
|
is-contact BOOLEAN |
|||||||||||||||||||||
|
list-memberships ARRAY
|
|||||||||||||||||||||
|
merge-audits ARRAY
|
|||||||||||||||||||||
|
merged-vids ARRAY
|
|||||||||||||||||||||
|
portal-id INTEGER |
|||||||||||||||||||||
|
profile-token STRING |
|||||||||||||||||||||
|
profile-url STRING |
|||||||||||||||||||||
|
vid INTEGER |
deals
The deals table contains info about the deals in a HubSpot portal.
|
Full Table |
|
|
Primary Keys |
dealId portalId |
| Useful links |
|
associations OBJECT
|
||||||
|
dealId
INTEGER |
||||||
|
isDeleted BOOLEAN |
||||||
|
portalId
INTEGER |
email_events
The email_events table contains info about email events and how recipients interact with content.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
id |
| Useful links |
|
appId INTEGER |
||||||
|
appName STRING |
||||||
|
browser OBJECT
|
||||||
|
created DATE-TIME |
||||||
|
deviceType STRING |
||||||
|
duration INTEGER |
||||||
|
emailCampaignGroupId INTEGER |
||||||
|
emailCampaignId INTEGER |
||||||
|
filteredEvent BOOLEAN |
||||||
|
from STRING |
||||||
|
hmid STRING |
||||||
|
id
STRING |
||||||
|
ipAddress STRING |
||||||
|
linkId INTEGER |
||||||
|
location OBJECT
|
||||||
|
portalId INTEGER |
||||||
|
recipient STRING |
||||||
|
response STRING |
||||||
|
sentBy OBJECT
|
||||||
|
smtpId STRING |
||||||
|
subject STRING |
||||||
|
type STRING |
||||||
|
url STRING |
||||||
|
userAgent STRING |
engagements
The engagements table contains info about all the engagements in a HubSpot portal.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
lastUpdated |
| Useful links |
|
active BOOLEAN |
|||||||||||||||||||||||||
|
associations ARRAY
|
|||||||||||||||||||||||||
|
attachments ARRAY
|
|||||||||||||||||||||||||
|
createdAt DATE-TIME |
|||||||||||||||||||||||||
|
id
INTEGER |
|||||||||||||||||||||||||
|
lastUpdated
DATE-TIME |
|||||||||||||||||||||||||
|
metadata OBJECT
|
|||||||||||||||||||||||||
|
ownerId INTEGER |
|||||||||||||||||||||||||
|
portalId INTEGER |
|||||||||||||||||||||||||
|
timestamp DATE-TIME |
|||||||||||||||||||||||||
|
type STRING |
forms
The forms table contains info about your HubSpot website forms.
|
Key-based Incremental |
|
|
Primary Key |
guid |
|
Replication Key |
updatedAt |
| Useful links |
|
action STRING |
|||||||||||||||||||||||||||||||||||
|
campaignGuid STRING |
|||||||||||||||||||||||||||||||||||
|
captchaEnabled BOOLEAN |
|||||||||||||||||||||||||||||||||||
|
cloneable BOOLEAN |
|||||||||||||||||||||||||||||||||||
|
createdAt DATE-TIME |
|||||||||||||||||||||||||||||||||||
|
cssClass STRING |
|||||||||||||||||||||||||||||||||||
|
deleteable BOOLEAN |
|||||||||||||||||||||||||||||||||||
|
deletedAt INTEGER |
|||||||||||||||||||||||||||||||||||
|
editable BOOLEAN |
|||||||||||||||||||||||||||||||||||
|
followUpId STRING |
|||||||||||||||||||||||||||||||||||
|
formFieldGroups ARRAY
|
|||||||||||||||||||||||||||||||||||
|
formType STRING |
|||||||||||||||||||||||||||||||||||
|
guid
STRING |
|||||||||||||||||||||||||||||||||||
|
ignoreCurrentValues BOOLEAN |
|||||||||||||||||||||||||||||||||||
|
inlineMessage STRING |
|||||||||||||||||||||||||||||||||||
|
leadNurturingCampaignId STRING |
|||||||||||||||||||||||||||||||||||
|
metaData ARRAY
|
|||||||||||||||||||||||||||||||||||
|
method STRING |
|||||||||||||||||||||||||||||||||||
|
migratedFrom STRING |
|||||||||||||||||||||||||||||||||||
|
name STRING |
|||||||||||||||||||||||||||||||||||
|
notifyRecipients STRING |
|||||||||||||||||||||||||||||||||||
|
performableHtml STRING |
|||||||||||||||||||||||||||||||||||
|
portalId INTEGER |
|||||||||||||||||||||||||||||||||||
|
redirect STRING |
|||||||||||||||||||||||||||||||||||
|
submitText STRING |
|||||||||||||||||||||||||||||||||||
|
tmsId STRING |
|||||||||||||||||||||||||||||||||||
|
updatedAt
DATE-TIME |
keywords
The keywords table contains info about your HubSpot portal keywords.
|
Key-based Incremental |
|
|
Primary Key |
keyword_guid |
|
Replication Key |
created_at |
| Useful links |
|
contacts INTEGER |
|
country STRING |
|
created_at
DATE-TIME |
|
keyword STRING |
|
keyword_guid
STRING |
|
leads INTEGER |
|
visits INTEGER |
owners
The owners table contains info about the owners that exist in your HubSpot portal. Owners are created and updated in HubSpot when new users are added or when owners are synced from Salesforce to HubSpot.
|
Key-based Incremental |
|
|
Primary Keys |
ownerId portalId |
|
Replication Key |
updatedAt |
| Useful links |
|
createdAt DATE-TIME |
|||||
|
STRING |
|||||
|
firstName STRING |
|||||
|
lastName STRING |
|||||
|
ownerId
INTEGER |
|||||
|
portalId
INTEGER |
|||||
|
remoteList ARRAY
|
|||||
|
type STRING |
|||||
|
updatedAt
DATE-TIME |
subscription_changes
The subscription_changes table contains info about changes made subscriptions.
|
Key-based Incremental |
|
|
Primary Keys |
recipient portalId timestamp |
|
Replication Key |
timestamp |
| Useful links |
|
changes ARRAY
|
|||||||||
|
portalId
INTEGER |
|||||||||
|
recipient
STRING |
|||||||||
|
timestamp
DATE-TIME |
workflows
The workflows table contains info about the workflows in your HubSpot portal.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updatedAt |
| Useful links |
|
contactListIds OBJECT
|
||||
|
enabled BOOLEAN |
||||
|
id
INTEGER |
||||
|
inserted-at DATE-TIME |
||||
|
name STRING |
||||
|
personaTagIds ARRAY
|
||||
|
type STRING |
||||
|
updatedAt
DATE-TIME |
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.