Retrieve the available Deal properties history in HubSpot.

Select

The PropertyName filter is required to retrieve data from this view:

SELECT * FROM DealPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name	Type	References	Filterable	Description
PropertyName	String		False	The name of the property.
Value	String		False	The historical value of the property.
SourceType	String		False	The method by which the property was changed.
SourceId	String		False	Additional data related to the source. May not be populated for all sources.
Timestamp	Datetime		False	Datetime when the property was updated.
DealId	Long		False	The deal identifier.