OrderPropertiesHistory
Retrieves the history of changes made to order properties for auditing purposes.
Table Specific Information
Select
The add-in 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. |