Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected HubSpot Data (SINGER)

HubSpot Info
The info in this article only applies to HubSpot integrations created on or after March 1, 2017.

This integration was created by Stitch for Singer, an open-source, composable ETL platform. Check out & contribute to the repo on GitHub.

HubSpot is currently in Open Beta. The info in this article is subject to change.

Now that HubSpot is successfully connected to your Stitch account, what comes next? In this article, we'll cover:

  1. How Stitch replicates HubSpot data
  2. The tables that will be created in your data warehouse

Replicating HubSpot Data

Historical Sync

By default, a historical sync of HubSpot data goes back one year from the Stitch connection date.

Frequency

Stitch will replicate HubSpot data based on the frequency you define. The default setting is every 30 minutes, but you can change it better suit your needs.

Replication Method

The majority of HubSpot data is replicated using Incremental Replication. This means that when these tables are queued for replication, only new and updated rows will be replicated.

There are a few exceptions to this, however. The following tables (and their subtables, if there are any) use Full Table Replication. This means that every time HubSpot data is queued for replication, all rows in a table - including existing, new, and updated - will be replicated:

  • campaigns
  • companies

HubSpot Tables in Your Data Warehouse

Below is a list of the HubSpot tables that will be created in your data warehouse. Because HubSpot uses nested arrays to structure data in some of its API's endpoints, Stitch will de-nest these arrays and create subtables if your data warehouse doesn't natively support nested structures. Refer to the Handling of Nested Data Structures doc for more info.

Nested arrays are marked with a *.

Click the table names to check out HubSpot's API docs.

campaigns
Replication Method: Full Table
Primary Key: id

The campaigns table contains info about the campaigns in your HubSpot account.

Attributes include:

  • Campaign ID (id)
  • appid
  • appname
  • contentid
  • counters__delivered
  • counters__open
  • counters__processed
  • counters__sent
  • name
  • numincluded
  • numqueued
  • subtype
  • subject
  • type

companies
Replication Method: Full Table
Primary Key: companyId

The companies table contains info about companies your contacts belong to.

Attributes include:

  • Company ID (companyid)
  • portalid
  • isdeleted

contacts
Replication Method: Incremental
Primary Key: vid

The contacts table contains info about individual contacts in HubSpot.

Attributes include:

  • Contact ID (vid)
  • portal-id
  • firstname
  • lastname
  • identity-profiles*
  • list-memberships*
  • profile-id
  • profile-token
  • profile-url
  • canonical-vid
  • merged-vids*
  • is-contact
  • form-submission*
  • merge-audits*

contact_lists
Replication Method: Incremental
Primary Key: internalListId

The contact_lists table contains info about the contact lists in your HubSpot account.

Attributes include:

  • Contact List ID(internallistid)
  • parentid
  • authorid
  • createdat
  • deleteable
  • dynamic
  • listid
  • listtype
  • metadata__error
  • metadata__lastprocessingstatechangeat
  • metadata__lastsizechangeat
  • metadata__processing
  • metadata__size
  • name
  • portalid
  • filters*
  • updatedat

deals
Replication Method: Incremental
Primary Key: dealId : portalId

The deals table contains info about all the deals in a HubSpot portal.

Attributes include:

  • Deal ID (dealid)
  • portalid
  • isdeleted
  • associations__associatedvids*
  • associations__comapnyids*
  • associations__dealids*

email_events
Replication Method: Append-Only (Incremental)
Primary Key: id

The email_events table contains info about email events and how recipients interact with content.

Attributes include:

  • Email Event ID (id)
  • appid
  • appname
  • browser__family
  • browser__name
  • browser__producer
  • browser__producerurl
  • browser__type
  • browser__url
  • created
  • emailcampaignid
  • hmid
  • ipaddress
  • location__city
  • location__country
  • location__state
  • portalid
  • portalsubscriptionstatus
  • recipient
  • sentby__created
  • sentby__id
  • smtpid
  • subject
  • type
  • useragent

forms
Replication Method: Incremental
Primary Key: guid

The forms table contains info about your HubSpot website forms.

Attributes include:

  • Form ID (guid)
  • portalid
  • name
  • action
  • method
  • cssclass
  • redirect
  • submittext
  • followupid
  • notifyrecipients
  • leadnurturingcampaignid
  • formfieldgrooups*
  • createdat
  • updatedat
  • performablehtml
  • migratedfrom
  • ignorecurrentvalues
  • deletable
  • inlinemessage
  • tmsid
  • captchaenabled
  • campaignguid
  • cloneable
  • editable
  • formtype
  • metadata*

keywords
Replication Method: Append-Only (Incremental)
Primary Key: keyword_guid

The keywords table contains info about your HubSpot portal keywords.

Attributes include:

  • Keyword ID (keyword_guid)
  • keyword
  • contacts
  • country
  • visits
  • created_at
  • leads

owners
Replication Method: Incremental
Primary Key: ownerId : portalId/code>

The owners table contains info about the owners that exist in your HubSpot portal.

Attributes include:

  • Owner ID (ownerid)
  • portalid
  • createdat
  • email
  • firstname
  • lastname
  • type
  • updatedat
  • remotelist*

subscription_changes
Replication Method: Incremental
Primary Key: recipient : timestamp : portalid

The subscription_changes table contains info about changes made to subscriptions.

Attributes include:

  • portalid
  • recipient
  • timestamp
  • changes*

workflows
Replication Method: Incremental
Primary Key: id

The workflows table contains info about the workflows in your HubSpot portal.

Attributes include:

  • Workflow ID (id)
  • contactlisids__active
  • contactlistids__enrolled
  • contactlistids__steps*
  • personatagids*
  • enabled
  • insertedat
  • name
  • type
  • updatedat
Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!