HubSpot

Data Replication

For Teams Created	Default Ingestion Frequency	Minimum Ingestion Frequency	Maximum Ingestion Frequency	Custom Frequency Range (in Hrs)
Before Release 2.21	1 Hr	30 Mins	24 Hrs	1-24
After Release 2.21	6 Hrs	30 Mins	24 Hrs	1-24

Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.

• Historical Data: The first run of the Pipeline ingests historical data for the selected objects on the basis of the historical sync duration specified at the time of creating the Pipeline and loads it to the Destination. Default duration: 3 Months

• Incremental Data: Once the historical load is complete, new and updated records for all objects except Owners and Email Campaigns are ingested as per the ingestion frequency.

Archived Objects

Hevo synchronizes the archived records for all the standard objects in Hubspot. For any archived record fetched from your Hubspot data, the archived flag is set to true.

The ingestion of archived Events is not coupled with the scheduled Pipeline runs due to the Source consideration around the handling of deletes. To reduce the number of Events being ingested during each Pipeline run, the ingestion frequency for deleted Events is set to 24 Hours. You can change this by reaching out to Hevo Support.

Merged Records

When two or more records within a standard or custom object are merged in HubSpot, only the resulting primary record is retained. This record consolidates the data of all secondary merged records. Subsequently, the secondary merged records are removed from HubSpot.

If the merge occurs before Hevo ingests the records, only the primary record is ingested into the Destination. However, if the merge occurs after ingestion, Hevo retains the secondary records in the Destination and flags them using the following fields:

Fields	Data type	Description
__hevo_merged	boolean	Contains the merged status of a record. It is set to TRUE only if the record is merged with another.
__hevo_merged_into	long	Contains the ID of the record into which it has been merged.

Using these fields, you can identify the stale data, if any, in the Destination.

---

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination:

Note: Effective Release 2.16, in Pipelines created with JDBC-based Destinations, Hevo creates the Destination schema based on the data retrieved from HubSpot. As a result, only fields that contain data are created in Destination tables, and the column limit is not exceeded.

---

Data Model

Hevo supports two API versions for ingesting data from HubSpot, v3 API and legacy API (v1 and v2). Depending on the API version you select, Hevo creates the following tables (objects) in the Destination when you run the Pipeline:

Note:

• Owners and Email Campaigns are Full Load objects, and the entire data is fetched in each run of the Pipeline. This may lead to higher Events quota consumption.

• For Pipelines created from Release 1.98 onwards: Hevo supports the data ingestion of custom objects and their associations. However, to ingest the data for associations, you need to contact Hevo Support.

• Effective Aug 31, 2023, HubSpot has stopped supporting the Calendar Events object. As a result, Hevo has stopped replicating data for the same.

HubSpot Legacy API

Note: If you select the Legacy API option while configuring your Source, Hevo ingests all the objects supported by legacy and v3 API. However, in subsequent updates, Hevo replicates data only for the legacy objects under the Legacy API option.

Object	Description
Calendar Events	Contains details of the events, such as meetings and appointments, in your HubSpot account.
Email Events	Contains details of user engagement with marketing emails sent from your HubSpot account.
Form Submissions	Contains details of form interactions, including contact ID, form ID, and the exact submission time.

HubSpot v3 API

As part of the latest API version in HubSpot, Hevo ingests the following tables (objects) in the Destination using HubSpot v3 API.

Object	Description
Contacts	Contains details of individuals that your organization interacts with.
Contact Deal Association	Contains details of the contacts associated with a deal within your HubSpot account.
Companies	Contains details about of the business your organization interacts with.
Custom Objects	Contains details of custom objects created in the HubSpot account for specific business requirements.
Deals	Contains details of an ongoing transaction associated with a contact or company.
Deal Company Association	Contains details of the deals associated with a company in your HubSpot account.
Deal Stage Pipeline	Contains details of the current status of deals in a HubSpot pipeline.
Deal Line Item Association	Contains details of the line items associated with a deal in your HubSpot account.
Email Campaigns	Contains details of the marketing emails sent to contacts to enhance engagement.
Engagements	Contain details of the interactions between your team and contacts via various modes of communication, such as emails, meetings, calls, and tasks.
Engagement Call	Contains details of all the calls made to the contacts in your HubSpot account.
Engagement Communications	Contains details of the interactions between a user and a contact via third-party channels, such as WhatsApp and LinkedIn.
Engagement Company Association	Contains details of the engagements associated with businesses within your HubSpot account.
Engagement Contact Association	Contains details of the engagements associated with contacts within your HubSpot account.
Engagement Deal Association	Contains details of engagements associated with dealswithin your HubSpot account.
Engagement Email	Contains details of all the email interactions between a user and a contact in your HubSpot account.
Engagement Meeting	Contains details of all the meetings that have been scheduled and managed in your HubSpot account. It includes meeting dates, participants, locations, agendas, and any additional relevant data related to the meetings.
Engagement Note	Contains details of the information captured for the interaction or communication with a contact.
Engagement Task	Contains details of the tasks assigned to a user in your Hubspot account. These tasks may include calls, emails, descriptions and relevant details.
Engagement Postal Mail	Contains details of the mail communications that a user has created and sent through HubSpot. It allows users to manage offline communications with contacts and track their interactions.
Line Items	Contains details of products or services that are associated with a deal.
Owners	Contains the list of HubSpot users with the owner role.
Products	Contains details of goods or services that your company sells.
Tickets	Contains details of the inquiries, support requests, or issues raised by the customers.
Ticket Stage Pipeline	Contains details of the current status of a ticket.

---