Adding the data source
Requirements
Follow the steps with a Super admin type user
The minimum scope required for the connector to function is crm.objects.contacts
Instructions
2) At the top right, click on settings (gear icon);
3) In the left menu of the settings page, select the option of “Integrations”;
4) In the Integrations expansion, select “Private Apps”;
5) On the Private apps page, click on “Create a private app";
7) Select the “scopes” section at the top;
8) In the scopes section, we recommend checking the “Read” permission in all scopes available in CRM (do not select the “Write” permission because it is not necessary) and in Standard, we recommend using all scopes that are not of write;
9) After filling in the data in “Basic info” and “Scopes”, select “Create app” at the top right;
10) Accept the pop-up that will appear and then when you receive the message that your app has been created, click on show token and then copy the displayed token;
12) On the data source creation page, insert the token obtained in step 10 and click Save.
You're ready to go to the pipelines page, select the pipelines you want to build and start replicating your Hubspot data to your destination!
Pipelines
Summary
Relationship chart
Contacts [Current Version]
This pipeline will bring the contacts and all their properties in columnar format – according to your account configuration, in a format similar to the one below:
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
property_x | text | |
property_y | text | |
property_z | text |
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. That's why we created a dedicated archived logs pipeline that you can use to remove archived data from your visualization or model. Deleted data cannot be recovered.
By default, all existing custom properties in your account will be brought over. However, using too many properties can impact data reading speed. We recommend that you use only the necessary properties, selecting the ones you want on the integration creation/editing screen, when naming the tables, just click on FIELDS and uncheck/check the desired properties/columns.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Archived Contacts [Current Version]
Field | Type | |
---|---|---|
id | text | |
archived | boolean | |
archivedat | timestamp | |
createdat | timestamp | |
properties__createdate | timestamp | |
properties__email | text | |
properties__firstname | text | |
properties__lastmodifieddate | timestamp | |
properties__lastname | text | |
updatedat | timestamp |
Contacts: Lists Membership
Field | Type | |
---|---|---|
vid | text | |
timestamp | timestamp | |
static_list_id | text | |
internal_list_id | text | |
is_member | boolean |
Contacts: Form Submissions
Main object
Field | Type | |
---|---|---|
vid | text | |
conversion_id | text | |
canonical_url | text | |
content_type | text | |
form_id | text | |
form_type | text | |
page_id | text | |
page_title | text | |
page_url | text | |
portal_id | text | |
timestamp | timestamp | |
title | text |
contact_associated_by
Field | Type | |
---|---|---|
vid | text | |
conversion_id | text | |
associated_by | text |
Contacts: Related Tickets [Current Version]
Field | Type | |
---|---|---|
contact_id | int | |
ticket_id | int | |
association_type | text |
Contacts: Related Deals [Current Version]
Field | Type | |
---|---|---|
contact_id | int | |
deal_id | int | |
association_type | text |
Contacts: Related Companies [Current Version]
Field | Type | |
---|---|---|
contact_id | int | |
company_id | int | |
association_type | text |
Contact Lists
Field | Type | |
---|---|---|
listid | text | |
archived | boolean | |
authorid | text | |
createdat | timestamp | |
deleteable | boolean | |
dynamic | boolean | |
internallistid | text | |
listtype | text | |
metadata__lastprocessingstatechangeat | timestamp | |
metadata__lastsizechangeat | timestamp | |
metadata__processing | text | |
metadata__size | float | |
name | text | |
portalid | text | |
readonly | boolean | |
updatedat | timestamp |
Contact Properties [V1]
Main object
Field | Type | |
---|---|---|
favorited | boolean | |
description | text | |
createduserid | float | |
deleted | boolean | |
referencedobjecttype | text | |
updatedat | float | |
displaymode | text | |
externaloptions | boolean | |
displayorder | float | |
formfield | boolean | |
readonlyvalue | boolean | |
fieldtype | text | |
optionsaremutable | boolean | |
currencypropertyname | text | |
searchableinglobalsearch | boolean | |
createdat | float | |
textdisplayhint | text | |
showcurrencysymbol | boolean | |
property_name | text | |
updateduserid | float | |
iscustomizeddefault | boolean | |
calculated | boolean | |
favoritedorder | float | |
mutabledefinitionnotdeletable | boolean | |
label | text | |
groupname | text | |
hasuniquevalue | boolean | |
numberdisplayhint | text | |
hubspotdefined | boolean | |
searchtextanalysismode | text | |
hidden | boolean | |
type | text | |
optionsortstrategy | text | |
readonlydefinition | boolean |
options
Field | Type | |
---|---|---|
property_name | text | |
options__description | text | |
options__value | text | |
options__label | text | |
options__readonly | boolean | |
options__hidden | boolean | |
options__displayorder | float | |
options__doubledata | text |
Contacts [V1]
Main object
Field | Type | |
---|---|---|
addedat | float | |
vid | text | |
canonical_vid | float | |
portal_id | float | |
is_contact | boolean | |
profile_token | text | |
profile_url | text |
_merged_vids
Field | Type | |
---|---|---|
vid | text | |
merged_vid | float |
form-submissions
Field | Type | |
---|---|---|
vid | text | |
conversion_id | text | |
timestamp | float | |
form_id | text | |
portal_id | float | |
title | text | |
form_type | text | |
page_url | text | |
contact_associated_by | text |
list-memberships
Field | Type | |
---|---|---|
vid | text | |
static_list_id | float | |
internal_list_id | float | |
timestamp | float | |
list_memberships__vid | float | |
is_member | boolean |
identity-profiles
Field | Type | |
---|---|---|
vid | text | |
is_deleted | boolean | |
is_contact | boolean | |
pointer_vid | float | |
previous_vid | float | |
saved_at_timestamp | float | |
deleted_changed_timestamp | float |
_identityProfiles_linkedVids
Field | Type | |
---|---|---|
vid | text | |
linked_vid | float |
_identityProfiles_identities
Field | Type | |
---|---|---|
vid | text | |
type | text | |
value | text | |
timestamp | float | |
is_primary | boolean | |
is_secondary | boolean |
_properties
Field | Type | |
---|---|---|
vid | text | |
key | text | |
value | text |
_properties_versions
Field | Type | |
---|---|---|
vid | text | |
key | text | |
value | text | |
source_type | text | |
source_id | text | |
source_label | text | |
timestamp | float | |
selected | boolean |
Deals [Current Version]
This pipeline will bring the deals and all their properties in columnar format – depending on your account configuration, in a format similar to the one below:
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
property_x | text | |
property_y | text | |
property_z | text |
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. That's why we created a dedicated archived logs pipeline that you can use to remove archived data from your visualization or model. Deleted data cannot be recovered.
By default, all existing custom properties in your account will be brought over. However, using too many properties can impact data reading speed. We recommend that you use only the necessary properties, selecting the ones you want on the pipeline creation/editing screen, when naming the tables, just click on FIELDS and uncheck/check the desired properties/columns.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Archived Deals [Current Version]
Field | Type | |
---|---|---|
id | text | |
archived | boolean | |
archivedat | timestamp | |
createdat | timestamp | |
properties__amount | float | |
properties__closedate | timestamp | |
properties__createdate | timestamp | |
properties__dealname | text | |
properties__dealstage | text | |
properties__hs_lastmodifieddate | timestamp | |
properties__pipeline | text | |
updatedat | timestamp |
Deals: Related Contacts [Current Version]
Field | Type | |
---|---|---|
deal_id | text | |
contact_id | text | |
association_type | text |
Deals: Related Companies [Current Version]
Field | Type | |
---|---|---|
deal_id | text | |
company_id | text | |
association_type | text |
Deals: Related Tickets [Current Version]
Field | Type | |
---|---|---|
deal_id | text | |
ticket_id | text | |
association_type | text |
Owners [Current Version]
Main object
Field | Type | |
---|---|---|
id | text | |
userid | text | |
text | ||
firstname | text | |
lastname | text | |
archived | boolean | |
createdat | timestamp | |
updatedat | timestamp |
hubspot_owners_teams
Field | Type | |
---|---|---|
owner_id | text | |
team_id | text | |
team_name | text |
Due to limitations in data reading, this pipeline is integral.
Deal Properties [V1]
Main object
Field | Type | |
---|---|---|
favorited | boolean | |
description | text | |
createduserid | float | |
deleted | boolean | |
referencedobjecttype | text | |
updatedat | float | |
displaymode | text | |
externaloptions | boolean | |
displayorder | float | |
formfield | boolean | |
readonlyvalue | boolean | |
fieldtype | text | |
optionsaremutable | boolean | |
currencypropertyname | text | |
searchableinglobalsearch | boolean | |
createdat | float | |
textdisplayhint | text | |
showcurrencysymbol | boolean | |
property_name | text | |
updateduserid | float | |
iscustomizeddefault | boolean | |
calculated | boolean | |
favoritedorder | float | |
mutabledefinitionnotdeletable | boolean | |
label | text | |
groupname | text | |
hasuniquevalue | boolean | |
numberdisplayhint | text | |
hubspotdefined | boolean | |
searchtextanalysismode | text | |
hidden | boolean | |
type | text | |
optionsortstrategy | text | |
readonlydefinition | boolean |
options
Field | Type | |
---|---|---|
property_name | text | |
options__description | text | |
options__value | text | |
options__label | text | |
options__readonly | boolean | |
options__hidden | boolean | |
options__displayorder | float | |
options__doubledata | text |
Deals [V1]
Objeto principal
Field | Type | |
---|---|---|
dealid | text | |
portalid | float | |
isdeleted | boolean |
_associations
Field | Type | |
---|---|---|
dealid | text | |
association_type | text | |
association_value | float |
_properties
Field | Type | |
---|---|---|
dealid | text | |
key | text | |
value | text |
_properties_versions
Field | Type | |
---|---|---|
dealid | text | |
key | text | |
value | text | |
source_id | text | |
timestamp | float | |
source | text |
Pipelines
Main object
Field | Type | |
---|---|---|
default | boolean | |
displayorder | float | |
updatedat | float | |
active | boolean | |
objecttypeid | text | |
pipelineid | text | |
label | text | |
createdat | float | |
objecttype | text |
stages
Field | Type | |
---|---|---|
pipelineid | text | |
stages__label | text | |
stages__createdat | float | |
stages__stageid | text | |
stages__updatedat | float | |
stages__active | boolean | |
stages__displayorder | float | |
stages__metadata__isclosed | text | |
stages__metadata__probability | float |
Owners [V1]
Objeto principal
Field | Type | |
---|---|---|
activeuserid | text | |
portalid | text | |
updatedat | float | |
createdat | float | |
useridincludinginactive | text | |
firstname | text | |
hascontactsaccess | boolean | |
lastname | text | |
activesalesforceid | text | |
isactive | boolean | |
ownerid | text | |
type | text | |
text |
remoteList
Field | Type | |
---|---|---|
ownerid | text | |
remotelist__remoteid | text | |
remotelist__portalid | text | |
remotelist__remotetype | text | |
remotelist__ownerid | text | |
remotelist__active | boolean | |
remotelist__id | text |
Companies [Current Version]
This pipeline will bring the companies and all their properties in columnar format – according to your account configuration, in a format similar to the one below:
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
property_x | text | |
property_y | text | |
property_z | text |
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. That's why we created a dedicated archived logs pipeline that you can use to remove archived data from your visualization or model. Deleted data cannot be recovered.
By default, all existing custom properties in your account will be brought over. However, using too many properties can impact data reading speed. We recommend that you use only the necessary properties, selecting the ones you want on the pipeline creation/editing screen, when naming the tables, just click on FIELDS and uncheck/check the desired properties/columns.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Archived Companies [Current Version]
Field | Type | |
---|---|---|
id | text | |
archived | boolean | |
archivedat | timestamp | |
createdat | timestamp | |
properties__createdate | timestamp | |
properties__domain | text | |
properties__hs_lastmodifieddate | timestamp | |
properties__name | text | |
updatedat | timestamp |
Companies: Related Contacts [Current Version]
Field | Type | |
---|---|---|
company_id | text | |
contact_id | text | |
association_type | text |
Companies: Related Deals [Current Version]
Field | Type | |
---|---|---|
company_id | text | |
deal_id | text | |
association_type | text |
Companies: Related Tickets [Current Version]
Field | Type | |
---|---|---|
company_id | text | |
ticket_id | text | |
association_type | text |
Company Properties [V1]
Main object
Field | Type | |
---|---|---|
favorited | boolean | |
description | text | |
createduserid | float | |
deleted | boolean | |
referencedobjecttype | text | |
updatedat | float | |
displaymode | text | |
externaloptions | boolean | |
displayorder | float | |
formfield | boolean | |
readonlyvalue | boolean | |
fieldtype | text | |
optionsaremutable | boolean | |
currencypropertyname | text | |
searchableinglobalsearch | boolean | |
createdat | float | |
textdisplayhint | text | |
showcurrencysymbol | boolean | |
property_name | text | |
updateduserid | float | |
iscustomizeddefault | boolean | |
calculated | boolean | |
favoritedorder | float | |
mutabledefinitionnotdeletable | boolean | |
label | text | |
groupname | text | |
hasuniquevalue | boolean | |
numberdisplayhint | text | |
hubspotdefined | boolean | |
searchtextanalysismode | text | |
hidden | boolean | |
type | text | |
optionsortstrategy | text | |
readonlydefinition | boolean |
options
Field | Type | |
---|---|---|
property_name | text | |
options__description | text | |
options__value | text | |
options__label | text | |
options__readonly | boolean | |
options__hidden | boolean | |
options__displayorder | float | |
options__doubledata | text |
Companies [V1]
Main object
Field | Type | |
---|---|---|
companyid | text | |
portalid | float | |
isdeleted | boolean |
_properties
Field | Type | |
---|---|---|
companyid | text | |
key | text | |
value | text |
_properties_versions
Field | Type | |
---|---|---|
companyid | text | |
key | text | |
value | text | |
source_id | text | |
timestamp | float | |
source | text |
Tickets [Current Version]
This pipeline will bring tickets and all their properties in columnar format – according to your account configuration, in a format similar to the one below:
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
property_x | text | |
property_y | text | |
property_z | text |
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. That's why we created a dedicated archived logs pipeline that you can use to remove archived data from your visualization or model. Deleted data cannot be recovered.
By default, all existing custom properties in your account will be brought over. However, using too many properties can impact data reading speed. We recommend that you use only the necessary properties, selecting the ones you want on the pipeline creation/editing screen, when naming the tables, just click on FIELDS and uncheck/check the desired properties/columns.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Archived Tickets [Current Version]
Field | Type | |
---|---|---|
id | text | |
archived | boolean | |
archivedat | timestamp | |
createdat | timestamp | |
properties__content | text | |
properties__createdate | timestamp | |
properties__hs_lastmodifieddate | timestamp | |
properties__hs_pipeline | text | |
properties__hs_pipeline_stage | text | |
properties__hs_ticket_category | text | |
properties__hs_ticket_priority | text | |
properties__subject | text | |
updatedat | timestamp |
Tickets: Related Contacts [Current Version]
Field | Type | |
---|---|---|
ticket_id | int | |
contact_id | int | |
association_type | text |
Tickets: Related Deals [Current Version]
Field | Type | |
---|---|---|
ticket_id | int | |
deal_id | int | |
association_type | text |
Tickets: Related Companies [Current Version]
Field | Type | |
---|---|---|
ticket_id | int | |
company_id | int | |
association_type | text |
Ticket Properties [V1]
Main object
Field | Type | |
---|---|---|
favorited | boolean | |
description | text | |
createduserid | text | |
externaloptions | boolean | |
referencedobjecttype | text | |
updatedat | text | |
displaymode | text | |
numberdisplayhint | text | |
favoritedorder | float | |
formfield | boolean | |
readonlyvalue | boolean | |
fieldtype | text | |
optionsaremutable | text | |
searchableinglobalsearch | boolean | |
displayorder | float | |
textdisplayhint | text | |
showcurrencysymbol | text | |
property_name | text | |
updateduserid | text | |
iscustomizeddefault | boolean | |
calculated | boolean | |
deleted | text | |
mutabledefinitionnotdeletable | boolean | |
createdat | text | |
label | text | |
groupname | text | |
hasuniquevalue | boolean | |
hubspotdefined | boolean | |
currencypropertyname | text | |
searchtextanalysismode | text | |
hidden | boolean | |
type | text | |
optionsortstrategy | text | |
readonlydefinition | boolean |
options
Field | Type | |
---|---|---|
property_name | text | |
options__doubledata | text | |
options__value | text | |
options__label | text | |
options__readonly | text | |
options__hidden | boolean | |
options__displayorder | float | |
options__description | text |
Tickets [V1]
Main object
Field | Type | |
---|---|---|
ticketid | text | |
portalid | float | |
isdeleted | boolean |
_properties
Field | Type | |
---|---|---|
ticketid | text | |
key | text | |
value | text |
_properties_versions
Field | Type | |
---|---|---|
ticketid | text | |
key | text | |
value | text | |
source_id | text | |
timestamp | float | |
source | text |
_associations
Field | Type | |
---|---|---|
ticketid | text | |
association_type | text | |
associated_id | text |
Email Events
Sent
Field | Type | |
---|---|---|
id | text | |
from | text | |
appname | text | |
replyto | text | |
type | text | |
emailcampaignid | float | |
created | float | |
bcc | text | |
portalid | float | |
appid | float | |
emailcampaigngroupid | float | |
smtpid | text | |
sentby__id | text | |
sentby__created | float | |
recipient | text | |
cc | text | |
subject | text |
Dropped
Field | Type | |
---|---|---|
id | text | |
appname | text | |
emailcampaignid | float | |
portalid | float | |
appid | float | |
emailcampaigngroupid | float | |
recipient | text | |
dropreason | text | |
attempt | float | |
smtpid | text | |
created | float | |
sentby__id | text | |
sentby__created | float | |
type | text | |
dropmessage | text |
Processed
Field | Type | |
---|---|---|
id | text | |
appname | text | |
emailcampaignid | float | |
smtpid | text | |
appid | float | |
emailcampaigngroupid | float | |
recipient | text | |
attempt | float | |
portalid | float | |
created | float | |
sentby__id | text | |
sentby__created | float | |
type | text |
Delivered
Field | Type | |
---|---|---|
id | text | |
appname | text | |
emailcampaignid | float | |
smtpid | text | |
appid | float | |
emailcampaigngroupid | float | |
recipient | text | |
response | text | |
attempt | float | |
portalid | float | |
created | float | |
sentby__id | text | |
sentby__created | float | |
type | text |
Deferred
Field | Type | |
---|---|---|
id | text | |
appname | text | |
emailcampaignid | float | |
portalid | float | |
appid | float | |
emailcampaigngroupid | float | |
recipient | text | |
response | text | |
attempt | float | |
smtpid | text | |
created | float | |
sentby__id | text | |
sentby__created | float | |
type | text |
Bounce
Field | Type | |
---|---|---|
id | text | |
status | text | |
appname | text | |
emailcampaignid | float | |
portalid | float | |
appid | float | |
emailcampaigngroupid | float | |
recipient | text | |
response | text | |
category | text | |
attempt | float | |
smtpid | text | |
created | float | |
sentby__id | text | |
sentby__created | float | |
type | text |
Open
Field | Type | |
---|---|---|
appname | text | |
type | text | |
emailcampaignid | float | |
created | float | |
portalid | float | |
devicetype | text | |
location__country | text | |
location__state | text | |
location__zipcode | text | |
location__city | text | |
filteredevent | boolean | |
appid | float | |
duration | float | |
useragent | text | |
smtpid | text | |
sentby__id | text | |
sentby__created | float | |
recipient | text | |
id | text | |
browser__family | text | |
browser__name | text | |
browser__producer | text | |
browser__url | text | |
browser__producerurl | text | |
browser__version | text | |
browser__type | text |
Click
Field | Type | |
---|---|---|
id | text | |
type | text | |
appname | text | |
url | text | |
linkid | float | |
useragent | text | |
created | float | |
smtpid | text | |
emailcampaigngroupid | float | |
referer | text | |
location__country | text | |
location__state | text | |
location__city | text | |
filteredevent | boolean | |
appid | float | |
portalid | float | |
devicetype | text | |
sentby__id | text | |
sentby__created | float | |
recipient | text | |
emailcampaignid | float | |
browser__family | text | |
browser__name | text | |
browser__producer | text | |
browser__url | text | |
browser__producerurl | text | |
browser__version | text | |
browser__type | text |
Status change
Field | Type | |
---|---|---|
id | text | |
source | text | |
portalid | float | |
appid | float | |
subscriptions | text | |
sourceid | text | |
type | text | |
emailcampaignid | float | |
created | float | |
recipient | text |
Spam report
Field | Type | |
---|---|---|
id | text | |
appname | text | |
emailcampaignid | float | |
portalid | float | |
appid | float | |
recipient | text | |
attempt | text | |
smtpid | text | |
created | float | |
sentby__id | text | |
sentby__created | float | |
type | text |
Marketing Emails
Main object
Field | Type | |
---|---|---|
id | text | |
ab | boolean | |
abhourstowait | float | |
absamplesizedefault | text | |
absamplingdefault | text | |
abstatus | text | |
absuccessmetric | text | |
abtestid | text | |
abtestpercentage | float | |
abvariation | boolean | |
absoluteurl | text | |
analyticspageid | text | |
analyticspagetype | text | |
archived | boolean | |
author | text | |
authorname | text | |
campaign | text | |
campaignname | text | |
campaignutm | text | |
canspamsettingsid | text | |
categoryid | float | |
createpage | boolean | |
created | timestamp | |
createdbyid | text | |
currentstate | text | |
currentlypublished | boolean | |
customreplyto | text | |
customreplytoenabled | boolean | |
domain | text | |
emailbody | text | |
emailcampaigngroupid | text | |
emailnote | text | |
emailtemplatemode | text | |
emailtype | text | |
feedbacksurveyid | text | |
freezedate | timestamp | |
fromname | text | |
hascontentaccessrules | boolean | |
htmltitle | text | |
isgraymailsuppressionenabled | boolean | |
ispublished | boolean | |
isrecipientfatiguesuppressionenabled | boolean | |
language | text | |
livedomain | text | |
maxrssentries | float | |
metadescription | text | |
name | text | |
pageexpiryenabled | boolean | |
pageredirected | boolean | |
portalid | text | |
previewkey | text | |
primaryemailcampaignid | text | |
primaryrichtextmodulehtml | text | |
processingstatus | text | |
publishdate | timestamp | |
publishedat | timestamp | |
publishedbyemail | text | |
publishedbyid | text | |
publishedbyname | text | |
publishedurl | text | |
replyto | text | |
resolveddomain | text | |
rssemailbytext | text | |
rssemailclickthroughtext | text | |
rssemailcommenttext | text | |
rssemailentrytemplateenabled | boolean | |
rssemailimagemaxwidth | float | |
rssemailurl | text | |
securitystate | text | |
slug | text | |
state | text | |
subcategory | text | |
subject | text | |
subscription | text | |
subscriptionname | text | |
templatepath | text | |
transactional | boolean | |
unpublishedat | timestamp | |
updated | timestamp | |
updatedbyid | text | |
url | text | |
userssheadlineassubject | boolean |
hubspot_marketing_emails__mailing_lists_included
Field | Type | |
---|---|---|
marketing_email_id | text | |
mailing_list_id | text |
hubspot_marketing_emails__vids_included
Field | Type | |
---|---|---|
marketing_email_id | text | |
vid | text |
hubspot_marketing_emails__email_campaigns
Field | Type | |
---|---|---|
marketing_email_id | text | |
campaign_id | text |
hubspot_marketing_emails__vids_excluded
Field | Type | |
---|---|---|
marketing_email_id | text | |
vid | text |
hubspot_marketing_emails__mailing_lists_excluded
Field | Type | |
---|---|---|
marketing_email_id | text | |
mailing_list_id | text |
Engagements [V1]
Main object
Field | Type | |
---|---|---|
id | text | |
bodypreviewhtml | text | |
bodypreview | text | |
bodypreviewistruncated | boolean | |
uid | text | |
source | text | |
timestamp | float | |
lastupdated | float | |
portalid | text | |
teamid | text | |
modifiedby | float | |
createdby | float | |
active | boolean | |
ownerid | text | |
type | text | |
createdat | float | |
metadata_status | text | |
session_visitorstarttime | float | |
email_loggedfrom | text | |
call_disposition | text | |
call_recordingurl | text | |
call_fromnumber | text | |
email_text | text | |
email_messageid | text | |
session_closedat | float | |
session_durationmilliseconds | float | |
session_agentjointime | float | |
session_isbot | boolean | |
meeting_starttime | float | |
metadata_threadid | text | |
call_externalaccountid | text | |
metadata_body | text | |
session_visitorendtime | float | |
metadata_subject | text | |
session_numvisitormessages | float | |
email_attachedvideowatched | boolean | |
email_validationskipped | text | |
meeting_endtime | float | |
session_conversationsource | text | |
email_sender | text | |
task_forobjecttype | text | |
session_url | text | |
meeting_title | text | |
task_reminders | text | |
email_html | text | |
session_visitorwaittimemilliseconds | float | |
call_tonumber | text | |
email_sendeventid | text | |
call_durationmilliseconds | float | |
session_online | boolean | |
task_senddefaultreminder | boolean | |
call_externalid | text | |
session_numagentmessages | float | |
task_type | text | |
email_attachedvideoopened | boolean | |
email_mediaprocessingstatus | text | |
task_completiondate | float | |
meetingoutcome | text | |
activitytype | text |
associations
Field | Type | |
---|---|---|
engagement_id | text | |
association_type | text | |
association_value | text |
note_attachments
Field | Type | |
---|---|---|
engagement_id | text | |
note_attachment_id | text |
email_addresses
Field | Type | |
---|---|---|
engagement_id | text | |
firstname | text | |
lastname | text | |
raw | text | |
address_type | text | |
text |
This pipeline does not capture deletions and archives. This way, engagements that have been removed from HubSpot can continue to show up in your destination. To resync, you can perform an advanced edit of the pipeline.
By limitation of the API, if during an execution more than 10 thousand records are found updated/created within the queried period (savepoint + update window) a full load will be performed.
Engagements: Calls [Current Version]
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
hs_activity_type | text | [en] Call and meeting type – The activity type of the engagement |
hs_all_assigned_business_unit_ids | text | [en] Business units – The business units this record is assigned to. |
hs_at_mentioned_owner_ids | text | [en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement |
hs_attachment_ids | text | [en] Attached file IDs – The IDs of the files that are attached to the engagement |
hs_body_preview | text | [en] Call notes preview – A truncated preview of the call notes |
hs_body_preview_html | text | [en] HTML Body Preview – The HTML representation of the engagement body preview |
hs_body_preview_is_truncated | boolean | [en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview |
hs_call_app_id | float | [en] Integrating App ID – The App ID associated with the integrating app |
hs_call_authed_url_provider | text | [en] Authenticated recording files url provider – URL which returns Authenticated audio/video URL of the recording |
hs_call_body | text | [en] Call notes – The body of the call |
hs_call_callee_object_id | float | [en] Callee object id – The id of the callee |
hs_call_callee_object_type | text | [en] Callee object type – The type of callee |
hs_call_direction | text | [en] Call direction – The direction of a call |
hs_call_disposition | text | [en] Call outcome – The outcome of the call |
hs_call_duration | float | [en] Call duration – The duration of the call, in milliseconds |
hs_call_external_account_id | text | [en] External Account ID – External Account ID |
hs_call_external_id | text | [en] External ID – The external ID of the call |
hs_call_from_number | text | [en] From Number – The phone number of the person that initiated the call |
hs_call_has_transcript | boolean | [en] Transcript Available – Flag to indicate if the call has an associated transcript |
hs_call_recording_url | text | [en] Recording URL – The URL of the recorded call audio |
hs_call_source | text | [en] Call Source – The source of the call to differentiate VoIP vs Video Conferencing Apps |
hs_call_status | text | [en] Call status – The status of the call |
hs_call_title | text | [en] Call Title – The title of the call |
hs_call_to_number | text | [en] To Number – The phone number of the person that was called |
hs_call_transcription_id | float | [en] Call transcription id – The id of the transcription |
hs_call_video_recording_url | text | [en] Video url – Video URL of the recording |
hs_call_zoom_meeting_uuid | text | [en] Unique Zoom Meeting ID – The Zoom meeting unique identifier of the call |
hs_calls_service_call_id | float | [en] Calls Service Call ID – The Calls Service specific global unique identifier for a call |
hs_created_by | float | [en] Activity created by – The user who created the engagement |
hs_created_by_user_id | float | [en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified. |
hs_createdate | timestamp | [en] Create date – The date that an engagement was created |
hs_engagement_source | text | [en] Engagement Source – The source that created this engagement |
hs_engagement_source_id | text | [en] Engagement Source ID – The specific ID of the process that created this engagement |
hs_follow_up_action | text | [en] Follow up action – What action should be performed during follow up |
hs_gdpr_deleted | boolean | [en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request |
hs_lastmodifieddate | timestamp | [en] Last modified date – The date any property on this engagement was modified |
hs_merged_object_ids | text | [en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified. |
hs_modified_by | float | [en] Updated by – The user who last updated the engagement |
hs_object_id | float | [en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified. |
hs_product_name | text | [en] Product name – The name of the product associated with this engagement |
hs_queue_membership_ids | text | [en] Queue Memberships – The list of queues that contain this engagement |
hs_timestamp | timestamp | [en] Activity date – The date that an engagement occurred |
hs_unique_creation_key | text | [en] Unique creation key – Unique property used for idempotent creates |
hs_unique_id | text | [en] Unique ID – The unique ID of the engagement |
hs_unknown_visitor_conversation | boolean | [en] Unknown Visitor Conversation – Whether or not this communication was made with an unknown visitor |
hs_updated_by_user_id | float | [en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified. |
hs_user_ids_of_all_notification_followers | text | [en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications |
hs_user_ids_of_all_notification_unfollowers | text | [en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications |
hs_user_ids_of_all_owners | text | [en] User IDs of all owners – The user IDs of all owners of this object |
hubspot_owner_assigneddate | timestamp | [en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement |
hubspot_owner_id | text | [en] Activity assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows. |
hubspot_team_id | text | [en] HubSpot Team – The team of the owner of an engagement. |
hs_all_owner_ids | text | [en] All owner ids – The value of all owner referencing properties for this object, both default and custom |
hs_all_team_ids | text | [en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom |
hs_all_accessible_team_ids | text | [en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom |
This pipeline is in beta mode
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. So we're going to create an archived logs-specific integration that you can use to remove archived data from your visualization or model. We are waiting for this functionality to be released for this endpoint by HubSpot. Deleted data cannot be recovered.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Engagements: Calls: Related Objects [Current Version]
Field | Type | |
---|---|---|
calls_id | text | |
1_id | text | |
association_type | text |
This pipeline is in beta mode
Engagements: Emails [Current Version]
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
hs_all_assigned_business_unit_ids | text | [en] Business units – The business units this record is assigned to. |
hs_at_mentioned_owner_ids | text | [en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement |
hs_attachment_ids | text | [en] Attached file IDs – The IDs of the files that are attached to the engagement |
hs_body_preview | text | [en] Body preview – A truncated preview of the engagegement body |
hs_body_preview_html | text | [en] HTML Body Preview – The HTML representation of the engagement body preview |
hs_body_preview_is_truncated | boolean | [en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview |
hs_created_by | text | [en] Activity created by – The user who created the engagement |
hs_created_by_user_id | float | [en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified. |
hs_createdate | timestamp | [en] Create date – The date that an engagement was created |
hs_direction_and_unique_id | text | [en] Email direction and unique ID – The direction and unique ID of the email concatenated by : |
hs_email_attached_video_id | text | [en] Attached Video – The ID of a video optionally attached to an email |
hs_email_attached_video_name | text | [en] Attached Video Name – The name of a video optionally attached to an email |
hs_email_attached_video_opened | boolean | [en] Attached Video Opened – Has the video attachment been opened |
hs_email_attached_video_watched | boolean | [en] Attached Video Watched – Has the video attachement been watched |
hs_email_bcc_email | text | [en] Email BCC Address – Email addresses of the email's BCC recipients |
hs_email_bcc_firstname | text | [en] Email BCC First Name – First names of the email's BCC recipients |
hs_email_bcc_lastname | text | [en] Email BCC Last Name – Last names of the email's BCC recipients |
hs_email_bcc_raw | text | [en] Email BCC – Raw header values of the email's BCC recipients |
hs_email_cc_email | text | [en] Email CC Address – Email addresses of the email's CC recipients |
hs_email_cc_firstname | text | [en] Email CC First Name – First names of the email's CC recipients |
hs_email_cc_lastname | text | [en] Email CC Last Name – Last names of the email's CC recipients |
hs_email_cc_raw | text | [en] Email CC – Raw header values of the email's CC recipients |
hs_email_direction | text | [en] Email Direction – The direction the email was sent in |
hs_email_encoded_email_associations_request | text | [en] Encoded Email Associations Request – Encoded email associations request |
hs_email_error_message | text | [en] Error Message – The error that occurred while sending the email |
hs_email_facsimile_send_id | text | [en] Email Send Id – The ID of the email send event sent through Facsimile |
hs_email_from_email | text | [en] Email From Address – Email address of the email's sender |
hs_email_from_firstname | text | [en] Email From First Name – First name of the email's sender |
hs_email_from_lastname | text | [en] Email From Last Name – Last name of the email's sender |
hs_email_from_raw | text | [en] Email From – Raw header value of the email's sender |
hs_email_headers | text | [en] Email Headers – The sender and receivers of the email |
hs_email_html | text | [en] Email body – This is the body of any email sent from a record. It doesn't include emails received from contacts. |
hs_email_logged_from | text | [en] Logged From – Where the email was logged |
hs_email_media_processing_status | text | [en] Media Processing Status – Processing status for this email's images and attachments |
hs_email_member_of_forwarded_subthread | boolean | [en] Email is member of forwarded subthread – Whether this email is a member of a forwarded subthread |
hs_email_message_id | text | [en] Message ID – The ID of the message |
hs_email_migrated_via_portal_data_migration | boolean | [en] email_migrated_via_portal_data_migration – Indicates that the email was migrated from another portal using DataMigration tool |
hs_email_pending_inline_image_ids | text | [en] Email pending inline image file IDs – File IDs of pending inline images in the email's HTML |
hs_email_post_send_status | text | [en] Post-Send Status – A description of what happened to the email (successful send, bounced, dropped) and why |
hs_email_recipient_drop_reasons | text | [en] Recipient-Drop Reasons – A list of the dropped recipients paired with the reason each was dropped |
hs_email_send_event_id | text | [en] Email Send Event Id – The ID of the email send event |
hs_email_send_event_id_created | timestamp | [en] Email Send Event Id Created – The date when the email send event ID was created |
hs_email_sender_email | text | [en] Email Sender Address – Email address of the email's sender |
hs_email_sender_firstname | text | [en] Email Sender First Name – First name of the email's sender |
hs_email_sender_lastname | text | [en] Email Sender Last Name – Last name of the email's sender |
hs_email_sender_raw | text | [en] Email Sender – Raw header value of the email's sender |
hs_email_sent_via | text | [en] Sent Via – How the email was sent |
hs_email_status | text | [en] Email send status – The send status of the email |
hs_email_subject | text | [en] Email subject – The subject of the email |
hs_email_text | text | [en] Text – The plaintext of the email |
hs_email_thread_id | text | [en] Thread ID – The thread that the email belongs to |
hs_email_to_email | text | [en] Email To Address – Email addresses of the email's recipients |
hs_email_to_firstname | text | [en] Email To First Name – First names of the email's recipients |
hs_email_to_lastname | text | [en] Email To Last Name – Last names of the email's recipients |
hs_email_to_raw | text | [en] Email To – Raw header values of the email's recipients |
hs_email_tracker_key | text | [en] Tracker Key – The tracker key of the email |
hs_email_validation_skipped | text | [en] Validation Skipped – Validation skipped that would have otherwise rejected logging |
hs_engagement_source | text | [en] Engagement Source – The source that created this engagement |
hs_engagement_source_id | text | [en] Engagement Source ID – The specific ID of the process that created this engagement |
hs_follow_up_action | text | [en] Follow up action – What action should be performed during follow up |
hs_gdpr_deleted | boolean | [en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request |
hs_lastmodifieddate | timestamp | [en] Last modified date – The date any property on this engagement was modified |
hs_merged_object_ids | text | [en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified. |
hs_modified_by | text | [en] Updated by – The user who last updated the engagement |
hs_object_id | float | [en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified. |
hs_product_name | text | [en] Product name – The name of the product associated with this engagement |
hs_queue_membership_ids | text | [en] Queue Memberships – The list of queues that contain this engagement |
hs_timestamp | timestamp | [en] Activity date – The date that an engagement occurred |
hs_unique_creation_key | text | [en] Unique creation key – Unique property used for idempotent creates |
hs_unique_id | text | [en] Unique ID – The unique ID of the engagement |
hs_updated_by_user_id | float | [en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified. |
hs_user_ids_of_all_notification_followers | text | [en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications |
hs_user_ids_of_all_notification_unfollowers | text | [en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications |
hs_user_ids_of_all_owners | text | [en] User IDs of all owners – The user IDs of all owners of this object |
hubspot_owner_assigneddate | timestamp | [en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement |
hubspot_owner_id | text | [en] Activity assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows. |
hubspot_team_id | text | [en] HubSpot Team – The team of the owner of an engagement. |
hs_all_owner_ids | text | [en] All owner ids – The value of all owner referencing properties for this object, both default and custom |
hs_all_team_ids | text | [en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom |
hs_all_accessible_team_ids | text | [en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom |
This pipeline is in beta mode
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. So we're going to create an archived logs-specific integration that you can use to remove archived data from your visualization or model. We are waiting for this functionality to be released for this endpoint by HubSpot. Deleted data cannot be recovered.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Engagements: Emails: Related Objects [Current Version]
Field | Type | |
---|---|---|
emails_id | text | |
1_id | text | |
association_type | text |
This pipeline is in beta mode
Engagements: Meetings [Current Version]
Main Object
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
hs_activity_type | text | [en] Call and meeting type – The activity type of the engagement |
hs_all_assigned_business_unit_ids | text | [en] Business units – The business units this record is assigned to. |
hs_at_mentioned_owner_ids | text | [en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement |
hs_attachment_ids | text | [en] Attached file IDs – The IDs of the files that are attached to the engagement |
hs_attendee_owner_ids | text | [en] HubSpot attendee owner IDs – List of HubSpot owner IDs for additional attendees |
hs_body_preview | text | [en] Body preview – A truncated preview of the engagegement body |
hs_body_preview_html | text | [en] HTML Body Preview – The HTML representation of the engagement body preview |
hs_body_preview_is_truncated | boolean | [en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview |
hs_created_by | float | [en] Activity created by – The user who created the engagement |
hs_created_by_user_id | float | [en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified. |
hs_createdate | timestamp | [en] Create date – The date that an engagement was created |
hs_engagement_source | text | [en] Engagement Source – The source that created this engagement |
hs_engagement_source_id | text | [en] Engagement Source ID – The specific ID of the process that created this engagement |
hs_follow_up_action | text | [en] Follow up action – What action should be performed during follow up |
hs_gdpr_deleted | boolean | [en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request |
hs_i_cal_uid | text | [en] iCalUid – The iCalUid of the synced event |
hs_internal_meeting_notes | text | [en] Internal Meeting Notes – |
hs_lastmodifieddate | timestamp | [en] Last modified date – The date any property on this engagement was modified |
hs_meeting_body | text | [en] Meeting description – The text description of the meeting |
hs_meeting_calendar_event_hash | text | [en] Meeting calendar event hash – The unique hash for the meeting |
hs_meeting_change_id | text | [en] Meeting change id – The unique change id for the meeting |
hs_meeting_created_from_link_id | text | [en] Created From Link ID – Created From Link ID |
hs_meeting_end_time | timestamp | [en] Meeting end time – The date when the meeting ends |
hs_meeting_external_url | text | [en] External URL – The external URL for the meeting |
hs_meeting_location | text | [en] Meeting location – Where the meeting takes place |
hs_meeting_location_type | text | [en] Location type – The type of location for the meeting event |
hs_meeting_outcome | text | [en] Meeting outcome – The outcome of this meeting |
hs_meeting_pre_meeting_prospect_reminders | text | [en] Pre-meeting prospect reminders – A list of dates when meeting reminders should be sent to prospects |
hs_meeting_source | text | [en] Meeting source – The source where the meeting was booked |
hs_meeting_source_id | text | [en] Source ID – The source ID of the meeting |
hs_meeting_start_time | timestamp | [en] Meeting start time – The date when the meeting starts |
hs_meeting_title | text | [en] Meeting name – The title of the meeting |
hs_meeting_web_conference_meeting_id | text | [en] Web conference meeting ID – The meeting ID of the web conference |
hs_merged_object_ids | text | [en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified. |
hs_modified_by | float | [en] Updated by – The user who last updated the engagement |
hs_object_id | float | [en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified. |
hs_product_name | text | [en] Product name – The name of the product associated with this engagement |
hs_queue_membership_ids | text | [en] Queue Memberships – The list of queues that contain this engagement |
hs_scheduled_tasks | text | [en] Scheduled tasks |
hs_timestamp | timestamp | [en] Activity date – The date that an engagement occurred |
hs_unique_creation_key | text | [en] Unique creation key – Unique property used for idempotent creates |
hs_unique_id | text | [en] Unique ID – The unique ID of the engagement |
hs_updated_by_user_id | float | [en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified. |
hs_user_ids_of_all_notification_followers | text | [en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications |
hs_user_ids_of_all_notification_unfollowers | text | [en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications |
hs_user_ids_of_all_owners | text | [en] User IDs of all owners – The user IDs of all owners of this object |
hubspot_owner_assigneddate | timestamp | [en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement |
hubspot_owner_id | text | [en] Activity assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows. |
hubspot_team_id | text | [en] HubSpot Team – The team of the owner of an engagement. |
hs_all_owner_ids | text | [en] All owner ids – The value of all owner referencing properties for this object, both default and custom |
hs_all_team_ids | text | [en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom |
hs_all_accessible_team_ids | text | [en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom |
hubspot_engagements_meetings_scheduledtasks
Field | Type | |
---|---|---|
meeting_id | text | |
timestamp | timestamp | |
portalid | text | |
engagementtype | text | |
tasktype | text | |
uuid | text |
This pipeline is in beta mode
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. So we're going to create an archived logs-specific integration that you can use to remove archived data from your visualization or model. We are waiting for this functionality to be released for this endpoint by HubSpot. Deleted data cannot be recovered.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Engagements: Meetings: Related Objects [Current Version]
Field | Type | |
---|---|---|
meetings_id | text | |
1_id | text | |
association_type | text |
This pipeline is in beta mode
Engagements: Notes [Current Version]
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
hs_all_assigned_business_unit_ids | text | [en] Business units – The business units this record is assigned to. |
hs_at_mentioned_owner_ids | text | [en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement |
hs_attachment_ids | text | [en] Attached file IDs – The IDs of the files that are attached to the engagement |
hs_body_preview | text | [en] Body preview – A truncated preview of the engagegement body |
hs_body_preview_html | text | [en] HTML Body Preview – The HTML representation of the engagement body preview |
hs_body_preview_is_truncated | boolean | [en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview |
hs_created_by | float | [en] Activity created by – The user who created the engagement |
hs_created_by_user_id | float | [en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified. |
hs_createdate | timestamp | [en] Create date – The date that an engagement was created |
hs_engagement_source | text | [en] Engagement Source – The source that created this engagement |
hs_engagement_source_id | text | [en] Engagement Source ID – The specific ID of the process that created this engagement |
hs_follow_up_action | text | [en] Follow up action – What action should be performed during follow up |
hs_gdpr_deleted | boolean | [en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request |
hs_lastmodifieddate | timestamp | [en] Last modified date – The date any property on this engagement was modified |
hs_merged_object_ids | text | [en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified. |
hs_modified_by | float | [en] Updated by – The user who last updated the engagement |
hs_note_body | text | [en] Note body – The body of the note |
hs_object_id | float | [en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified. |
hs_product_name | text | [en] Product name – The name of the product associated with this engagement |
hs_queue_membership_ids | text | [en] Queue Memberships – The list of queues that contain this engagement |
hs_timestamp | timestamp | [en] Activity date – The date that an engagement occurred |
hs_unique_creation_key | text | [en] Unique creation key – Unique property used for idempotent creates |
hs_unique_id | text | [en] Unique ID – The unique ID of the engagement |
hs_updated_by_user_id | float | [en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified. |
hs_user_ids_of_all_notification_followers | text | [en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications |
hs_user_ids_of_all_notification_unfollowers | text | [en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications |
hs_user_ids_of_all_owners | text | [en] User IDs of all owners – The user IDs of all owners of this object |
hubspot_owner_assigneddate | timestamp | [en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement |
hubspot_owner_id | text | [en] Activity assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows. |
hubspot_team_id | text | [en] HubSpot Team – The team of the owner of an engagement. |
hs_all_owner_ids | text | [en] All owner ids – The value of all owner referencing properties for this object, both default and custom |
hs_all_team_ids | text | [en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom |
hs_all_accessible_team_ids | text | [en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom |
This pipeline is in beta mode
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. So we're going to create an archived logs-specific integration that you can use to remove archived data from your visualization or model. We are waiting for this functionality to be released for this endpoint by HubSpot. Deleted data cannot be recovered.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Engagements: Notes: Related Objects [Current Version]
Field | Type | |
---|---|---|
notes_id | text | |
1_id | text | |
association_type | text |
This pipeline is in beta mode
Engagements: Tasks [Current Version]
Main object
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
hs_all_assigned_business_unit_ids | text | [en] Business units – The business units this record is assigned to. |
hs_at_mentioned_owner_ids | text | [en] At-Mentioned Owner Ids – The owners that have been at-mentioned on the engagement |
hs_attachment_ids | text | [en] Attached file IDs – The IDs of the files that are attached to the engagement |
hs_body_preview | text | [en] Notes (preview) – A plain-text preview of the notes field on a task |
hs_body_preview_html | text | [en] HTML Body Preview – The HTML representation of the engagement body preview |
hs_body_preview_is_truncated | boolean | [en] Body Preview Truncated – Indicates if the engagement body was truncated for the preview |
hs_calendar_event_id | text | [en] Calendar Event ID – The event ID for the synced task. |
hs_created_by | float | [en] Created by – The user who created the engagement |
hs_created_by_user_id | float | [en] Created by user ID – The user that created this object. This value is automatically set by HubSpot and may not be modified. |
hs_createdate | timestamp | [en] Created at – The date that an engagement was created |
hs_engagement_source | text | [en] Source – The source that created this engagement |
hs_engagement_source_id | text | [en] Source ID – The specific ID of the process that created this engagement |
hs_follow_up_action | text | [en] Follow up action – What action should be performed during follow up |
hs_gdpr_deleted | boolean | [en] GDPR deleted – Indicates the body of this engagement has been cleared because of a GDPR delete request |
hs_lastmodifieddate | timestamp | [en] Last modified at – The date any property on this engagement was modified |
hs_merged_object_ids | text | [en] Merged object IDs – The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified. |
hs_modified_by | float | [en] Last modified by – The user who last updated the engagement |
hs_msteams_message_id | text | [en] MS Teams message ID – The message ID for the created task. |
hs_num_associated_companies | float | [en] Associated Companies – The number of companies associated with this task |
hs_num_associated_contacts | float | [en] Associated Contacts – The number of contacts associated with this task |
hs_num_associated_deals | float | [en] Associated Deals – The number of deals associated with this task |
hs_num_associated_queue_objects | float | [en] Associated Queue Objects – The number of objects associated with this task that support task queues |
hs_num_associated_tickets | float | [en] Associated Tickets – The number of tickets associated with this task |
hs_object_id | float | [en] Object ID – The unique ID for this object. This value is automatically set by HubSpot and may not be modified. |
hs_product_name | text | [en] Product name – The name of the product associated with this engagement |
hs_queue_membership_ids | text | [en] Queue – The list of queues that contain this engagement |
hs_task_body | text | [en] Notes – The content in the notes field on a task |
hs_task_completion_date | timestamp | [en] Completed at – The date that the task was completed |
hs_task_contact_timezone | text | [en] Contact Time Zone – The time zone of the associated contact |
hs_task_for_object_type | text | [en] For Object Type – The object type for the task |
hs_task_is_all_day | boolean | [en] Task is all day – Determines if the task is due all day or at a specific time |
hs_task_last_contact_outreach | timestamp | [en] Last contacted – The last time a call, email, or meeting was logged for the associated contact. This is set automatically by HubSpot based on user actions in the contact record |
hs_task_last_sales_activity_timestamp | timestamp | [en] Last engagement – The date of the last sales activity with the associated contact. This is set automatically by HubSpot based on user actions in the contact record |
hs_task_priority | text | [en] Priority – The priority of task |
hs_task_probability_to_complete | float | [en] Task probability to complete – The probability the task will be completed |
hs_task_relative_reminders | text | [en] Relative Task Reminders – The dates (relative to the due date) when reminders will be sent |
hs_task_reminders | text | [en] Reminder – The dates when reminders will be sent |
hs_task_repeat_interval | text | [en] Interval – How often the task should repeat |
hs_task_send_default_reminder | text | [en] Send Default Reminder – Whether or not a reminder should be sent when the task is due |
hs_task_sequence_enrollment_active | boolean | [en] Sequence Enrollment Is Active – Whether the sequence enrollment this task is a part of is currently active |
hs_task_sequence_step_enrollment_id | text | [en] Sequence step enrollment Id – The id of the sequence step that created the task |
hs_task_sequence_step_order | float | [en] Sequence Step Order – The order of this task in the sequence at time of enrollment |
hs_task_status | text | [en] Status – The status of the task |
hs_task_subject | text | [en] Title – The subject text for the task |
hs_task_template_id | float | [en] Task template id – The id of template the task was created from |
hs_task_type | text | [en] Type – The type of task |
hs_timestamp | timestamp | [en] Due date – The date that an engagement occurred |
hs_unique_creation_key | text | [en] Unique creation key – Unique property used for idempotent creates |
hs_unique_id | text | [en] Unique ID – The unique ID of the engagement |
hs_updated_by_user_id | float | [en] Updated by user ID – The user that last updated this object. This value is automatically set by HubSpot and may not be modified. |
hs_user_ids_of_all_notification_followers | text | [en] User IDs of all notification followers – The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications |
hs_user_ids_of_all_notification_unfollowers | text | [en] User IDs of all notification unfollowers – The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications |
hs_user_ids_of_all_owners | text | [en] User IDs of all owners – The user IDs of all owners of this object |
hubspot_owner_assigneddate | timestamp | [en] Owner Assigned Date – The timestamp when an owner was assigned to this engagement |
hubspot_owner_id | text | [en] Assigned to – The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows. |
hubspot_team_id | text | [en] HubSpot Team – The team of the owner of an engagement. |
hs_all_owner_ids | text | [en] All owner ids – The value of all owner referencing properties for this object, both default and custom |
hs_all_team_ids | text | [en] All team ids – The team ids corresponding to all owner referencing properties for this object, both default and custom |
hs_all_accessible_team_ids | text | [en] All accessible team ids – The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom |
hubspot_engagements_tasks_scheduledtasks
Field | Type | |
---|---|---|
task_id | text | |
timestamp | timestamp | |
portalid | text | |
engagementtype | text | |
tasktype | text | |
uuid | text |
This pipeline is in beta mode
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. So we're going to create an archived logs-specific integration that you can use to remove archived data from your visualization or model. We are waiting for this functionality to be released for this endpoint by HubSpot. Deleted data cannot be recovered.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Engagements: Tasks: Related Objects [Current Version]
Field | Type | |
---|---|---|
tasks_id | text | |
1_id | text | |
association_type | text |
This pipeline is in beta mode
Line Items
This pipeline will bring the Line Items and all their properties in a columnar format – according to your account configuration, in a format similar to the one below:
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
property_x | text | |
property_y | text | |
property_z | text |
This pipeline does not capture deletions and archives: if a record is removed by archiving or deletion, this will not be reflected in your pipeline. That's why we created a dedicated archived logs pipeline that you can use to remove archived data from your visualization or model. Deleted data cannot be recovered.
By default, all existing custom properties in your account will be brought over. However, using too many properties can impact data reading speed. We recommend that you use only the necessary properties, selecting the ones you want on the pipeline creation/editing screen, when naming the tables, just click on FIELDS and uncheck/check the desired properties/columns.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Archived Line Items [Current Version]
Field | Type | |
---|---|---|
id | text | |
archived | boolean | |
archivedat | timestamp | |
createdat | timestamp | |
properties__amount | float | |
properties__createdate | timestamp | |
properties__hs_lastmodifieddate | timestamp | |
properties__hs_product_id | text | |
properties__quantity | float | |
updatedat | timestamp |
Line Items: Related Deals
Field | Type | |
---|---|---|
line_item_id | text | |
deal_id | text | |
association_type | text |
Products
This pipeline will bring the Products and all their properties in columnar format – according to your account configuration, in a format similar to the one below:
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
property_x | text | |
property_y | text | |
property_z | text |
By default, all existing custom properties in your account will be brought over. However, using too many properties can impact data reading speed. We recommend that you use only the necessary properties, selecting the ones you want on the pipeline creation/editing screen, when naming the tables, just click on FIELDS and uncheck/check the desired properties/columns.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
Feedback Submissions
This pipeline will bring the Net Promoter Score (NPS), Customer Satisfaction (CSAT), Customer Effort Score (CES) and Custom Surveys and all their properties in columnar format – according to your account configuration, in a format similar to below:
Field | Type | |
---|---|---|
id | text | |
createdat | timestamp | |
updatedat | timestamp | |
archived | boolean | |
property_x | text | |
property_y | text | |
property_z | text |
By default, all existing custom properties in your account will be brought over. However, using too many properties can impact data reading speed. We recommend that you use only the necessary properties, selecting the ones you want on the pipeline creation/editing screen, when naming the tables, just click on FIELDS and uncheck/check the desired properties/columns.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed.
By default, all existing custom properties in your account will be brought over. However, using too many properties can impact data reading speed. We recommend that you use only the necessary properties, selecting the ones you want on the pipeline creation/editing screen, when naming the tables, just click on FIELDS and uncheck/check the desired properties/columns.
If during an execution, more than 10,000 updated records are found within a period of 100 milliseconds, a full execution will be performed