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

All responses (3)

Answers (0)

Blue Wang on at

Like (0)

Report

RE: OData extract Entities modified since a 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.
Suggested answer

André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

RE: OData extract Entities modified since a date

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.
Martin Dráb 233,017 Most Valuable Professional on at

Like (0)

Report

RE: OData extract Entities modified since a date

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.