Hi,
I am looking to extract entities that have been modified since a specific date.
However ( for example entity SalesOrderHeaders ) I can't see any ModifitedData when I query the odata feed. For example, i am doing a get mybaseurl/data/SalesOrderHeaders?cross-company=true the response doesn't include any Modified data so I assumed there isn't.
How could I perform this filtered extract ? I will avoid me extracting the whole dataset every time.
Regards
Vincent Diallo-Nort
Note that entities typically consists of multiple tables, therefore it's not as simple as exposing a single field.
BYOD synchronization utilizes change tracking; maybe you could consider something like that.
I've also seen people building a computed column returning the highest ModifiedDateTime value from all tables used in the entity.
Hi Vincent,
I have used BYOD as a step in between. When you enable change tracking and schedule at least once a day, you would have your information. In BYOD, the entity automatically gets an additional column for the sync date/time. This can be your workaround to use it as modification date.
HI Vincent Diallo-Nort.
Agree to enable change tracking.
Another way is to use a computed column (Martin mentioned). You can use the SysComputedColumn::returnField () method to get the modified field .
However, there is a problem to note that some data source tables do not have ModifiedDateTime enabled.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,028
André Arnaud de Cal... 878 Super User 2025 Season 2
Sohaib Cheema 579 User Group Leader
