HubSpot

Last updated on Sep 03, 2024

HubSpot is a system for managing customer relationships and storing data. You can use Hevo Pipelines to replicate data from your HubSpot account to the Destination database or data warehouse using HubSpot REST API.

You can use Open Authorization (OAuth) to authenticate your HubSpot account with Hevo.


Source Considerations

  • HubSpot does not allow fetching deleted records based on a timestamp. While this can lead to a higher number of ingested Events, Hevo deduplicates such Events upon ingestion. Only the Events that were deleted after the last run of the Pipeline (based on the archived_at timestamp) count as new Events and are treated as billable.

  • Due to an open issue with Hubspot relating to the Contacts object, the exact time at which a contact was deleted or archived cannot be determined. For the archived_at timestamp, the HubSpot API returns the last updated_at timestamp instead of the actual deletion/archival time. Due to this, the last tracked deletion of Contacts data cannot be definitively identified, and Hevo must ingest all the deleted contacts and de-duplicate them while loading to the Destination. Therefore, it is always a full load of archived Contacts data, and these Events are included in your billable Events count.

    Read Announcing a new definition for the archivedAt endpoint response value.


Limitations

  • HubSpot CRM API returns the updates for up to 10,000 records for the same modified timestamp. If other records are updated at that particular point of time, they are not reflected or synchronized with the Destination.

  • Hevo does not support replication of the Company Contact object for all Pipelines created after March 31, 2023.


See Also


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Mar-05-2024 2.21 Updated the ingestion frequency table in the Data Replication section.
Dec-29-2023 NA Updated the page to reflect the latest Hevo functionality.
Sep-04-2023 NA Updated the note in the Schema and Primary Keys section to state that the Destination schema for Pipelines with JDBC Destinations is derived from the Source data.
Jul-25-2023 2.15 Updated sections:
- Configuring HubSpot as a Source to add information about HubSpot API version option.
- Data Model with the latest list of objects and their respective descriptions.
Jul-20-2023 NA Updated section, Data Model to add information about HubSpot deprecating an object.
Apr-25-2023 2.12 Updated section, Data Model to add a note regarding the ingestion of custom object associations.
Apr-04-2023 NA Updated section, Configuring HubSpot as a Source to update the information about historical sync duration.
Jan-10-2023 2.05 Updated section, Data Model to include information about the new object supported by Hevo.
Nov-07-2022 NA Updated section, Data Model for more clarity and detail.
Sep-21-2022 1.98 Updated sections, Data Model and Source Considerations to include information about custom objects.
Sep-05-2022 NA - Updated section, Data Replication to restructure the content for better understanding and coherence.
- Updated section, Configuring HubSpot as a Source to reflect the latest UI changes.
Apr-25-2022 1.87 Updated section, Limitations about Hevo using the CRM API v3 to fetch HubSpot data.
Nov-22-2021 1.76 In the Data Model section:
- Added the Owner object.
- Changed the description for the Email Campaigns object.
- Added a note to indicate that Email Campaign and Owner are Full Load objects.
Oct-25-2021 1.74 - Updated the page overview.
- Added the section, Source Considerations.
- Added information about handling of deleted records and the available Pipeline frequencies in the Data Replication section.
Aug-09-2021 1.69 Added a note in the Data Replication section about archived objects ingested from the Source.
Jul-12-2021 1.67 Updated the Data Model section with additional objects that Hevo now supports.

Tell us what went wrong