Finance | Project Operations, Human Resources, ...

OData extract Entities modified since a date

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (0)

Martin Dráb 238,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 303,397 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No