Hello!
I think, you can use TMF630 REST API Design Guidelines Part 1 paragraph 4.4. Query Resources with attribute filtering.
For historic filtering in TMF 653 you can use startDateTime, endDateTime attributes.
If you have 2 databases (first for current operations, second for historic purposes) with replication, API endpoint for users must be same, I think.
If your question was, how copy objects from source to data warehouse, you can use filtering by startDateTime, endDateTime attributes with pagination.
------------------------------
Vitalii Zhakov
Veschatel LLC
------------------------------