HubSpot

Archived companies

Replication type: Full

Relationships:

id → Companies > id

HubSpot Deleted Companies - IDs of companies that were archived/deleted in HubSpot (soft-delete tracking)

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record Companies > > id
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
archivedat	timestamp	[en] Archived at - Date and time the record was archived in HubSpot
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
properties__createdate	timestamp	[en] Property createdate - The CRM object property "createdate" value
properties__domain	text	[en] Property domain - The CRM object property "domain" value
properties__hs_lastmodifieddate	timestamp	[en] Property hs_lastmodifieddate - The CRM object property "hs_lastmodifieddate" value
properties__name	text	[en] Property name - The CRM object property "name" value
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot

Archived contacts

Replication type: Full

Relationships:

id → Contacts > id

HubSpot Deleted Contacts - IDs of contacts that were archived/deleted in HubSpot (soft-delete tracking)

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record Contacts > > id
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
archivedat	timestamp	[en] Archived at - Date and time the record was archived in HubSpot
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
properties__createdate	timestamp	[en] Property createdate - The CRM object property "createdate" value
properties__email	text	[en] Property email - The CRM object property "email" value
properties__firstname	text	[en] Property firstname - The CRM object property "firstname" value
properties__lastmodifieddate	timestamp	[en] Property lastmodifieddate - The CRM object property "lastmodifieddate" value
properties__lastname	text	[en] Property lastname - The CRM object property "lastname" value
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot

Archived deals

Replication type: Full

Relationships:

id → Deals > id

HubSpot Deleted Deals - IDs of deals that were archived/deleted in HubSpot (soft-delete tracking)

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record Deals > > id
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
archivedat	timestamp	[en] Archived at - Date and time the record was archived in HubSpot
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
properties__amount	float	[en] Property amount - The CRM object property "amount" value
properties__closedate	timestamp	[en] Property closedate - The CRM object property "closedate" value
properties__createdate	timestamp	[en] Property createdate - The CRM object property "createdate" value
properties__dealname	text	[en] Property dealname - The CRM object property "dealname" value
properties__dealstage	text	[en] Property dealstage - The CRM object property "dealstage" value
properties__hs_lastmodifieddate	timestamp	[en] Property hs_lastmodifieddate - The CRM object property "hs_lastmodifieddate" value
properties__pipeline	text	[en] Property pipeline - The CRM object property "pipeline" value
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot

Archived line items

Replication type: Full

Relationships:

id → Line Items > id

HubSpot Deleted Line Items - IDs of line items that were archived/deleted in HubSpot (soft-delete tracking)

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record Line Items > > id
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
archivedat	timestamp	[en] Archived at - Date and time the record was archived in HubSpot
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
properties__amount	float	[en] Property amount - The CRM object property "amount" value
properties__createdate	timestamp	[en] Property createdate - The CRM object property "createdate" value
properties__hs_lastmodifieddate	timestamp	[en] Property hs_lastmodifieddate - The CRM object property "hs_lastmodifieddate" value
properties__hs_product_id	text	[en] Property hs_product_id - The CRM object property "hs_product_id" value
properties__quantity	float	[en] Property quantity - The CRM object property "quantity" value
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot

Archived tickets

Replication type: Full

Relationships:

id → Tickets > id

HubSpot Deleted Tickets - IDs of tickets that were archived/deleted in HubSpot (soft-delete tracking)

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record Tickets > > id
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
archivedat	timestamp	[en] Archived at - Date and time the record was archived in HubSpot
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
properties__content	text	[en] Property content - The CRM object property "content" value
properties__createdate	timestamp	[en] Property createdate - The CRM object property "createdate" value
properties__hs_lastmodifieddate	timestamp	[en] Property hs_lastmodifieddate - The CRM object property "hs_lastmodifieddate" value
properties__hs_pipeline	text	[en] Property hs_pipeline - The CRM object property "hs_pipeline" value
properties__hs_pipeline_stage	text	[en] Property hs_pipeline_stage - The CRM object property "hs_pipeline_stage" value
properties__hs_ticket_category	text	[en] Property hs_ticket_category - The CRM object property "hs_ticket_category" value
properties__hs_ticket_priority	text	[en] Property hs_ticket_priority - The CRM object property "hs_ticket_priority" value
properties__subject	text	[en] Property subject - The CRM object property "subject" value
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot

Associations

Replication type: Incremental

Parameters:

To: Select the object from which to get associations
From: Select the object to which to get associations

HubSpot Custom Object Associations - Relationships between custom objects

Campo	Tipo
from_object_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association
to_object_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association
association_type	text	[en] Association type - The type/label of the association between the two objects
association_type_id	int	[en] Association type ID - HubSpot associationTypeId (e.g. 175 for "Indicado")
association_label	text	[en] Association label - Human-readable label of the association as defined in HubSpot (null when no user-defined label exists)
association_category	text	[en] Association category - HUBSPOT_DEFINED, USER_DEFINED or INTEGRATOR_DEFINED

Companies

This pipeline will bring companies and all their properties in a columnar format, according to your account settings, in a format similar to the one below.
This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline.
A specific pipeline for archived records is available to remove archived data from your view or model. Deleted data cannot be recovered
By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed.
It is recommended to use only necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, click on FIELDS and uncheck/check the desired properties/columns
If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

HubSpot Deals - Sales opportunities (deals) and their properties

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Companies: related contacts

Replication type: Incremental

Relationships:

company_id → Companies > id
contact_id → Contacts > id

HubSpot Company-Contact Associations - Relationships between companies and contacts

Campo	Tipo
company_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Companies > > id
contact_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Contacts > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

company_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Companies > > id

contact_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Contacts > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Companies: related deals

Replication type: Incremental

Relationships:

company_id → Companies > id
deal_id → Deals > id

HubSpot Company-Deal Associations - Relationships between companies and deals

Campo	Tipo
company_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Companies > > id
deal_id	text	[en] Deal ID - The HubSpot ID of the associated deal Deals > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

company_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Companies > > id

deal_id

text

[en] Deal ID - The HubSpot ID of the associated deal

Deals > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Companies: related tickets

Replication type: Incremental

Relationships:

company_id → Companies > id
ticket_id → Tickets > id

HubSpot Company-Ticket Associations - Relationships between companies and tickets

Campo	Tipo
company_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Companies > > id
ticket_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Tickets > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

company_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Companies > > id

ticket_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Tickets > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Contact lists

Replication type: Full

HubSpot Contact Lists - Definitions of contact lists (static and dynamic) and their metadata

Campo	Tipo
listid	text	[en] List ID - The ID of the contact list
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
authorid	text	[en] Author ID - The ID of the author of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
deleteable	boolean	[en] Deleteable - Indicates whether the property can be deleted
dynamic	boolean	[en] Dynamic - Indicates whether the property is dynamic
internallistid	text	[en] Internal list ID - The internal HubSpot ID of the contact list
listtype	text	[en] List type - The type of the contact list (static or dynamic)
metadata__lastprocessingstatechangeat	timestamp	[en] Last processing state change - When the list processing state last changed
metadata__lastsizechangeat	timestamp	[en] Last size change - When the list size last changed
metadata__processing	text	[en] Processing status - The processing status of the list
metadata__size	float	[en] List size - The number of contacts currently in the list
name	text	[en] Property name - The internal name of the property
portalid	text	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
readonly	boolean	[en] Read-only - Whether the value is read-only
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot

Contacts

This pipeline will bring contacts and all their properties in a columnar format, according to your account settings, in a format similar to the one below
This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we have created a specific pipeline for archived records that you can use to remove archived data from your view or model. Deleted data cannot be recovered.
By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed. We recommend using only the necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, simply click on FIELDS and uncheck/check the desired properties/columns.
If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed

Replication type: Incremental

HubSpot Contacts - Individual people and their contact information

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Contacts: form submissions

This pipeline is based on the Contacts pipeline from the previous version of the API, and its update depends on the change in the contact's lastmodifieddate property. Additionally, learn more about the savepoint calculation in this changelog

Replication type: Incremental

Relationships:

vid → Contacts > id

Main object

HubSpot Contact Form Submissions - Form submissions associated with contacts

Campo	Tipo
vid	text	[en] Visitor ID (vid) - The legacy HubSpot contact identifier Contacts > > id
conversion_id	text	[en] Conversion ID - The ID of the form conversion
canonical_url	text	[en] Canonical URL - The canonical profile URL of the contact
content_type	text	[en] Content type - The type of content associated with the submission
form_id	text	[en] Form ID - The ID of the form
form_type	text	[en] Form type - The type of the form
page_id	text	[en] Page ID - The ID of the page
page_title	text	[en] Page title - The title of the page
page_url	text	[en] Page URL - The URL of the page
portal_id	text	[en] Portal ID - The HubSpot account (portal) ID
timestamp	timestamp	[en] Timestamp - The date and time associated with the record/event
title	text	[en] Title - The title text

contacts_form_submissions__contact_associated_by

HubSpot Contact Form Submissions (associated by) - How each form submission was associated to a contact

Campo	Tipo
vid	text	[en] Visitor ID (vid) - The legacy HubSpot contact identifier
conversion_id	text	[en] Conversion ID - The ID of the form conversion
associated_by	text	[en] Associated by - How the submission was associated to the contact

Contacts: lists membership

This pipeline is based on the Contacts pipeline from the previous version of the API, and its update depends on the change in the contact's lastmodifieddate property. Additionally, learn more about the savepoint calculation in this changelog.

Replication type: Incremental

Relationships:

vid → Contacts > id
static_list_id → Contact lists > listid

HubSpot Contact List Memberships - Which contacts belong to which contact lists

Campo	Tipo
vid	text	[en] Visitor ID (vid) - The legacy HubSpot contact identifier Contacts > > id
timestamp	timestamp	[en] Timestamp - The date and time associated with the record/event
static_list_id	text	[en] Static list ID - The static list ID Contact lists > > listid
internal_list_id	text	[en] Internal list ID - The internal HubSpot ID of the list
is_member	boolean	[en] Is member - Whether the contact is a member of the list

Contacts: related companies

Replication type: Incremental

Relationships:

contact_id → Contacts > id
company_id → Companies > id

HubSpot Contact-Ticket Associations - Relationships between contacts and tickets

Campo	Tipo
contact_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Contacts > > id
company_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Companies > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

contact_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Contacts > > id

company_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Companies > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Contacts: related deals

Replication type: Incremental

Relationships:

contact_id → Contacts > id
deal_id → Deals > id

HubSpot Contact-Ticket Associations - Relationships between contacts and tickets

Campo	Tipo
contact_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Contacts > > id
deal_id	text	[en] Deal ID - The HubSpot ID of the associated deal Deals > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

contact_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Contacts > > id

deal_id

text

[en] Deal ID - The HubSpot ID of the associated deal

Deals > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Contacts: related tickets

Replication type: Incremental

Relationships:

contact_id → Contacts > id
ticket_id → Tickets > id

HubSpot Contact-Ticket Associations - Relationships between contacts and tickets

Campo	Tipo
contact_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Contacts > > id
ticket_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Tickets > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

contact_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Contacts > > id

ticket_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Tickets > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Custom object

By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed. We recommend using only the necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, simply click on FIELDS and uncheck/check the desired properties/columns.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

Parameters:

Object: Select the custom object

HubSpot Custom Objects - User-defined custom objects and their properties

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Deals

This pipeline will bring deals and all their properties in a columnar format, according to your account settings, in a format similar to the one below.

This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we have created a specific pipeline for archived records that you can use to remove archived data from your view or model. Deleted data cannot be recovered.

By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed. We recommend using only the necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, simply click on FIELDS and uncheck/check the desired properties/columns.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

HubSpot Deals - Sales opportunities (deals) and their properties

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Deals: related companies

Replication type: Incremental

Relationships:

deal_id → Deals > id
company_id → Companies > id

HubSpot Deal-Contact Associations - Relationships between deals and contacts

Campo	Tipo
deal_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Deals > > id
company_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Companies > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

deal_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Deals > > id

company_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Companies > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Deals: related contacts

Replication type: Incremental

Relationships:

deal_id → Deals > id
contact_id → Contacts > id

HubSpot Deal-Contact Associations - Relationships between deals and contacts

Campo	Tipo
deal_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Deals > > id
contact_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Contacts > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

deal_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Deals > > id

contact_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Contacts > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Deals: related tickets

Replication type: Incremental

Relationships:

deal_id → Deals > id
ticket_id → Tickets > id

HubSpot Deal-Contact Associations - Relationships between deals and contacts

Campo	Tipo
deal_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Deals > > id
ticket_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Tickets > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

deal_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Deals > > id

ticket_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Tickets > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Email events

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial replication date
Evento: Select the event to be replicated

Relationships:

emailcampaignid > delivered → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > statuschange → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > dropped → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > deferred → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > open → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > spamreport → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > bounce → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > click → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > sent → Marketing Emails > email_campaigns > email_campaign_id
emailcampaignid > processed → Marketing Emails > email_campaigns > email_campaign_id

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
appname	text	[en] App name - The name of the HubSpot application that generated the event
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
emailcampaigngroupid	float	[en] Email campaign group ID - The ID grouping related email campaign versions
recipient	text	[en] Recipient - The email address of the message recipient
response	text	[en] Response - The server response message for the email event
attempt	float	[en] Attempt - The delivery attempt number for the email
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
type	text	[en] Association type - The type/label of the association between the two objects

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
source	text	[en] Source - The source that originated the record/event
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
subscriptions	text	[en] Subscriptions - The list of subscriptions associated with the record
sourceid	text	[en] Source ID - The identifier of the source that originated the record
type	text	[en] Association type - The type/label of the association between the two objects
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
recipient	text	[en] Recipient - The email address of the message recipient

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
appname	text	[en] App name - The name of the HubSpot application that generated the event
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
emailcampaigngroupid	float	[en] Email campaign group ID - The ID grouping related email campaign versions
recipient	text	[en] Recipient - The email address of the message recipient
dropreason	text	[en] Drop reason - The reason code for why the email was dropped
attempt	float	[en] Attempt - The delivery attempt number for the email
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
type	text	[en] Association type - The type/label of the association between the two objects
dropmessage	text	[en] Drop message - The message describing why the email was dropped

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
appname	text	[en] App name - The name of the HubSpot application that generated the event
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
emailcampaigngroupid	float	[en] Email campaign group ID - The ID grouping related email campaign versions
recipient	text	[en] Recipient - The email address of the message recipient
response	text	[en] Response - The server response message for the email event
attempt	float	[en] Attempt - The delivery attempt number for the email
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
type	text	[en] Association type - The type/label of the association between the two objects

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
appname	text	[en] App name - The name of the HubSpot application that generated the event
type	text	[en] Association type - The type/label of the association between the two objects
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
devicetype	text	[en] Device type - The type of device used by the recipient
location__country	text	[en] Location country - The country derived from the recipient IP
location__state	text	[en] Location state - The state/region derived from the recipient IP
location__zipcode	text	[en] Location zipcode - The postal code derived from the recipient IP
location__city	text	[en] Location city - The city derived from the recipient IP
filteredevent	boolean	[en] Filtered event - Indicates whether the event was filtered out
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
duration	float	[en] Duration - The duration value associated with the event
useragent	text	[en] User agent - The user-agent string of the recipient device/browser
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
recipient	text	[en] Recipient - The email address of the message recipient
id	text	[en] Record ID - The unique HubSpot identifier of the record
browser__family	text	[en] Browser family - The browser family of the recipient
browser__name	text	[en] Browser name - The name of the recipient browser
browser__producer	text	[en] Browser producer - The producer/vendor of the recipient browser
browser__url	text	[en] Browser URL - The URL associated with the browser
browser__producerurl	text	[en] Browser producer URL - The URL of the browser producer
browser__version	text	[en] Browser version - The version of the recipient browser
browser__type	text	[en] Browser type - The type/category of the recipient browser

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
appname	text	[en] App name - The name of the HubSpot application that generated the event
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
recipient	text	[en] Recipient - The email address of the message recipient
attempt	text	[en] Attempt - The delivery attempt number for the email
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
type	text	[en] Association type - The type/label of the association between the two objects

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
status	text	[en] Status - The status of the record
appname	text	[en] App name - The name of the HubSpot application that generated the event
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
emailcampaigngroupid	float	[en] Email campaign group ID - The ID grouping related email campaign versions
recipient	text	[en] Recipient - The email address of the message recipient
response	text	[en] Response - The server response message for the email event
category	text	[en] Category - The category classification of the email event
attempt	float	[en] Attempt - The delivery attempt number for the email
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
type	text	[en] Association type - The type/label of the association between the two objects

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
type	text	[en] Association type - The type/label of the association between the two objects
appname	text	[en] App name - The name of the HubSpot application that generated the event
url	text	[en] URL - The URL associated with the event (e.g. the clicked link)
linkid	float	[en] Link ID - The ID of the link associated with the click event
useragent	text	[en] User agent - The user-agent string of the recipient device/browser
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
emailcampaigngroupid	float	[en] Email campaign group ID - The ID grouping related email campaign versions
referer	text	[en] Referer - The referring URL associated with the email event
location__country	text	[en] Location country - The country derived from the recipient IP
location__state	text	[en] Location state - The state/region derived from the recipient IP
location__city	text	[en] Location city - The city derived from the recipient IP
filteredevent	boolean	[en] Filtered event - Indicates whether the event was filtered out
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
devicetype	text	[en] Device type - The type of device used by the recipient
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
recipient	text	[en] Recipient - The email address of the message recipient
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
browser__family	text	[en] Browser family - The browser family of the recipient
browser__name	text	[en] Browser name - The name of the recipient browser
browser__producer	text	[en] Browser producer - The producer/vendor of the recipient browser
browser__url	text	[en] Browser URL - The URL associated with the browser
browser__producerurl	text	[en] Browser producer URL - The URL of the browser producer
browser__version	text	[en] Browser version - The version of the recipient browser
browser__type	text	[en] Browser type - The type/category of the recipient browser

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
from	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association
appname	text	[en] App name - The name of the HubSpot application that generated the event
replyto	text	[en] Reply-to - The reply-to address of the email
type	text	[en] Association type - The type/label of the association between the two objects
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
bcc	text	[en] BCC - The blind carbon copy recipients of the email
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
emailcampaigngroupid	float	[en] Email campaign group ID - The ID grouping related email campaign versions
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
recipient	text	[en] Recipient - The email address of the message recipient
cc	text	[en] CC - The carbon copy recipients of the email
subject	text	[en] Subject - The subject text

hubspot_email_events_sent

HubSpot Email Events: Sent - Sent events of marketing email campaigns

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
appname	text	[en] App name - The name of the HubSpot application that generated the event
emailcampaignid	text	[en] Email campaign ID - The ID of the marketing email campaign the event belongs to Marketing Emails > email_campaigns > email_campaign_id
smtpid	text	[en] SMTP ID - The SMTP message identifier associated with the email event
appid	float	[en] App ID - The ID of the HubSpot application that generated the event
emailcampaigngroupid	float	[en] Email campaign group ID - The ID grouping related email campaign versions
recipient	text	[en] Recipient - The email address of the message recipient
attempt	float	[en] Attempt - The delivery attempt number for the email
portalid	float	[en] Portal ID - The numeric ID of the HubSpot account (portal) the record belongs to
created	float	[en] Created - Timestamp (epoch milliseconds) when the event was created
sentby__id	text	[en] Sent by - ID of the originating email event that this event references
sentby__created	float	[en] Sent by (created) - Timestamp of the originating email event
type	text	[en] Association type - The type/label of the association between the two objects

Engagements: Calls

This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we will create a specific pipeline for archived records that you can use to remove archived data from your view or model. We are currently awaiting the release of this functionality for this endpoint by HubSpot. Deleted data cannot be recovered.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

Relationships:

hs_call_disposition → Engagements: Calls: Dispositions > id

HubSpot Calls - Call engagements represent logged phone calls with contacts

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
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 Engagements: Calls: Dispositions > > id
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

Engagements: Calls: Dispositions

This is a free pipeline

This pipeline is free

Replication type: Full

HubSpot Call Dispositions - Available call disposition outcomes and their properties

Campo	Tipo
id	text	[en] Call disposition id
label	text	[en] Call disposition label
deleted	boolean	[en] If call disposition has been deleted

Engagements: Calls: related objects

Replication type: Incremental

Parameters:

Related object: Select the related object to replicate

Relationships:

calls_id → Engagements: Calls > id
1_id → Contacts > id
1_id → Deals > id
1_id → Companies > id
1_id → Tickets > id

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo	Tipo
calls_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Engagements: Calls > > id
1_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Contacts > > id Deals > > id Companies > > id Tickets > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

calls_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Engagements: Calls > > id

1_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

association_type

text

[en] Association type - The type/label of the association between the two objects

Engagements: Emails

This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we will create a specific pipeline for archived records that you can use to remove archived data from your view or model. We are currently awaiting the release of this functionality for this endpoint by HubSpot. Deleted data cannot be recovered.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

HubSpot Calls - Call engagements represent logged phone calls with contacts

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
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

Engagements: Emails: related objects

Replication type: Incremental

Parameters:

Related object: Select the related object to replicate

Relationships:

emails_id → Engagements: Emails > id
1_id → Contacts > id
1_id → Deals > id
1_id → Companies > id
1_id → Tickets > id

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo	Tipo
emails_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Engagements: Emails > > id
1_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Contacts > > id Deals > > id Companies > > id Tickets > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

emails_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Engagements: Emails > > id

1_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

association_type

text

[en] Association type - The type/label of the association between the two objects

Engagements: Meetings

This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we will create a specific pipeline for archived records that you can use to remove archived data from your view or model. We are currently awaiting the release of this functionality for this endpoint by HubSpot. Deleted data cannot be recovered.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

Main object

HubSpot Meetings - Meeting engagements represent scheduled meetings with contacts

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
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_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

HubSpot Scheduled Meetings - Recurring or scheduled meetings

Campo	Tipo
meeting_id	text	[en] Meeting ID - The HubSpot ID of the meeting engagement
timestamp	timestamp	[en] Scheduled task timestamp - When the scheduled task is due (epoch)
portalid	text	[en] Scheduled task portal ID - The HubSpot account (portal) ID of the scheduled task
engagementtype	text	[en] Scheduled task engagement type - The engagement type of the scheduled task
tasktype	text	[en] Scheduled task type - The type of the scheduled task
uuid	text	[en] Scheduled task UUID - The unique identifier of the scheduled task

Engagements: Meetings: related objects

Replication type: Incremental

Parameters:

Related object: Select the related object to replicate

Relationships:

meetings_id → Engagements: Meetings > id
1_id → Contacts > id
1_id → Deals > id
1_id → Companies > id
1_id → Tickets > id

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo	Tipo
meetings_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Engagements: Meetings > > id
1_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Contacts > > id Deals > > id Companies > > id Tickets > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

meetings_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Engagements: Meetings > > id

1_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

association_type

text

[en] Association type - The type/label of the association between the two objects

Engagements: Notes

This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we will create a specific pipeline for archived records that you can use to remove archived data from your view or model. We are currently awaiting the release of this functionality for this endpoint by HubSpot. Deleted data cannot be recovered.
If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

HubSpot Notes - Note engagements contain text information logged on a record

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
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

Engagements: Notes: related objects

Replication type: Incremental

Parameters:

Related object: Select the related object to replicate

Relationships:

notes_id → Engagements: Notes > id
1_id → Contacts > id
1_id → Deals > id
1_id → Companies > id
1_id → Tickets > id

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo	Tipo
notes_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Engagements: Notes > > id
1_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Contacts > > id Deals > > id Companies > > id Tickets > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

notes_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Engagements: Notes > > id

1_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

association_type

text

[en] Association type - The type/label of the association between the two objects

Engagements: Tasks

This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we will create a specific pipeline for archived records that you can use to remove archived data from your view or model. We are currently awaiting the release of this functionality for this endpoint by HubSpot. Deleted data cannot be recovered.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

Main object

HubSpot Tasks - Task engagements represent to-do items that need to be completed

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
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

HubSpot Scheduled Tasks - Recurring or scheduled tasks

Campo	Tipo
task_id	text	[en] Task ID - The HubSpot ID of the task engagement
timestamp	timestamp	[en] Scheduled task timestamp - When the scheduled task is due (epoch)
portalid	text	[en] Scheduled task portal ID - The HubSpot account (portal) ID of the scheduled task
engagementtype	text	[en] Scheduled task engagement type - The engagement type of the scheduled task
tasktype	text	[en] Scheduled task type - The type of the scheduled task
uuid	text	[en] Scheduled task UUID - The unique identifier of the scheduled task

Engagements: Tasks: related objects

Replication type: Incremental

Parameters:

Related object: Select the related object to replicate

Relationships:

tasks_id → Engagements: Tasks > id
1_id → Contacts > id
1_id → Deals > id
1_id → Companies > id
1_id → Tickets > id

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo	Tipo
tasks_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Engagements: Tasks > > id
1_id	text	[en] Target object ID - The HubSpot ID of the object on the target side of the association Contacts > > id Deals > > id Companies > > id Tickets > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

tasks_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Engagements: Tasks > > id

1_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

association_type

text

[en] Association type - The type/label of the association between the two objects

Feedback Submissions

This pipeline will bring Net Promoter Score (NPS), Customer Satisfaction (CSAT), Customer Effort Score (CES), and Custom Surveys and all their properties in a columnar format, according to your account settings, in a format similar to the one below.
By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed
It is recommended to use only the necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, click on FIELDS and uncheck/check the desired properties/columns.
If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

HubSpot Feedback Submissions - Customer feedback and survey responses

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Line Items

This pipeline will bring Line Items and all their properties in a columnar format, according to your account settings, in a format similar to the one below.

This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we have created a specific pipeline for archived records that you can use to remove archived data from your view or model. Deleted data cannot be recovered.

By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed. We recommend using only the necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, simply click on FIELDS and uncheck/check the desired properties/columns.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

HubSpot Line Item Submissions - Line items associated with feedback submissions

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Line Items: related deals

Replication type: Incremental

Relationships:

line_item_id → Line Items > id
deal_id → Deals > id

HubSpot Line Item-Deal Associations - Relationships between line items and deals

Campo	Tipo
line_item_id	text	[en] Source object ID - The HubSpot ID of the object on the source side of the association Line Items > > id
deal_id	text	[en] Deal ID - The HubSpot ID of the associated deal Deals > > id
association_type	text	[en] Association type - The type/label of the association between the two objects

Campo

Tipo

line_item_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Line Items > > id

deal_id

text

[en] Deal ID - The HubSpot ID of the associated deal

Deals > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Marketing Emails

Replication type: Full

Main object

HubSpot Marketing Emails - Email campaigns and marketing messages created in HubSpot

Campo	Tipo
id	text	[en] Unique identifier for the marketing email
name	text	[en] Internal name of the email
subject	text	[en] Subject line of the email
state	text	[en] Current state of the email (DRAFT, PUBLISHED, AUTOMATED, etc)
type	text	[en] Type of the email (REGULAR, FEEDBACK_CES_EMAIL, etc)
subcategory	text	[en] Subcategory of the email
ispublished	boolean	[en] Whether the email is currently published
istransactional	boolean	[en] Whether this is a transactional email
isab	boolean	[en] Whether this email is part of an A/B test
archived	boolean	[en] Whether the email has been archived
createdat	timestamp	[en] Timestamp when the email was created
updatedat	timestamp	[en] Timestamp when the email was last updated
publishdate	timestamp	[en] Scheduled publish date for the email
publishedat	timestamp	[en] Timestamp when the email was actually published
createdbyid	text	[en] ID of the user who created the email
updatedbyid	text	[en] ID of the user who last updated the email
publishedbyid	text	[en] ID of the user who published the email
publishedbyname	text	[en] Name of the user who published the email
activedomain	text	[en] Active domain for the email
businessunitid	text	[en] Business unit ID associated with the email
emailcampaigngroupid	text	[en] ID of the email campaign group
primaryemailcampaignid	text	[en] ID of the primary email campaign
emailtemplatemode	text	[en] Template mode used for the email (DESIGN_MANAGER, DRAG_AND_DROP, etc)
feedbacksurveyid	text	[en] ID of associated feedback survey
previewkey	text	[en] Key used for email preview
jittersendtime	boolean	[en] Whether to randomize send times
fromname	text	[en] Sender name displayed in the email
replyto	text	[en] Reply-to email address
suppressgraymail	boolean	[en] Whether graymail suppression is enabled
templatepath	text	[en] Path to the email template
subscriptionid	text	[en] ID of the subscription type
subscriptionname	text	[en] Name of the subscription type
webversion_url	text	[en] URL of the web version of the email
webversion_domain	text	[en] Domain of the web version
webversion_slug	text	[en] URL slug of the web version
webversion_enabled	boolean	[en] Whether web version is enabled
webversion_ispageredirected	boolean	[en] Whether the web page is redirected

hubspot_marketing_emails_email_campaigns

HubSpot Marketing Emails - Email Campaigns - Campaign associations for marketing emails

Campo	Tipo
marketing_email_id	text	[en] ID of the parent marketing email
email_campaign_id	text	[en] ID of the associated email campaign

Owners

This pipeline has an integral replication type

Replication type: Full

Main object

HubSpot Owners - HubSpot users who can be assigned as owners of records (name, email, team)

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
userid	text	[en] User ID - The HubSpot user ID linked to the owner
email	text	[en] Email - The email address
firstname	text	[en] First name - The first name
lastname	text	[en] Last name - The last name
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot

hubspot_owners_teams

HubSpot Owner Teams - Teams that owners belong to

Campo	Tipo
owner_id	text	[en] Owner ID - The HubSpot owner identifier
team_id	text	[en] Team ID - The ID of the team the owner belongs to
team_name	text	[en] Team name - The name of the team the owner belongs to

Pipelines

This pipeline is free

This pipeline is free

Replication type: Full

Parameters:

Pipeline type: Select the pipeline type to be replicated

Main object

HubSpot Pipelines - Deal/ticket pipelines (funnels) configured in the account

Campo	Tipo
default	boolean	[en] Default - Whether this is the default option/value
displayorder	float	[en] Display order - The ordering position used when displaying the property/option
updatedat	float	[en] Updated at - Date and time the record was last updated in HubSpot
active	boolean	[en] Active - Whether the record is active
objecttypeid	text	[en] Object type ID - The internal type ID of the HubSpot object
pipelineid	text	[en] Pipeline ID - The ID of the deal/ticket pipeline (funnel)
label	text	[en] Label - The human-readable display label of the property/option
createdat	float	[en] Created at - Date and time the record was created in HubSpot
objecttype	text	[en] Object type - The HubSpot object type of the record

hubspot_pipelines__stages

HubSpot Pipeline Stages - Stages within each pipeline (funnel)

Campo	Tipo
pipelineid	text	[en] Pipeline ID - The ID of the deal/ticket pipeline (funnel)
stages__label	text	[en] Stage label - The display name of the pipeline stage
stages__createdat	float	[en] Stage created at - Timestamp the stage was created
stages__stageid	text	[en] Stage ID - The ID of a stage within the pipeline
stages__updatedat	float	[en] Stage updated at - Timestamp the stage was last updated
stages__active	boolean	[en] Stage active - Whether the pipeline stage is active
stages__displayorder	float	[en] Stage display order - The ordering position of the stage within the pipeline
stages__metadata__isclosed	text	[en] Stage is closed - Whether the stage represents a closed (won/lost) state
stages__metadata__probability	float	[en] Stage probability - The win probability associated with the deal stage

Products

This pipeline will bring Products and all their properties in a columnar format, according to your account settings, in a format similar to the one below.

By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed. We recommend using only the necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, simply click on FIELDS and uncheck/check the desired properties/columns.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

HubSpot Products - Product catalog and product information

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Property history

Replication type: Incremental

Parameters:

Object: Select the object which properties will be used
Properties: Select the properties to be used - leave it empty to use all properties

HubSpot Property History - Historical changes to object property values

Campo	Tipo
object_id	text	[en] ID of the object the property belongs to
property	text	[en] Name of the property
value	text	[en] Value of the property
timestamp	timestamp	[en] Timestamp of the property value
sourcetype	text	[en] Type of the source that updated the property value
sourceid	text	[en] Id of the source that updated the property value
updatedbyuserid	text	[en] Id of the user that updated the property value

Tickets

This pipeline will bring tickets and all their properties in a columnar format, according to your account settings, in a format similar to the one below.

This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we have created a specific pipeline for archived records that you can use to remove archived data from your view or model. Deleted data cannot be recovered.

By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed. We recommend using only the necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, simply click on FIELDS and uncheck/check the desired properties/columns.

If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed.

Replication type: Incremental

HubSpot Tickets - Support tickets and customer service requests

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Tickets: related companies

Replication type: Incremental

Relationships:

ticket_id → Tickets > id
company_id → Companies > id

HubSpot Ticket-Deal Associations - Relationships between tickets and deals

Campo

Tipo

ticket_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Tickets > > id

company_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Companies > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Tickets: related contacts

Replication type: Incremental

Relationships:

ticket_id → Tickets > id
contact_id → Contacts > id

HubSpot Ticket-Contact Associations - Relationships between tickets and contacts

Campo

Tipo

ticket_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Tickets > > id

contact_id

text

[en] Target object ID - The HubSpot ID of the object on the target side of the association

Contacts > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Tickets: related deals

Replication type: Incremental

Relationships:

ticket_id → Tickets > id
deal_id → Deals > id

HubSpot Ticket-Deal Associations - Relationships between tickets and deals

Campo

Tipo

ticket_id

text

[en] Source object ID - The HubSpot ID of the object on the source side of the association

Tickets > > id

deal_id

text

[en] Deal ID - The HubSpot ID of the associated deal

Deals > > id

association_type

text

[en] Association type - The type/label of the association between the two objects

Archived leads

Replication type: Full

Relationships:

id → Leads > id

HubSpot Deleted Leads - IDs of leads that were archived/deleted in HubSpot (soft-delete tracking)

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record Leads > > id
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
archivedat	timestamp	[en] Archived at - Date and time the record was archived in HubSpot
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
properties__hs_createdate	timestamp	[en] Property hs_createdate - The CRM object property "hs_createdate" value
properties__email	text	[en] Property email - The CRM object property "email" value
properties__hs_associated_contact_firstname	text	[en] Property hs_associated_contact_firstname - The CRM object property "hs_associated_contact_firstname" value
properties__hs_lastmodifieddate	timestamp	[en] Property hs_lastmodifieddate - The CRM object property "hs_lastmodifieddate" value
properties__hs_associated_contact_lastname	text	[en] Property hs_associated_contact_lastname - The CRM object property "hs_associated_contact_lastname" value
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot

Leads

This pipeline will bring leads and all their properties in a columnar format, according to your account settings, in a format similar to the one below
This pipeline does not capture deletions and archiving: if a record is removed by archiving or deletion, it will not be reflected in your pipeline. Therefore, we have created a specific pipeline for archived records that you can use to remove archived data from your view or model. Deleted data cannot be recovered.
By default, all custom properties existing in your account will be included. However, using many properties may impact data reading speed. We recommend using only the necessary properties by selecting them on the pipeline creation/edit screen. When naming the tables, simply click on FIELDS and uncheck/check the desired properties/columns.
If more than 10,000 updated records are found within a 100-millisecond period during an execution, or if the initial savepoint is more than 3 days from the current date, a full execution will be performed

Replication type: Incremental

HubSpot Leads - Prospective customers and lead information

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Payments

Replication type: Incremental

HubSpot Payments - Payment transactions and financial records

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
property_x	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_y	text	[en] Custom property placeholder - A user-defined property selected for this pipeline
property_z	text	[en] Custom property placeholder - A user-defined property selected for this pipeline

Properties Metadata

This pipeline is free

Replication type: Full

Parameters:

Object: Select the object whose properties will be queried

Main object

HubSpot Property Metadata - Properties and their configurations for objects

Campo	Tipo
property_name	text	[en] Internal name of the property
label	text	[en] User-facing label from HubSpot UI
description	text	[en] Description of the property
type	text	[en] Property type (string, number, bool, date, datetime, enumeration, json)
fieldtype	text	[en] HubSpot field type (text, textarea, select, radio, checkbox, booleancheckbox, number, date, etc.)
groupname	text	[en] Name of the property group this property belongs to
hidden	boolean	[en] Whether the property is hidden
deleted	boolean	[en] Whether the property is deleted
calculated	boolean	[en] Whether the property is a calculated property
externaloptions	boolean	[en] Whether the property has external options
formfield	boolean	[en] Whether this property can be used in forms
readonlyvalue	boolean	[en] Whether the property value is read-only
readonlydefinition	boolean	[en] Whether the property definition is read-only
displayorder	float	[en] Display order of the property
hasuniquevalue	boolean	[en] Whether the property requires unique values
hubspotdefined	boolean	[en] Whether this is a HubSpot default property
createduserid	text	[en] ID of the user who created this property
updateduserid	text	[en] ID of the user who last updated this property
createdat	text	[en] Timestamp when the property was created
updatedat	text	[en] Timestamp when the property was last updated
favorited	boolean	[en] Whether the property is favorited
favoritedorder	float	[en] Order in the favorites list
optionsaremutable	boolean	[en] Whether the options can be modified
referencedobjecttype	text	[en] Type of object this property references (for relationship properties)
iscustomizeddefault	boolean	[en] Whether this is a customized default property
mutabledefinitionnotdeletable	boolean	[en] Whether the definition can be modified but not deleted
searchableinglobalsearch	boolean	[en] Whether the property is searchable in global search
textdisplayhint	text	[en] Hint for text display
numberdisplayhint	text	[en] Hint for number display
currencypropertyname	text	[en] Name of the currency property for this property
showcurrencysymbol	boolean	[en] Whether to show the currency symbol
displaymode	text	[en] Display mode of the property
searchtextanalysismode	text	[en] Search text analysis mode
optionsortstrategy	text	[en] Strategy for sorting options

hubspot__properties_metadata__options

Options for enumeration properties

Campo	Tipo
property_name	text	[en] Internal name of the parent property
options_value	text	[en] Internal value/id of the option
options_description	text	[en] Description of the option
options_label	text	[en] User-facing label for the option
options_displayorder	float	[en] Display order of the option
options_hidden	boolean	[en] Whether the option is hidden
options_readonly	boolean	[en] Whether the option is read-only

Communications (WhatsApp/SMS/LinkedIn)

Replication type: Incremental

Parameters:

Read start date (Savepoint): Initial replication date

HubSpot Communications - Communications logged in the CRM (WhatsApp, SMS, LinkedIn messages and other channels)

Campo	Tipo
id	text	[en] Record ID - The unique HubSpot identifier of the record
createdat	timestamp	[en] Created at - Date and time the record was created in HubSpot
updatedat	timestamp	[en] Updated at - Date and time the record was last updated in HubSpot
archived	boolean	[en] Archived - Indicates whether the record is archived (soft-deleted) in HubSpot
hs_communication_channel_type	text	[en] Channel type - The channel the communication was logged from (WHATS_APP, SMS, LINKEDIN_MESSAGE, PHYSICAL_MAIL, CUSTOM_CHANNEL_CONVERSATION)
hs_communication_body	text	[en] Communication body - The text content of the logged communication
hs_communication_logged_from	text	[en] Logged from - The source system the communication was logged from
hs_timestamp	timestamp	[en] Activity date - The date and time the communication occurred
hubspot_owner_id	text	[en] Owner - The HubSpot owner assigned to the communication

Creating the data source

Requirements

Instructions

Pipelines

Summary

Relationship chart

Archived companies

Archived contacts

Archived deals

Archived line items

Archived tickets

Associations

Companies

Companies: related contacts

Companies: related deals

Companies: related tickets

Contact lists

Contacts

Contacts: form submissions

Contacts: lists membership

Contacts: related companies

Contacts: related deals

Contacts: related tickets

Custom object

Deals

Deals: related companies

Deals: related contacts

Deals: related tickets

Email events

Engagements: Calls

Engagements: Calls: Dispositions

Engagements: Calls: related objects

Engagements: Emails

Engagements: Emails: related objects

Engagements: Meetings

Engagements: Meetings: related objects

Engagements: Notes

Engagements: Notes: related objects

Engagements: Tasks

Engagements: Tasks: related objects

Feedback Submissions

Line Items

Line Items: related deals

Marketing Emails

Owners

Pipelines

Products

Property history

Tickets

Tickets: related companies

Tickets: related contacts

Tickets: related deals

Archived leads

Leads

Payments

Properties Metadata

Communications (WhatsApp/SMS/LinkedIn)

Notes