Returns the history of changes to company properties, useful for auditing and tracking data evolution.

Select

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

SELECT * FROM CompanyPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name	Type	References	Filterable	Description
PropertyName	String		True	Name of the company property whose historical value is being recorded.
Value	String		False	Previous value of the property before it was updated.
SourceType	String		False	Indicates the method or source responsible for changing the property value, such as API, user action, or workflow.
SourceId	String		False	Additional identifier related to the source of the change. May be empty depending on the source type.
Timestamp	Datetime		False	Timestamp of when the property value was updated.
CompanyId	Long		False	Unique identifier of the company record associated with the property history.