Unique Circumstance here, trying to extract Dataverse Metadata to document our Environments on a reoccurring basis.
Wanting to pull Entity Metadata and their Attribute Metadata (Logical, Schema, Collection Name(s) etc.) to document and track changes.
After the initial run, I would like this flow to only run and update on Entities that have been edited. (Table Columns dropped, renamed, added etc.)
To do this, I need to sort the Entities by their ModifiedOn date. The ModifiedOn date for an Entity displayed in the Modern interface appears to be the same as what can be retrieved from the WebAPI (..../api/data/v9.0/EntityDefinitions).
The Problem here is that this ModifiedOn date only seems to update or change when the Properties of the Entity are edited (Such as Change Tracking Enabled, Audit Enabled, Searchable etc.) and doesn't appear to change/update when Attributes are renamed or edited, added or deleted.
I also attempted to query all the attributes thinking I could sort them by their ModifiedOn value, and then extract the parent table and find my changes that way. It doesnt appear to return a ModifiedOn date for an Attribute nor the parent Entity value.
(..../api/data/v9.0/attributes)
Where and how are modifications to a Table's structure logged and documented in the Metadata? There are many default entity related tables but I cannot seem to find a way to view when Table Columns are edited. (Ex: msdyn_entityconfiguration, msdyn_entitydeltachange, msdyn_entityconfig )
Please note, I am not interested in changes to the RECORDs, just the Entities.
Thanks in advance.
