SSIS Components for HubSpot

Build 25.0.9434

TicketPropertiesHistory

Returns the history of changes made to ticket properties, useful for auditing ticket updates.

Select

The PropertyName filter is required to retrieve data from this view. When querying TicketPropertiesHistory, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = and IN.
SELECT * FROM TicketPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name Type References Filterable Description
PropertyName String True Name of the ticket property whose value changed.
Value String False The previous or historical value of the property.
SourceType String False Indicates how the change was made, such as by user action, workflow, or integration.
SourceId String False Additional identifier related to the source of the change, if available.
Timestamp Datetime False Date and time when the property value was updated.
TicketId Long False Unique identifier of the ticket associated with this property history entry.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434