OrderPropertiesHistory
Retrieves the history of changes made to order properties for auditing purposes.
Table Specific Information
Select
The connector uses the HubSpot API to retrieve the property history for orders.
Note: PropertyName must be included in the WHERE clause to retrieve any data from the OrderPropertiesHistory view. This filter is required by the API and is evaluated server-side.
The following is an example query:
SELECT * FROM OrderPropertiesHistory WHERE PropertyName = 'my_property'
Columns
| Name | Type | References | Filterable | Description |
| PropertyName | String | False | The internal name of the property whose value changed. | |
| Value | String | False | The previous value of the property before the update. | |
| SourceType | String | False | Indicates how the property was updated, such as manually or via integration. | |
| SourceId | String | False | Additional metadata identifying the source of the change, if available. | |
| Timestamp | Datetime | False | The date and time when the property change occurred. | |
| OrderId | Long | False | The unique identifier of the order associated with this property history record. |