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

Stitch plan

Standard

API availability

Not available

Singer GitHub repository

singer-io/tap-hubspot

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

campaigns

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

Replication Method

Full Table

Primary Key

id

Useful links

HubSpot documentation

campaigns schema on GitHub

HubSpot API method

appId

INTEGER

appName

STRING

contentId

INTEGER

counters

OBJECT

delivered

INTEGER

open

INTEGER

processed

INTEGER

sent

INTEGER

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.

Replication Method

Full Table

Primary Key

companyId

Useful links

HubSpot documentation

companies schema on GitHub

HubSpot API method

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.

Replication Method

Key-based Incremental

Primary Key

listId

Replication Key

updatedAt

Useful links

HubSpot documentation

contact_lists schema on GitHub

HubSpot API method

archived

BOOLEAN

createdAt

DATE-TIME

deleteable

BOOLEAN

dynamic

BOOLEAN

filters

ARRAY

value

ARRAY

checkPastVersions

BOOLEAN

filterFamily

STRING

operator

STRING

property

STRING

type

STRING

value

STRING

withinTimeMode

STRING

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.

Replication Method

Full Table

Primary Key

canonical-vid

Useful links

HubSpot documentation

contacts schema on GitHub

HubSpot API method

canonical-vid

INTEGER

form-submissions

ARRAY

conversion-id

STRING

form-id

STRING

page-url

STRING

portal-id

INTEGER

timestamp

DATE-TIME

title

STRING

identity-profiles

ARRAY

deleted-changed-timestamp

DATE-TIME

identities

ARRAY

timestamp

DATE-TIME

type

STRING

value

STRING

saved-at-timestamp

DATE-TIME

vid

INTEGER

is-contact

BOOLEAN

list-memberships

ARRAY

internal-list-id

INTEGER

is-member

BOOLEAN

static-list-id

INTEGER

timestamp

DATE-TIME

vid

INTEGER

merge-audits

ARRAY

canonical-vid

INTEGER

merged-from-email

OBJECT

selected

BOOLEAN

source-id

STRING

source-label

STRING

source-type

STRING

source-vids

ARRAY

timestamp

INTEGER

value

STRING

merged-to-email

OBJECT

selected

BOOLEAN

source-id

STRING

source-label

STRING

source-type

STRING

timestamp

INTEGER

value

STRING

num-properties-moved

INTEGER

timestamp

DATE-TIME

user-id

INTEGER

vid-to-merge

INTEGER

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.

Replication Method

Full Table

Primary Keys

dealId

portalId

Useful links

HubSpot documentation

deals schema on GitHub

HubSpot API method

associations

OBJECT

associatedCompanyIds

ARRAY

associatedDealIds

ARRAY

associatedVids

ARRAY

dealId

INTEGER

isDeleted

BOOLEAN

portalId

INTEGER

email_events

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

id

Useful links

HubSpot documentation

email_events schema on GitHub

HubSpot API method

appId

INTEGER

appName

STRING

browser

OBJECT

family

STRING

name

STRING

producer

STRING

producerUrl

STRING

type

STRING

url

STRING

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

city

STRING

country

STRING

state

STRING

portalId

INTEGER

recipient

STRING

response

STRING

sentBy

OBJECT

created

DATE-TIME

id

STRING

smtpId

STRING

subject

STRING

type

STRING

url

STRING

userAgent

STRING

engagements

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

lastUpdated

Useful links

HubSpot documentation

engagements schema on GitHub

HubSpot API method

active

BOOLEAN

associations

ARRAY

companyIds

ARRAY

contactIds

ARRAY

dealIds

ARRAY

value

INTEGER

attachments

ARRAY

createdAt

DATE-TIME

id

INTEGER

lastUpdated

DATE-TIME

metadata

OBJECT

bcc

OBJECT

email

STRING

body

STRING

cc

OBJECT

email

STRING

durationMilliseconds

INTEGER

endTime

INTEGER

externalAccountId

STRING

externalId

STRING

forObjectType

STRING

from

OBJECT

email

STRING

firstName

STRING

lastName

STRING

fromNumber

STRING

html

STRING

recordingUrl

STRING

startTime

INTEGER

status

STRING

subject

STRING

text

STRING

title

STRING

to

OBJECT

email

SRING

toNumber

STRING

ownerId

INTEGER

portalId

INTEGER

timestamp

DATE-TIME

type

STRING

forms

The forms table contains info about your HubSpot website forms.

Replication Method

Key-based Incremental

Primary Key

guid

Replication Key

updatedAt

Useful links

HubSpot documentation

forms schema on GitHub

HubSpot API method

action

STRING

campaignGuid

STRING

captchaEnabled

BOOLEAN

cloneable

BOOLEAN

createdAt

DATE-TIME

cssClass

STRING

deleteable

BOOLEAN

deletedAt

INTEGER

editable

BOOLEAN

followUpId

STRING

formFieldGroups

ARRAY

default

BOOLEAN

fields

ARRAY

defaultValue

STRING

description

STRING

displayOrder

INTEGER

enabled

BOOLEAN

fieldType

STRING

groupName

STRING

hidden

BOOLEAN

isSmartField

BOOLEAN

label

STRING

labelHidden

BOOLEAN

name

STRING

options

ARRAY

description

STRING

displayOrder

INTEGER

doubleData

NUMBER

hidden

BOOLEAN

label

STRING

readOnly

BOOLEAN

value

STRING

placeholder

STRING

required

BOOLEAN

type

STRING

unselectedLabel

STRING

validation

OBJECT

blockedEmailAddresses

ARRAY

data

STRING

message

STRING

name

STRING

useDefaultBlockList

BOOLEAN

isSmartGroup

BOOLEAN

richText

OBJECT

content

STRING

formType

STRING

guid

STRING

ignoreCurrentValues

BOOLEAN

inlineMessage

STRING

leadNurturingCampaignId

STRING

metaData

ARRAY

name

STRING

value

STRING

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.

Replication Method

Key-based Incremental

Primary Key

keyword_guid

Replication Key

created_at

Useful links

HubSpot documentation

keywords schema on GitHub

HubSpot API method

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.

Replication Method

Key-based Incremental

Primary Keys

ownerId

portalId

Replication Key

updatedAt

Useful links

HubSpot documentation

owners schema on GitHub

HubSpot API method

createdAt

DATE-TIME

email

STRING

firstName

STRING

lastName

STRING

ownerId

INTEGER

portalId

INTEGER

remoteList

ARRAY

active

BOOLEAN

ownerId

INTEGER

portalId

INTEGER

remoteId

STRING

remoteType

STRING

type

STRING

updatedAt

DATE-TIME

subscription_changes

The subscription_changes table contains info about changes made subscriptions.

Replication Method

Key-based Incremental

Primary Keys

recipient

portalId

timestamp

Replication Key

timestamp

Useful links

HubSpot documentation

subscription_changes schema on GitHub

HubSpot API method

changes

ARRAY

causedByEvent

OBJECT

created

DATE-TIME

id

STRING

change

STRING

changeType

STRING

portalId

INTEGER

source

STRING

subscriptionId

INTEGER

timestamp

DATE-TIME

portalId

INTEGER

recipient

STRING

timestamp

DATE-TIME

workflows

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

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

HubSpot documentation

workflows schema on GitHub

HubSpot API method

contactListIds

OBJECT

active

INTEGER

enrolled

INTEGER

steps

ARRAY

type

STRING

enabled

BOOLEAN

id

INTEGER

inserted-at

DATE-TIME

name

STRING

personaTagIds

ARRAY

type

STRING

updatedAt

DATE-TIME


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.