Property Columns in the DEAL Table Return null Values

Issue

Certain property columns in the DEAL table contain null values, even though relevant data exists in the source.

Environment

Connector: HubSpot

Resolution

To access the correct data, query the corresponding version 2 columns in your destination. For example, use property_hs_v2_date_entered_xxxxxxx instead of property_hs_date_entered_xxxxxxx.

Cause

This issue occurs when HubSpot deprecates older property fields for the DEAL object. The deprecated fields no longer return values in the API response, resulting in null values.