Forum Discussion

Delta_BenoitWILLEMS's avatar
Delta_BenoitWILLEMS
Copper Contributor
Sep 03, 2024

Microsoft Project REST API

Hello community,

 

I need your help. I'm trying to retrieve data about assignment through the REST API. I would like to have the same data from the Task view of the Project Web App.

 

 


This is the view where we can see all tasks assigned to a resource and the number of hours worked per day.

I'm able to do an API call to retrieve the list of all assignments of a resource. I can also retrieve the total of hours worked for a task (I think the field is "ActualWork").

But I can't find the number of hours worked per day. The one with the red rectangle.

 

Could someone help me where to find this information, please?

 

Thank you for your help.

 

Benoit W.

8 Replies

  • malshayeb's avatar
    malshayeb
    Copper Contributor
    If i understood the question correctly, you are looking for the work planned for each recourse on a timeline, you can find what you are looking for in the AssignmentTimephasedDataSet
    • Delta_BenoitWILLEMS's avatar
      Delta_BenoitWILLEMS
      Copper Contributor

      malshayeb Thank you for your prompt reply.

       

      The table that you are speaking about is in the ODATA end point. Not in the API ? Right ?

       

      And the problem with the ODATA is the fact that values are read only. I want to be able to edit its values.

       

      Benoit W

      • malshayeb's avatar
        malshayeb
        Copper Contributor

        i thought you are only looking to find the effort in a specific day, the only thing i can think of at the moment is this page about the rest API endpoints, in the EnterpriseResources/Assignments and the GetTimePhaseByURL    section of the page should give you a starting point, keep in mind some of those resources are really old. can i ask you what is the end goal you have in mind ? 

Resources