LeadPropertiesHistory
Retrieves the history of changes made to lead properties for auditing lead data updates.
Table Specific Information
Select
The component uses the HubSpot API to retrieve the property history for leads.
Note: PropertyName must be included in the WHERE clause to retrieve any data from the LeadPropertiesHistory view. This filter is required by the API and is evaluated server-side.
The following is an example query:
SELECT * FROM LeadPropertiesHistory WHERE PropertyName = 'my_property'
Columns
| Name | Type | References | Filterable | Description |
| PropertyName | String | False | The internal name of the property that was updated. | |
| Value | String | False | The previous value of the property before it was changed. | |
| SourceType | String | False | Indicates how the property change was triggered, such as by user action or integration. | |
| SourceId | String | False | Optional metadata providing additional context about the source of the update. | |
| Timestamp | Datetime | False | The date and time the property change occurred. | |
| LeadId | Long | False | Unique identifier of the lead whose property was updated. |