Does the Azure Data Factory HubSpot connector v2.0 (Preview) support incremental load?

Tariq Riahi 20 Reputation points
2026-06-15T07:21:26.49+00:00

The HubSpot connector 1.0 supported incremental loads by means of passing a query. The new 2.0 connector does not support queries. Does that mean the new connector does not support incremental loads, or is there some other option? Fetching all of the data to staging would be highly inefficient and unusable.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments

Answer accepted by question author

Pilladi Padma Sai Manisha 10,945 Reputation points Microsoft External Staff Moderator
2026-06-15T09:14:27.8433333+00:00

Hi @Tariq Riahi

You're correct that the HubSpot connector v2.0 (Preview) no longer supports the query property, which was commonly used in v1.0 to implement incremental loads.

As a result, the v1.0 query-based incremental pattern doesn't carry over to v2.0.

The current v2.0 documentation focuses on accessing supported HubSpot objects via tableName, and it does not describe an equivalent built-in incremental load capability that replaces query.

If incremental ingestion is required, you'll likely need to implement it at the ADF pipeline level, for example:

  • Maintain a watermark value (such as a last modified timestamp or ID).
  • Store the latest processed value in an external control table or metadata store.
  • Use pipeline logic to process only new or changed records where possible.

If you're migrating from v1.0 and depend heavily on query-based delta extraction, you may want to validate whether your specific HubSpot objects expose fields that can support a custom watermark strategy before moving to v2.0.

Documentation:

If you can share which HubSpot objects/tables you're loading and whether you're using Copy activity or Mapping Data Flows, we can suggest a more specific incremental loading pattern.

Was this answer helpful?

1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tariq Riahi 20 Reputation points
    2026-07-06T09:47:55.31+00:00

    [removed]

    Was tot relevant after all.

    Was this answer helpful?

    0 comments
  2. Tariq Riahi 20 Reputation points
    2026-06-15T12:41:50.7066667+00:00

    Hi @Pilladi Padma Sai Manisha

    Thanks for the explanation. I understand that the query property used in HubSpot connector v1.0 is no longer available in v2.0.

    However, I am still unclear whether incremental extraction is actually supported by the v2.0 connector.

    For example, when loading objects such as Contacts, Leads, Calls, and similar HubSpot entities using Copy Activity, can the v2.0 connector retrieve only records changed since a given timestamp (for example hs_lastmodifieddate > @watermark), or does it always read the full object and require filtering after the data has already been extracted?

    In other words, is there a documented source-side incremental/delta extraction capability in the v2.0 connector that replaces the v1.0 query functionality, or is full extraction/REST API currently the only supported approach?

    I worry that retrieving the full dataset every night might keep the pipeline occupied for too long.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.