Forum Discussion
Solved
Project Odata API doesn't fetch columns like Predecessors, Notes, Resource Names
We are connecting to Project Online via an Odata Query for reporting in Power BI. I am not able to fetch the fields like Notes, Predecessors, Resource Names. May i know why these fields as not be...
Hello Lalith_Damera ,
- Task Notes have never been in the reporting API, you can get some of the Note data in the Tasks CSOM API: /_api/ProjectServer/Projects('{projectGuid}')/Tasks
- Resources Names are in the Resources endpoint in the reporting API
- Reporting on Predecessors and successors- this will help: https://pwmather.wordpress.com/2018/10/13/projectonline-reporting-on-task-predecessors-and-successors-o365-msproject-ppm-pmot-excel-powerbi-odata/
Paul
Lalith_Damera
Notes - I believe that information is no longer accessible, but I could be wrong.
Resource Name - OData.Feed(SiteBaseURL & "/_api/ProjectData/Resources?$select=ResourceId, ResourceName", null, [Implementation = "2.0"])
Predecessor and Successor info can be found in the ProjectServer Project/TaskLinks table, This should get you started
- OData.Feed(SiteBaseURL & "/_api/ProjectServer/Projects").
- Remove all columns EXCEPT TaskLinks
- Expand table and select the fields you want
- Link this data into your model to get project name and task name
Here is a link to Schema: ReportingData (ProjectData service) | Microsoft Learn