REST API Use to Get WorkExpense Total, ActualExpense Total, and Latest User Comment for List of Project

Jim Fuhring

• March 20, 2019 16:21

I would like to form a REST API Query from Excel to extract the WorkExpense, ActualExpense, and latest User comment from a list of projects. Here is my current query to get that list of projects: 

https://jdpatechnology.projectinsight.net/api/project/search?isActive=true&modelProperties=Name,ProjectType,ProjectStatus,WorkpercentComplete,PrimaryProjectManager,StartDateTimeUTC,EndDateTimeUTC,DescriptionText,TargetWorkTotalExpense;PrimaryProjectManager:FirstName,LastName;ProjectType:Name;ProjectStatus:Name

 

I'm able to get the Actual and Work Expense for a single project using a project's id. How do I get the expenses for a list of projects above?

 

https://jdpatechnology.projectinsight.net/api/expense-entry/project/b37a9e4f4e314e61b5b730d601296535?modelProperties=ActualCost

 

Latest user comment as well:

 

https://jdpatechnology.projectinsight.net/api/comment/list-by-object-user-comments/b37a9e4f4e314e61b5b730d601296535

1

• 

  Richard Gold

  • May 14, 2019 21:50

  Hello Jim.

  You can get all the "last comment" values in a single API call like this:

  /api/project/list?ids=[PROJECT_ID_1,PROJECT_ID_2,...]&modelProperties=LastComment

  The actual and work expense values will require you to perform the API call like you are already doing, but in a loop, making a separate call for each project ID.

  Hope that helps!

  0

Please sign in to leave a comment.