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
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
Thanks for the inputs Paul. With respect to the Notes, Predecessors and successor, i agree that there is no direct way to get these fields using the direct odata API query.
But it seems to be the case for the 'Resource Names' filed as well. Please find below screen shot of the field that i am looking for in the reporting API. Please advice
Hello Lalith_Damera ,
You can assignment data from the assignments endpoint, for example: _api/ProjectData/Assignments
Paul
- That information would be in the Odata Query : https://<HostName>/sites/<SiteName>/_api/ProjectData/Assignment table.
With the exception of the Notes field all of these fields are directly available via OData API queries. I actually have them in my data model.
