Updates
Back to All

📢ModifiedOnly DateType

10 days ago by Robert Heynen

A new ModifiedOnly DateType Filter is being introduced across various APIs within the RDEA 2.0 system.

ModifiedOnly provides a way to retrieve records based specifically on their Modified Date, without falling back to other date fields.

Why it matters

This change provides a more precise and predictable way to perform incremental record retrieval.

It allows API consumers to distinguish between:

  • Records that entered the system during a specified date range.
  • Records that were actually modified during a specified date range.

This is particularly useful for integrations that need to identify changes to existing records without unintentionally retrieving records solely because they were processed or submitted during the specified period.

Previous behavior

When using the Modified DateType Filter, records were selected using a coalesced date value based on the following order:

Modified Date → Processed Date → Submitted Date

As a result, a record without a Modified Date could still be returned if its Processed Date or Submitted Date fell within the specified date range.

This meant that the Modified DateType Filter did not necessarily identify only records that had actually been modified.

New behavior

The new ModifiedOnly DateType Filter selects records only when the record has an actual Modified Date that falls within the specified date range.

Records are not included based on their Processed Date or Submitted Date when ModifiedOnly is used.

For example, API consumers can use separate requests to retrieve different sets of records:

  • Processed DateType – Retrieves records that entered the system during the specified date range.
  • ModifiedOnly DateType – Retrieves records that were actually modified during the specified date range.

The existing Modified DateType behavior remains based on the coalesced date logic described above.

What to Expect

API consumers that need to identify only records that were modified should use the new ModifiedOnly DateType Filter.

This provides greater control over incremental data retrieval and helps prevent records from being returned solely because their Processed or Submitted Date falls within the requested date range.

Existing integrations using the Modified DateType Filter should continue to use that filter if the existing coalesced-date behavior is required.

Note: This functionality is also available in the newest Power BI Connector, version 3.1.4.