How to fetch the details of deleted tasks between a date range using Project API queries Microsoft Project Online

Question

We are having a project online PWA site which is being used for creating Project plans for which Tasks and Milestones are associated. The data from the PWA is retrieved for utilisation of the same in the Power BI

We are using a Project Odata tasks api '<sitename>/_api/ProjectData/Tasks?$filter=(TaskModifiedDate ge datetime'2023-08-07T00:00:00Z' and TaskModifiedDate lt datetime'2023-08-07T02:00:00Z')' to get the records, which are consumed by third party tool to create a datatable.

we are using 'TaskModifiedDate' as a filter to get only the records that had updates and upsert is done accrdingly to the data table.

If any Task is deleted for a Project plan in PWA, the deleted task details would not be fetched using the query, due to which the same task details would still be present in the data table and have been already deleted from the Project web app which results in data mismatch.

Can anyone please suggest on how to overcome this issue. Is there anyway where we can get the deleted task details, which can then be used to delete the same record in the downstream data table as well.

Much appreciate your help !!

Answer 1

Hi@Lalith Damera

Since your issue is about Project , and our forum focus on SharePoint. I wil recommend you to raise a new ticket Microsoft Project Community. This is a Microsoft forum dedicated to discussing Project. You might get some more professional advice there. Thanks for your understanding.

Here is Microsoft Project Community:

https://techcommunity.microsoft.com/t5/project/ct-p/Project

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best Regards

Cheng Feng