Project Online ReST API Get Projects related tasks, assignments, resources

Contributor

Hello Everyone,

 

Does anyone knows the endpoint to fetch a project it's related tasks, assignments, and resources in one go? Basically I want a summary view of projects and it's related tasks, assignments and resources.

 

Thanks & Regards,

Rohan

1 Reply

@rohanw24 you need to combine the query for Projects, Tasks, Assignments and Resources. In each of the tables has the relationship such as ProjectId, TaskId, AssignmentId, ResourceId.

 

If you want to get the summary of view, I would recommend using Power BI instead custom.