Try our plataform
HubSpot

Creating the data source

Requirements

Follow the steps with a Super admin type user

The minimum scope required for the connector to function is crm.objects.contacts

Instructions

1) Login to your Hubspot account with a Super Admin user;

2) At the top right, click on settings (gear icon);

3) In the left menu of the settings page, select the option of “Integrations”;

4) In the Integrations expansion, select “Private Apps”;

5) On the Private apps page, click on “Create a private app";

6) In the new window, under “Basic info” fill in a name for your app, for example “Kondado”. If you want to use a logo for internal identification, you can use this;

7) Select the “scopes” section at the top;

8) In the scopes section, we recommend checking the “Read” permission in all scopes available in CRM (do not select the “Write” permission because it is not necessary) and in Standard, we recommend using all scopes that are not of write.
If the "content" scope is not in "Standard", look for it in "Other" and add it as well;

9) After filling in the data in “Basic info” and “Scopes”, select “Create app” at the top right;

10) Accept the pop-up that will appear and then when you receive the message that your app has been created, click on show token and then copy the displayed token;

12) On the data source creation page, insert the token obtained in step 10 and click Save.

You're ready to go to the pipelines page, select the pipelines you want to build and start replicating your Hubspot data to your destination!

Now that you know how to integrate Hubspot data by Kondado, check out this article, where we show you how to create relationships between Hubspot objects and pivot their properties.

Pipelines

Summary

Relationship chart

Click to expand

Archived companies

Replication type: Full

Relationships:

Campo Tipo

id

text

    Companies > > id

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__createdate

timestamp

properties__domain

text

properties__hs_lastmodifieddate

timestamp

properties__name

text

updatedat

timestamp

Archived contacts

Replication type: Full

Relationships:

Campo Tipo

id

text

    Contacts > > id

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__createdate

timestamp

properties__email

text

properties__firstname

text

properties__lastmodifieddate

timestamp

properties__lastname

text

updatedat

timestamp

Archived deals

Replication type: Full

Relationships:

Campo Tipo

id

text

    Deals > > id

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__amount

float

properties__closedate

timestamp

properties__createdate

timestamp

properties__dealname

text

properties__dealstage

text

properties__hs_lastmodifieddate

timestamp

properties__pipeline

text

updatedat

timestamp

Archived line items

Replication type: Full

Relationships:

Campo Tipo

id

text

    Line Items > > id

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__amount

float

properties__createdate

timestamp

properties__hs_lastmodifieddate

timestamp

properties__hs_product_id

text

properties__quantity

float

updatedat

timestamp

Archived tickets

Replication type: Full

Relationships:

Campo Tipo

id

text

    Tickets > > id

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__content

text

properties__createdate

timestamp

properties__hs_lastmodifieddate

timestamp

properties__hs_pipeline

text

properties__hs_pipeline_stage

text

properties__hs_ticket_category

text

properties__hs_ticket_priority

text

properties__subject

text

updatedat

timestamp

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

_id

text

_id

text

association_type

text

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

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Companies: related contacts

Replication type: Incremental

Relationships:

HubSpot Company-Contact Associations - Relationships between companies and contacts

Campo Tipo

company_id

text

    Companies > > id

contact_id

text

    Contacts > > id

association_type

text

Companies: related deals

Replication type: Incremental

Relationships:

HubSpot Company-Deal Associations - Relationships between companies and deals

Campo Tipo

company_id

text

    Companies > > id

deal_id

text

    Deals > > id

association_type

text

Companies: related tickets

Replication type: Incremental

Relationships:

HubSpot Company-Ticket Associations - Relationships between companies and tickets

Campo Tipo

company_id

text

    Companies > > id

ticket_id

text

    Tickets > > id

association_type

text

Contact lists

Replication type: Full

Campo Tipo

listid

text

archived

boolean

authorid

text

createdat

timestamp

deleteable

boolean

dynamic

boolean

internallistid

text

listtype

text

metadata__lastprocessingstatechangeat

timestamp

metadata__lastsizechangeat

timestamp

metadata__processing

text

metadata__size

float

name

text

portalid

text

readonly

boolean

updatedat

timestamp

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

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

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:

Main object

Campo Tipo

vid

text

    Contacts > > id

conversion_id

text

canonical_url

text

content_type

text

form_id

text

form_type

text

page_id

text

page_title

text

page_url

text

portal_id

text

timestamp

timestamp

title

text

contacts_form_submissions__contact_associated_by

Campo Tipo

vid

text

conversion_id

text

associated_by

text

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:

Campo Tipo

vid

text

    Contacts > > id

timestamp

timestamp

static_list_id

text

    Contact lists > > listid

internal_list_id

text

is_member

boolean

Contacts: related companies

Replication type: Incremental

Relationships:

HubSpot Contact-Ticket Associations - Relationships between contacts and tickets

Campo Tipo

contact_id

text

    Contacts > > id

company_id

text

    Companies > > id

association_type

text

Contacts: related deals

Replication type: Incremental

Relationships:

HubSpot Contact-Ticket Associations - Relationships between contacts and tickets

Campo Tipo

contact_id

text

    Contacts > > id

deal_id

text

    Deals > > id

association_type

text

Contacts: related tickets

Replication type: Incremental

Relationships:

HubSpot Contact-Ticket Associations - Relationships between contacts and tickets

Campo Tipo

contact_id

text

    Contacts > > id

ticket_id

text

    Tickets > > id

association_type

text

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

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

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

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Deals: related companies

Replication type: Incremental

Relationships:

HubSpot Deal-Contact Associations - Relationships between deals and contacts

Campo Tipo

deal_id

text

    Deals > > id

company_id

text

    Companies > > id

association_type

text

Deals: related contacts

Replication type: Incremental

Relationships:

HubSpot Deal-Contact Associations - Relationships between deals and contacts

Campo Tipo

deal_id

text

    Deals > > id

contact_id

text

    Contacts > > id

association_type

text

Deals: related tickets

Replication type: Incremental

Relationships:

HubSpot Deal-Contact Associations - Relationships between deals and contacts

Campo Tipo

deal_id

text

    Deals > > id

ticket_id

text

    Tickets > > id

association_type

text

Email events

Replication type: Incremental

Parameters:

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

Relationships:

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

smtpid

text

appid

float

emailcampaigngroupid

float

recipient

text

response

text

attempt

float

portalid

float

created

float

sentby__id

text

sentby__created

float

type

text

hubspot_email_events_sent

Campo Tipo

id

text

source

text

portalid

float

appid

float

subscriptions

text

sourceid

text

type

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

created

float

recipient

text

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

portalid

float

appid

float

emailcampaigngroupid

float

recipient

text

dropreason

text

attempt

float

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

dropmessage

text

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

portalid

float

appid

float

emailcampaigngroupid

float

recipient

text

response

text

attempt

float

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

hubspot_email_events_sent

Campo Tipo

appname

text

type

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

created

float

portalid

float

devicetype

text

location__country

text

location__state

text

location__zipcode

text

location__city

text

filteredevent

boolean

appid

float

duration

float

useragent

text

smtpid

text

sentby__id

text

sentby__created

float

recipient

text

id

text

browser__family

text

browser__name

text

browser__producer

text

browser__url

text

browser__producerurl

text

browser__version

text

browser__type

text

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

portalid

float

appid

float

recipient

text

attempt

text

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

hubspot_email_events_sent

Campo Tipo

id

text

status

text

appname

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

portalid

float

appid

float

emailcampaigngroupid

float

recipient

text

response

text

category

text

attempt

float

smtpid

text

created

float

sentby__id

text

sentby__created

float

type

text

hubspot_email_events_sent

Campo Tipo

id

text

type

text

appname

text

url

text

linkid

float

useragent

text

created

float

smtpid

text

emailcampaigngroupid

float

referer

text

location__country

text

location__state

text

location__city

text

filteredevent

boolean

appid

float

portalid

float

devicetype

text

sentby__id

text

sentby__created

float

recipient

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

browser__family

text

browser__name

text

browser__producer

text

browser__url

text

browser__producerurl

text

browser__version

text

browser__type

text

hubspot_email_events_sent

Campo Tipo

id

text

from

text

appname

text

replyto

text

type

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

created

float

bcc

text

portalid

float

appid

float

emailcampaigngroupid

float

smtpid

text

sentby__id

text

sentby__created

float

recipient

text

cc

text

subject

text

hubspot_email_events_sent

Campo Tipo

id

text

appname

text

emailcampaignid

text

    Marketing Emails > email_campaigns > email_campaign_id

smtpid

text

appid

float

emailcampaigngroupid

float

recipient

text

attempt

float

portalid

float

created

float

sentby__id

text

sentby__created

float

type

text

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:

HubSpot Calls - Call engagements represent logged phone calls with contacts

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_activity_type

text

[en] Call and meeting type - The activity type of the engagement

hs_all_assigned_business_unit_ids

text

[en] Business units - The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids - The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs - The IDs of the files that are attached to the engagement

hs_body_preview

text

[en] Call notes preview - A truncated preview of the call notes

hs_body_preview_html

text

[en] HTML Body Preview - The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated - Indicates if the engagement body was truncated for the preview

hs_call_app_id

float

[en] Integrating App ID - The App ID associated with the integrating app

hs_call_authed_url_provider

text

[en] Authenticated recording files url provider - URL which returns Authenticated audio/video URL of the recording

hs_call_body

text

[en] Call notes - The body of the call

hs_call_callee_object_id

float

[en] Callee object id - The id of the callee

hs_call_callee_object_type

text

[en] Callee object type - The type of callee

hs_call_direction

text

[en] Call direction - The direction of a call

hs_call_disposition

text

[en] Call outcome - The outcome of the call

    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:

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo Tipo

calls_id

text

    Engagements: Calls > > id

1_id

text

    Contacts > > id

    Deals > > id

    Companies > > id

    Tickets > > id

association_type

text

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

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_all_assigned_business_unit_ids

text

[en] Business units - The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids - The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs - The IDs of the files that are attached to the engagement

hs_body_preview

text

[en] Body preview - A truncated preview of the engagegement body

hs_body_preview_html

text

[en] HTML Body Preview - The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated - Indicates if the engagement body was truncated for the preview

hs_created_by

text

[en] Activity created by - The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID - The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Create date - The date that an engagement was created

hs_direction_and_unique_id

text

[en] Email direction and unique ID - The direction and unique ID of the email concatenated by :

hs_email_attached_video_id

text

[en] Attached Video - The ID of a video optionally attached to an email

hs_email_attached_video_name

text

[en] Attached Video Name - The name of a video optionally attached to an email

hs_email_attached_video_opened

boolean

[en] Attached Video Opened - Has the video attachment been opened

hs_email_attached_video_watched

boolean

[en] Attached Video Watched - Has the video attachement been watched

hs_email_bcc_email

text

[en] Email BCC Address - Email addresses of the email's BCC recipients

hs_email_bcc_firstname

text

[en] Email BCC First Name - First names of the email's BCC recipients

hs_email_bcc_lastname

text

[en] Email BCC Last Name - Last names of the email's BCC recipients

hs_email_bcc_raw

text

[en] Email BCC - Raw header values of the email's BCC recipients

hs_email_cc_email

text

[en] Email CC Address - Email addresses of the email's CC recipients

hs_email_cc_firstname

text

[en] Email CC First Name - First names of the email's CC recipients

hs_email_cc_lastname

text

[en] Email CC Last Name - Last names of the email's CC recipients

hs_email_cc_raw

text

[en] Email CC - Raw header values of the email's CC recipients

hs_email_direction

text

[en] Email Direction - The direction the email was sent in

hs_email_encoded_email_associations_request

text

[en] Encoded Email Associations Request - Encoded email associations request

hs_email_error_message

text

[en] Error Message - The error that occurred while sending the email

hs_email_facsimile_send_id

text

[en] Email Send Id - The ID of the email send event sent through Facsimile

hs_email_from_email

text

[en] Email From Address - Email address of the email's sender

hs_email_from_firstname

text

[en] Email From First Name - First name of the email's sender

hs_email_from_lastname

text

[en] Email From Last Name - Last name of the email's sender

hs_email_from_raw

text

[en] Email From - Raw header value of the email's sender

hs_email_headers

text

[en] Email Headers - The sender and receivers of the email

hs_email_html

text

[en] Email body - This is the body of any email sent from a record. It doesn't include emails received from contacts.

hs_email_logged_from

text

[en] Logged From - Where the email was logged

hs_email_media_processing_status

text

[en] Media Processing Status - Processing status for this email's images and attachments

hs_email_member_of_forwarded_subthread

boolean

[en] Email is member of forwarded subthread - Whether this email is a member of a forwarded subthread

hs_email_message_id

text

[en] Message ID - The ID of the message

hs_email_migrated_via_portal_data_migration

boolean

[en] email_migrated_via_portal_data_migration - Indicates that the email was migrated from another portal using DataMigration tool

hs_email_pending_inline_image_ids

text

[en] Email pending inline image file IDs - File IDs of pending inline images in the email's HTML

hs_email_post_send_status

text

[en] Post-Send Status - A description of what happened to the email (successful send, bounced, dropped) and why

hs_email_recipient_drop_reasons

text

[en] Recipient-Drop Reasons - A list of the dropped recipients paired with the reason each was dropped

hs_email_send_event_id

text

[en] Email Send Event Id - The ID of the email send event

hs_email_send_event_id_created

timestamp

[en] Email Send Event Id Created - The date when the email send event ID was created

hs_email_sender_email

text

[en] Email Sender Address - Email address of the email's sender

hs_email_sender_firstname

text

[en] Email Sender First Name - First name of the email's sender

hs_email_sender_lastname

text

[en] Email Sender Last Name - Last name of the email's sender

hs_email_sender_raw

text

[en] Email Sender - Raw header value of the email's sender

hs_email_sent_via

text

[en] Sent Via - How the email was sent

hs_email_status

text

[en] Email send status - The send status of the email

hs_email_subject

text

[en] Email subject - The subject of the email

hs_email_text

text

[en] Text - The plaintext of the email

hs_email_thread_id

text

[en] Thread ID - The thread that the email belongs to

hs_email_to_email

text

[en] Email To Address - Email addresses of the email's recipients

hs_email_to_firstname

text

[en] Email To First Name - First names of the email's recipients

hs_email_to_lastname

text

[en] Email To Last Name - Last names of the email's recipients

hs_email_to_raw

text

[en] Email To - Raw header values of the email's recipients

hs_email_tracker_key

text

[en] Tracker Key - The tracker key of the email

hs_email_validation_skipped

text

[en] Validation Skipped - Validation skipped that would have otherwise rejected logging

hs_engagement_source

text

[en] Engagement Source - The source that created this engagement

hs_engagement_source_id

text

[en] Engagement Source ID - The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action - What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted - Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_lastmodifieddate

timestamp

[en] Last modified date - The date any property on this engagement was modified

hs_merged_object_ids

text

[en] Merged object IDs - The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

text

[en] Updated by - The user who last updated the engagement

hs_object_id

float

[en] Object ID - The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name - The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue Memberships - The list of queues that contain this engagement

hs_timestamp

timestamp

[en] Activity date - The date that an engagement occurred

hs_unique_creation_key

text

[en] Unique creation key - Unique property used for idempotent creates

hs_unique_id

text

[en] Unique ID - The unique ID of the engagement

hs_updated_by_user_id

float

[en] Updated by user ID - The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

hs_user_ids_of_all_notification_followers

text

[en] User IDs of all notification followers - The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

hs_user_ids_of_all_notification_unfollowers

text

[en] User IDs of all notification unfollowers - The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

hs_user_ids_of_all_owners

text

[en] User IDs of all owners - The user IDs of all owners of this object

hubspot_owner_assigneddate

timestamp

[en] Owner Assigned Date - The timestamp when an owner was assigned to this engagement

hubspot_owner_id

text

[en] Activity assigned to - The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.

hubspot_team_id

text

[en] HubSpot Team - The team of the owner of an engagement.

hs_all_owner_ids

text

[en] All owner ids - The value of all owner referencing properties for this object, both default and custom

hs_all_team_ids

text

[en] All team ids - The team ids corresponding to all owner referencing properties for this object, both default and custom

hs_all_accessible_team_ids

text

[en] All accessible team ids - The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

Engagements: Emails: related objects

Replication type: Incremental

Parameters:

  • Related object: Select the related object to replicate

Relationships:

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo Tipo

emails_id

text

    Engagements: Emails > > id

1_id

text

    Contacts > > id

    Deals > > id

    Companies > > id

    Tickets > > id

association_type

text

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

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_activity_type

text

[en] Call and meeting type - The activity type of the engagement

hs_all_assigned_business_unit_ids

text

[en] Business units - The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids - The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs - The IDs of the files that are attached to the engagement

hs_attendee_owner_ids

text

[en] HubSpot attendee owner IDs - List of HubSpot owner IDs for additional attendees

hs_body_preview

text

[en] Body preview - A truncated preview of the engagegement body

hs_body_preview_html

text

[en] HTML Body Preview - The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated - Indicates if the engagement body was truncated for the preview

hs_created_by

float

[en] Activity created by - The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID - The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Create date - The date that an engagement was created

hs_engagement_source

text

[en] Engagement Source - The source that created this engagement

hs_engagement_source_id

text

[en] Engagement Source ID - The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action - What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted - Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_i_cal_uid

text

[en] iCalUid - The iCalUid of the synced event

hs_internal_meeting_notes

text

[en] Internal Meeting Notes -

hs_lastmodifieddate

timestamp

[en] Last modified date - The date any property on this engagement was modified

hs_meeting_body

text

[en] Meeting description - The text description of the meeting

hs_meeting_calendar_event_hash

text

[en] Meeting calendar event hash - The unique hash for the meeting

hs_meeting_change_id

text

[en] Meeting change id - The unique change id for the meeting

hs_meeting_created_from_link_id

text

[en] Created From Link ID - Created From Link ID

hs_meeting_end_time

timestamp

[en] Meeting end time - The date when the meeting ends

hs_meeting_external_url

text

[en] External URL - The external URL for the meeting

hs_meeting_location

text

[en] Meeting location - Where the meeting takes place

hs_meeting_location_type

text

[en] Location type - The type of location for the meeting event

hs_meeting_outcome

text

[en] Meeting outcome - The outcome of this meeting

hs_meeting_pre_meeting_prospect_reminders

text

[en] Pre-meeting prospect reminders - A list of dates when meeting reminders should be sent to prospects

hs_meeting_source

text

[en] Meeting source - The source where the meeting was booked

hs_meeting_source_id

text

[en] Source ID - The source ID of the meeting

hs_meeting_start_time

timestamp

[en] Meeting start time - The date when the meeting starts

hs_meeting_title

text

[en] Meeting name - The title of the meeting

hs_meeting_web_conference_meeting_id

text

[en] Web conference meeting ID - The meeting ID of the web conference

hs_merged_object_ids

text

[en] Merged object IDs - The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

float

[en] Updated by - The user who last updated the engagement

hs_object_id

float

[en] Object ID - The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name - The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue Memberships - The list of queues that contain this engagement

hs_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

timestamp

timestamp

portalid

text

engagementtype

text

tasktype

text

uuid

text

Engagements: Meetings: related objects

Replication type: Incremental

Parameters:

  • Related object: Select the related object to replicate

Relationships:

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo Tipo

meetings_id

text

    Engagements: Meetings > > id

1_id

text

    Contacts > > id

    Deals > > id

    Companies > > id

    Tickets > > id

association_type

text

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

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_all_assigned_business_unit_ids

text

[en] Business units - The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids - The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs - The IDs of the files that are attached to the engagement

hs_body_preview

text

[en] Body preview - A truncated preview of the engagegement body

hs_body_preview_html

text

[en] HTML Body Preview - The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated - Indicates if the engagement body was truncated for the preview

hs_created_by

float

[en] Activity created by - The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID - The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Create date - The date that an engagement was created

hs_engagement_source

text

[en] Engagement Source - The source that created this engagement

hs_engagement_source_id

text

[en] Engagement Source ID - The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action - What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted - Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_lastmodifieddate

timestamp

[en] Last modified date - The date any property on this engagement was modified

hs_merged_object_ids

text

[en] Merged object IDs - The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

float

[en] Updated by - The user who last updated the engagement

hs_note_body

text

[en] Note body - The body of the note

hs_object_id

float

[en] Object ID - The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name - The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue Memberships - The list of queues that contain this engagement

hs_timestamp

timestamp

[en] Activity date - The date that an engagement occurred

hs_unique_creation_key

text

[en] Unique creation key - Unique property used for idempotent creates

hs_unique_id

text

[en] Unique ID - The unique ID of the engagement

hs_updated_by_user_id

float

[en] Updated by user ID - The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

hs_user_ids_of_all_notification_followers

text

[en] User IDs of all notification followers - The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

hs_user_ids_of_all_notification_unfollowers

text

[en] User IDs of all notification unfollowers - The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

hs_user_ids_of_all_owners

text

[en] User IDs of all owners - The user IDs of all owners of this object

hubspot_owner_assigneddate

timestamp

[en] Owner Assigned Date - The timestamp when an owner was assigned to this engagement

hubspot_owner_id

text

[en] Activity assigned to - The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.

hubspot_team_id

text

[en] HubSpot Team - The team of the owner of an engagement.

hs_all_owner_ids

text

[en] All owner ids - The value of all owner referencing properties for this object, both default and custom

hs_all_team_ids

text

[en] All team ids - The team ids corresponding to all owner referencing properties for this object, both default and custom

hs_all_accessible_team_ids

text

[en] All accessible team ids - The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

Engagements: Notes: related objects

Replication type: Incremental

Parameters:

  • Related object: Select the related object to replicate

Relationships:

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo Tipo

notes_id

text

    Engagements: Notes > > id

1_id

text

    Contacts > > id

    Deals > > id

    Companies > > id

    Tickets > > id

association_type

text

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

createdat

timestamp

updatedat

timestamp

archived

boolean

hs_all_assigned_business_unit_ids

text

[en] Business units - The business units this record is assigned to.

hs_at_mentioned_owner_ids

text

[en] At-Mentioned Owner Ids - The owners that have been at-mentioned on the engagement

hs_attachment_ids

text

[en] Attached file IDs - The IDs of the files that are attached to the engagement

hs_body_preview

text

[en] Notes (preview) - A plain-text preview of the notes field on a task

hs_body_preview_html

text

[en] HTML Body Preview - The HTML representation of the engagement body preview

hs_body_preview_is_truncated

boolean

[en] Body Preview Truncated - Indicates if the engagement body was truncated for the preview

hs_calendar_event_id

text

[en] Calendar Event ID - The event ID for the synced task.

hs_created_by

float

[en] Created by - The user who created the engagement

hs_created_by_user_id

float

[en] Created by user ID - The user that created this object. This value is automatically set by HubSpot and may not be modified.

hs_createdate

timestamp

[en] Created at - The date that an engagement was created

hs_engagement_source

text

[en] Source - The source that created this engagement

hs_engagement_source_id

text

[en] Source ID - The specific ID of the process that created this engagement

hs_follow_up_action

text

[en] Follow up action - What action should be performed during follow up

hs_gdpr_deleted

boolean

[en] GDPR deleted - Indicates the body of this engagement has been cleared because of a GDPR delete request

hs_lastmodifieddate

timestamp

[en] Last modified at - The date any property on this engagement was modified

hs_merged_object_ids

text

[en] Merged object IDs - The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

hs_modified_by

float

[en] Last modified by - The user who last updated the engagement

hs_msteams_message_id

text

[en] MS Teams message ID - The message ID for the created task.

hs_num_associated_companies

float

[en] Associated Companies - The number of companies associated with this task

hs_num_associated_contacts

float

[en] Associated Contacts - The number of contacts associated with this task

hs_num_associated_deals

float

[en] Associated Deals - The number of deals associated with this task

hs_num_associated_queue_objects

float

[en] Associated Queue Objects - The number of objects associated with this task that support task queues

hs_num_associated_tickets

float

[en] Associated Tickets - The number of tickets associated with this task

hs_object_id

float

[en] Object ID - The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

hs_product_name

text

[en] Product name - The name of the product associated with this engagement

hs_queue_membership_ids

text

[en] Queue - The list of queues that contain this engagement

hs_task_body

text

[en] Notes - The content in the notes field on a task

hs_task_completion_date

timestamp

[en] Completed at - The date that the task was completed

hs_task_contact_timezone

text

[en] Contact Time Zone - The time zone of the associated contact

hs_task_for_object_type

text

[en] For Object Type - The object type for the task

hs_task_is_all_day

boolean

[en] Task is all day - Determines if the task is due all day or at a specific time

hs_task_last_contact_outreach

timestamp

[en] Last contacted - The last time a call, email, or meeting was logged for the associated contact. This is set automatically by HubSpot based on user actions in the contact record

hs_task_last_sales_activity_timestamp

timestamp

[en] Last engagement - The date of the last sales activity with the associated contact. This is set automatically by HubSpot based on user actions in the contact record

hs_task_priority

text

[en] Priority - The priority of task

hs_task_probability_to_complete

float

[en] Task probability to complete - The probability the task will be completed

hs_task_relative_reminders

text

[en] Relative Task Reminders - The dates (relative to the due date) when reminders will be sent

hs_task_reminders

text

[en] Reminder - The dates when reminders will be sent

hs_task_repeat_interval

text

[en] Interval - How often the task should repeat

hs_task_send_default_reminder

text

[en] Send Default Reminder - Whether or not a reminder should be sent when the task is due

hs_task_sequence_enrollment_active

boolean

[en] Sequence Enrollment Is Active - Whether the sequence enrollment this task is a part of is currently active

hs_task_sequence_step_enrollment_id

text

[en] Sequence step enrollment Id - The id of the sequence step that created the task

hs_task_sequence_step_order

float

[en] Sequence Step Order - The order of this task in the sequence at time of enrollment

hs_task_status

text

[en] Status - The status of the task

hs_task_subject

text

[en] Title - The subject text for the task

hs_task_template_id

float

[en] Task template id - The id of template the task was created from

hs_task_type

text

[en] Type - The type of task

hs_timestamp

timestamp

[en] Due date - The date that an engagement occurred

hs_unique_creation_key

text

[en] Unique creation key - Unique property used for idempotent creates

hs_unique_id

text

[en] Unique ID - The unique ID of the engagement

hs_updated_by_user_id

float

[en] Updated by user ID - The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

hs_user_ids_of_all_notification_followers

text

[en] User IDs of all notification followers - The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

hs_user_ids_of_all_notification_unfollowers

text

[en] User IDs of all notification unfollowers - The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

hs_user_ids_of_all_owners

text

[en] User IDs of all owners - The user IDs of all owners of this object

hubspot_owner_assigneddate

timestamp

[en] Owner Assigned Date - The timestamp when an owner was assigned to this engagement

hubspot_owner_id

text

[en] Assigned to - The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.

hubspot_team_id

text

[en] HubSpot Team - The team of the owner of an engagement.

hs_all_owner_ids

text

[en] All owner ids - The value of all owner referencing properties for this object, both default and custom

hs_all_team_ids

text

[en] All team ids - The team ids corresponding to all owner referencing properties for this object, both default and custom

hs_all_accessible_team_ids

text

[en] All accessible team ids - The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

hubspot_engagements_tasks_scheduledtasks

HubSpot Scheduled Tasks - Recurring or scheduled tasks

Campo Tipo

task_id

text

timestamp

timestamp

portalid

text

engagementtype

text

tasktype

text

uuid

text

Engagements: Tasks: related objects

Replication type: Incremental

Parameters:

  • Related object: Select the related object to replicate

Relationships:

HubSpot Object Associations - Relationships between standard HubSpot objects

Campo Tipo

tasks_id

text

    Engagements: Tasks > > id

1_id

text

    Contacts > > id

    Deals > > id

    Companies > > id

    Tickets > > id

association_type

text

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

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

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

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Line Items: related deals

Replication type: Incremental

Relationships:

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

Campo Tipo

line_item_id

text

    Line Items > > id

deal_id

text

    Deals > > id

association_type

text

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

Campo Tipo

id

text

userid

text

email

text

firstname

text

lastname

text

archived

boolean

createdat

timestamp

updatedat

timestamp

hubspot_owners_teams

Campo Tipo

owner_id

text

team_id

text

team_name

text

Pipelines

This pipeline is free

This pipeline is free

Replication type: Full

Parameters:

  • Pipeline type: Select the pipeline type to be replicated

Main object

Campo Tipo

default

boolean

displayorder

float

updatedat

float

active

boolean

objecttypeid

text

pipelineid

text

label

text

createdat

float

objecttype

text

hubspot_pipelines__stages

Campo Tipo

pipelineid

text

stages__label

text

stages__createdat

float

stages__stageid

text

stages__updatedat

float

stages__active

boolean

stages__displayorder

float

stages__metadata__isclosed

text

stages__metadata__probability

float

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

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

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

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Tickets: related companies

Replication type: Incremental

Relationships:

HubSpot Ticket-Deal Associations - Relationships between tickets and deals

Campo Tipo

ticket_id

text

    Tickets > > id

company_id

text

    Companies > > id

association_type

text

Tickets: related contacts

Replication type: Incremental

Relationships:

HubSpot Ticket-Contact Associations - Relationships between tickets and contacts

Campo Tipo

ticket_id

text

    Tickets > > id

contact_id

text

    Contacts > > id

association_type

text

Tickets: related deals

Replication type: Incremental

Relationships:

HubSpot Ticket-Deal Associations - Relationships between tickets and deals

Campo Tipo

ticket_id

text

    Tickets > > id

deal_id

text

    Deals > > id

association_type

text

Archived leads

Replication type: Full

Relationships:

Campo Tipo

id

text

    Leads > > id

archived

boolean

archivedat

timestamp

createdat

timestamp

properties__hs_createdate

timestamp

properties__email

text

properties__hs_associated_contact_firstname

text

properties__hs_lastmodifieddate

timestamp

properties__hs_associated_contact_lastname

text

updatedat

timestamp

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

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Payments

Replication type: Incremental

HubSpot Payments - Payment transactions and financial records

Campo Tipo

id

text

createdat

timestamp

updatedat

timestamp

archived

boolean

property_x

text

property_y

text

property_z

text

Properties Metadata

This pipeline is free

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

Notes

  • Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information