Project online - Timereporting data for limited period

[fiilen]

Hi

We have a time registration report based on the OData feed to project online.

We extract the timesheetLines and use this to aggregate the required data. Unfortunately there are thousands of records in this table, and the extract runs quite slow.

We only need data for the last couple of months, but the table holds date for almost two years.

Is there any way to limit the extract to only pull current month + the last two months? I know I can filter this in the reports, but I want to get the data out already at the extraction point.

Regards

Michael

[v-yuezhe-msft · Accepted solution]

@fiilen,

You can add $filter parameter into your OData URL. For more details, please review the examples in the blog below.

https://pwmather.wordpress.com/tag/excel/
https://project-brain.com/2016/07/24/odata-reports-with-project-onlineproject-server-part2/

A detailed list about filter command is listed in this article.


Regards,
Lydia