Download Activity/Assignment Spread
get
/api/restapi/action/spreadResult/{jobId}
Send a request to this endpoint to download the activity or assignment spread file once the Calculate Activity/Assignment Spread job has completed. Track the status of the Calculate Activity/Assignment Spread job using the View Job Status endpoint.
Request
Path Parameters
-
jobId(required): integer(int64)
The jobId field value returned as part of the Calculate Activity/Assignment Spread endpoint response.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/octet-stream
200 Response
The response returned by the Download Activity/Assignment Spread endpoint is available as a zip file. Unzip the file to retrieve the JSON file inside the zip file.
Root Schema : ApiEntitySpreadOutput
Type:
object
Title:
Show Source
ApiEntitySpreadOutput
-
activities: array
activities
The aggregate that contains the list of activities used in the spread calculation. It is applicable when downloading the spread output for Calculate Activity Spread jobs.
-
project:
project
The aggregate that contains key information about the project used in the spread calculation.
-
resourceAssignments: array
resourceAssignments
The aggregate that contains the list of resource assignments used in the spread calculation. It is applicable when downloading the spread output for Calculate Assignment Spread jobs.
-
timescale: string
Allowed Values:
[ "DAILY", "WEEKLY", "MONTHLY", "QUARTERLY" ]
Timescale for the spread calculation. If not provided, Daily will be used.
Nested Schema : activities
Type:
array
The aggregate that contains the list of activities used in the spread calculation. It is applicable when downloading the spread output for Calculate Activity Spread jobs.
Show Source
-
Array of:
object ApiEntitySpreadOutputActivity
Title:
ApiEntitySpreadOutputActivity
Nested Schema : project
The aggregate that contains key information about the project used in the spread calculation.
Match All
Show Source
-
object
ApiEntitySpreadOutputProject
Title:
ApiEntitySpreadOutputProject
Nested Schema : resourceAssignments
Type:
array
The aggregate that contains the list of resource assignments used in the spread calculation. It is applicable when downloading the spread output for Calculate Assignment Spread jobs.
Show Source
-
Array of:
object ApiEntitySpreadOutputAssignment
Title:
ApiEntitySpreadOutputAssignment
Nested Schema : ApiEntitySpreadOutputActivity
Type:
object
Title:
Show Source
ApiEntitySpreadOutputActivity
-
activityCode: string
Maximum Length:
60
The user-specified identifier of the activity. -
activityId: integer
(int64)
The unique identifier for the activity.
-
activityName: string
Maximum Length:
255
The name of the activity. -
actualTotalCost: number
(double)
The actual total cost for all resource assignments and direct activity costs (expenses) on the activity.
-
actualTotalCostProject: number
(double)
The actual total cost for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
-
atCompletionTotalCost: number
(double)
The sum of the actual costs plus remaining costs for all resource assignments and direct activity costs (expenses) on the activity. This field is in base currency and is calculated from atCompletionTotalCostProject field based on the specified exchange rate.
-
atCompletionTotalCostProject: number
(double)
The sum of the actual costs plus remaining costs for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
-
earnedValueCost: number
(double)
The portion of the baseline total cost of the activity that is actually completed as of the project data date. This field is in base currency and is calculated from earnedValueCostProject field based on the specified exchange rate.
-
earnedValueCostProject: number
(double)
The approved budget for work actually completed by the specified project data date.
Calculated as Budget At Completion multiplied by Performance Percent Complete. The method for computing performance percent complete depends on the Earned Value technique defined in the project settings. This value is based on the project currency. -
estimateAtCompletionCost: number
(double)
Calculated as estimate to completion cost plus Actual Cost to Date. This field is in base currency and is calculated from estimateAtCompletionCostProject field based on the specified exchange rate.
-
estimateAtCompletionCostProject: number
(double)
The forecasted cost of the project as the project progresses. This value is based on the project currency.
-
estimateToCompleteCost: number
(double)
Calculated as estimate to completion cost plus Actual Cost to Date. This field is in base currency and is calculated from estimateToCompletionCostProject field based on the specified exchange rate.
-
estimateToCompleteCostProject: number
(double)
The estimated cost to complete the activity. This value is based on the project currency.
-
estimateToCompleteLaborUnits: integer
(int64)
The estimated number of labor units required to complete the activity.
Calculated as the Remaining Total Units for the activity. -
plannedTotalCost: number
(double)
The expected total cost of the activity and includes all resources and direct activity costs (expenses). This field is in base currency and is calculated from plannedTotalCostProject field based on the specified exchange rate.
-
plannedTotalCostProject: number
(double)
The expected total cost of the activity, including all resource assignments and direct activity costs. This value is based on the project currency.
-
plannedValueCost: number
(double)
The portion of the baseline total cost of the activity that is scheduled to be completed as of the project data date. This field is in base currency and is calculated from plannedValueCostProject field based on the specified exchange rate.
-
plannedValueCostProject: number
(double)
The approved budget for the work scheduled to be completed by a specified date.
Calculated as Budget At Completion multiplied by Schedule Percent Complete.
When an activity has assignments, the Planned Value Cost is calculated as Budget At Completion multiplied by (Data Date of Current Project - Baseline Assignment Start Date) divided by (Baseline Assignment Finish Date - Baseline Assignment Start Date). Each assignment is then summed to the activity-level planned value. This value is based on the project currency. -
remainingTotalCost: number
(double)
The remaining cost for all resource assignments and direct activity costs (expenses) on the activity. This field is in base currency and is calculated from remainingTotalCostProject field based on the specified exchange rate.
-
remainingTotalCostProject: number
(double)
The remaining cost for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
-
spread:
spread
The aggregate that contains the lists of spread dates and spread values for the activity spread items in the request. The spread values and dates are correlated by the indices in the lists. This aggregate is applicable when downloading the spread output for Calculate Activity Spread jobs.
-
wbsId: integer
(int64)
The WBS that the activity is associated with.
Nested Schema : spread
The aggregate that contains the lists of spread dates and spread values for the activity spread items in the request. The spread values and dates are correlated by the indices in the lists. This aggregate is applicable when downloading the spread output for Calculate Activity Spread jobs.
Match All
Show Source
-
object
ApiEntitySpreadOutputActivitySpread
Title:
ApiEntitySpreadOutputActivitySpread
Nested Schema : ApiEntitySpreadOutputActivitySpread
Type:
object
Title:
Show Source
ApiEntitySpreadOutputActivitySpread
-
actualTotalCost: array
actualTotalCost
The actual total cost for all resource assignments and direct activity costs (expenses) on the activity.
-
actualTotalCostProject: array
actualTotalCostProject
The actual total cost for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
-
atCompletionTotalCost: array
atCompletionTotalCost
The sum of the actual costs plus remaining costs for all resource assignments and direct activity costs (expenses) on the activity. This field is in base currency and is calculated from atCompletionTotalCostProject field based on the specified exchange rate.
-
atCompletionTotalCostProject: array
atCompletionTotalCostProject
The sum of the actual costs plus remaining costs for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
-
earnedValueCost: array
earnedValueCost
The portion of the baseline total cost of the activity that is actually completed as of the project data date. This field is in base currency and is calculated from earnedValueCostProject field based on the specified exchange rate.
-
earnedValueCostProject: array
earnedValueCostProject
The approved budget for work actually completed by the specified project data date.
Calculated as Budget At Completion multiplied by Performance Percent Complete. The method for computing performance percent complete depends on the Earned Value technique defined in the project settings. This value is based on the project currency. -
estimateAtCompletionCost: array
estimateAtCompletionCost
Calculated as estimate to completion cost plus Actual Cost to Date. This field is in base currency and is calculated from estimateAtCompletionCostProject field based on the specified exchange rate.
-
estimateAtCompletionCostProject: array
estimateAtCompletionCostProject
The forecasted cost of the project as the project progresses. This value is based on the project currency.
-
estimateToCompleteCost: array
estimateToCompleteCost
Calculated as estimate to completion cost plus Actual Cost to Date. This field is in base currency and is calculated from estimateToCompletionCostProject field based on the specified exchange rate.
-
estimateToCompleteCostProject: array
estimateToCompleteCostProject
The estimated cost to complete the activity. This value is based on the project currency.
-
estimateToCompleteLaborUnits: array
estimateToCompleteLaborUnits
The estimated number of labor units required to complete the activity.
Calculated as the Remaining Total Units for the activity. -
plannedTotalCost: array
plannedTotalCost
The expected total cost of the activity and includes all resources and direct activity costs (expenses). This field is in base currency and is calculated from plannedTotalCostProject field based on the specified exchange rate.
-
plannedTotalCostProject: array
plannedTotalCostProject
The expected total cost of the activity, including all resource assignments and direct activity costs. This value is based on the project currency.
-
plannedValueCost: array
plannedValueCost
The portion of the baseline total cost of the activity that is scheduled to be completed as of the project data date. This field is in base currency and is calculated from plannedValueCostProject field based on the specified exchange rate.
-
plannedValueCostProject: array
plannedValueCostProject
The approved budget for the work scheduled to be completed by a specified date.
Calculated as Budget At Completion multiplied by Schedule Percent Complete.
When an activity has assignments, the Planned Value Cost is calculated as Budget At Completion multiplied by (Data Date of Current Project - Baseline Assignment Start Date) divided by (Baseline Assignment Finish Date - Baseline Assignment Start Date). Each assignment is then summed to the activity-level planned value. This value is based on the project currency. -
remainingTotalCost: array
remainingTotalCost
The remaining cost for all resource assignments and direct activity costs (expenses) on the activity. This field is in base currency and is calculated from remainingTotalCostProject field based on the specified exchange rate.
-
remainingTotalCostProject: array
remainingTotalCostProject
The remaining cost for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
-
spreadDates: array
spreadDates
The list of spread dates derived according to the timescale for all the spread items in the request.
Nested Schema : actualTotalCost
Type:
array
The actual total cost for all resource assignments and direct activity costs (expenses) on the activity.
Show Source
Nested Schema : actualTotalCostProject
Type:
array
The actual total cost for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
Show Source
Nested Schema : atCompletionTotalCost
Type:
array
The sum of the actual costs plus remaining costs for all resource assignments and direct activity costs (expenses) on the activity. This field is in base currency and is calculated from atCompletionTotalCostProject field based on the specified exchange rate.
Show Source
Nested Schema : atCompletionTotalCostProject
Type:
array
The sum of the actual costs plus remaining costs for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
Show Source
Nested Schema : earnedValueCost
Type:
array
The portion of the baseline total cost of the activity that is actually completed as of the project data date. This field is in base currency and is calculated from earnedValueCostProject field based on the specified exchange rate.
Show Source
Nested Schema : earnedValueCostProject
Type:
array
The approved budget for work actually completed by the specified project data date.
Calculated as Budget At Completion multiplied by Performance Percent Complete. The method for computing performance percent complete depends on the Earned Value technique defined in the project settings. This value is based on the project currency.
Show Source
Calculated as Budget At Completion multiplied by Performance Percent Complete. The method for computing performance percent complete depends on the Earned Value technique defined in the project settings. This value is based on the project currency.
Nested Schema : estimateAtCompletionCost
Type:
array
Calculated as estimate to completion cost plus Actual Cost to Date. This field is in base currency and is calculated from estimateAtCompletionCostProject field based on the specified exchange rate.
Show Source
Nested Schema : estimateAtCompletionCostProject
Type:
array
The forecasted cost of the project as the project progresses. This value is based on the project currency.
Show Source
Nested Schema : estimateToCompleteCost
Type:
array
Calculated as estimate to completion cost plus Actual Cost to Date. This field is in base currency and is calculated from estimateToCompletionCostProject field based on the specified exchange rate.
Show Source
Nested Schema : estimateToCompleteCostProject
Type:
array
The estimated cost to complete the activity. This value is based on the project currency.
Show Source
Nested Schema : estimateToCompleteLaborUnits
Type:
array
The estimated number of labor units required to complete the activity.
Calculated as the Remaining Total Units for the activity.
Show Source
Calculated as the Remaining Total Units for the activity.
Nested Schema : plannedTotalCost
Type:
array
The expected total cost of the activity and includes all resources and direct activity costs (expenses). This field is in base currency and is calculated from plannedTotalCostProject field based on the specified exchange rate.
Show Source
Nested Schema : plannedTotalCostProject
Type:
array
The expected total cost of the activity, including all resource assignments and direct activity costs. This value is based on the project currency.
Show Source
Nested Schema : plannedValueCost
Type:
array
The portion of the baseline total cost of the activity that is scheduled to be completed as of the project data date. This field is in base currency and is calculated from plannedValueCostProject field based on the specified exchange rate.
Show Source
Nested Schema : plannedValueCostProject
Type:
array
The approved budget for the work scheduled to be completed by a specified date.
Calculated as Budget At Completion multiplied by Schedule Percent Complete.
When an activity has assignments, the Planned Value Cost is calculated as Budget At Completion multiplied by (Data Date of Current Project - Baseline Assignment Start Date) divided by (Baseline Assignment Finish Date - Baseline Assignment Start Date). Each assignment is then summed to the activity-level planned value. This value is based on the project currency.
Show Source
Calculated as Budget At Completion multiplied by Schedule Percent Complete.
When an activity has assignments, the Planned Value Cost is calculated as Budget At Completion multiplied by (Data Date of Current Project - Baseline Assignment Start Date) divided by (Baseline Assignment Finish Date - Baseline Assignment Start Date). Each assignment is then summed to the activity-level planned value. This value is based on the project currency.
Nested Schema : remainingTotalCost
Type:
array
The remaining cost for all resource assignments and direct activity costs (expenses) on the activity. This field is in base currency and is calculated from remainingTotalCostProject field based on the specified exchange rate.
Show Source
Nested Schema : remainingTotalCostProject
Type:
array
The remaining cost for all resource assignments and direct activity costs on the activity. This value is based on the project currency.
Show Source
Nested Schema : spreadDates
Type:
array
The list of spread dates derived according to the timescale for all the spread items in the request.
Show Source
Nested Schema : ApiEntitySpreadOutputProject
Type:
object
Title:
Show Source
ApiEntitySpreadOutputProject
-
baselineId: integer
(int64)
The system-generated identifier of a baseline.
-
baselineName: string
Maximum Length:
255
Name for the baseline or snapshot. -
isBaseline: boolean
Indicates whether or not the spread calculation is for Earned Value baseline.
-
projectCode: string
Maximum Length:
60
The unique identifier for a project set by the user who created the project. -
projectId: integer
(int64)
The unique identifier for the project.
-
projectName: string
Maximum Length:
255
The name of the project.
Nested Schema : ApiEntitySpreadOutputAssignment
Type:
object
Title:
Show Source
ApiEntitySpreadOutputAssignment
-
activityCode: string
Maximum Length:
60
The user-specified identifier of the activity. -
activityId: integer
(int64)
The unique identifier for the activity.
-
activityName: string
Maximum Length:
255
The name of the activity. -
actualCost: number
(double)
The actual cost for the resource assignment on the activity. This field is in base currency and is calculated from actualCostProject field based on the specified exchange rate.
-
actualCostProject: number
(double)
The actual cost for the resource assignment on the activity. This value is based on the project currency.
-
actualUnits: integer
(int64)
The sum of the actual non-overtime and the overtime units worked by the resource on the activity.
-
assignmentCode: string
Maximum Length:
60
A unique identifier for the assignment. -
assignmentId: integer
(int64)
The system-generated identifier of an assignment.
-
atCompletionCost: number
(double)
The sum of the actual costs plus remaining costs for the resource assignment on the activity. This field is in base currency and is calculated from atCompletionCostProject field based on the specified exchange rate.
-
atCompletionCostProject: number
(double)
The sum of the actual costs plus remaining costs for the resource assignment on the activity. This value is based on the project currency.
-
atCompletionUnits: integer
(int64)
The sum of the actual units and remaining units for the resource assignment on the activity.
Calculated as Actual Units plus Remaining Units. -
plannedCost: number
(double)
The expected total cost of the item, such as an assignment, expense, or response plan. This field is in base currency and is calculated from plannedCostProject field based on the specified exchange rate.
-
plannedCostProject: number
(double)
The expected total cost of the item, such as an assignment, expense, or response plan. This value is based on the project currency.
-
plannedUnits: integer
(int64)
The planned units of work for the resource assignment on the activity.
-
rateSource: string
Allowed Values:
[ "RESOURCE", "ROLE", "OVERRIDE" ]
The value that indicates which Price/Unit will be used to calculate costs for the assignment. Valid options are Resource, Role, or Override. -
remainingCost: number
(double)
The remaining cost for the activity resource assignment. Calculated as Remaining Units multiplied by Cost/Time. This field is in base currency and is calculated from remainingCostProject field based on the specified exchange rate.
-
remainingCostProject: number
(double)
The remaining cost for the resource assignment on the activity. This value is based on the project currency.
-
remainingUnits: integer
(int64)
The remaining units of work to be performed by the resource on the activity.
-
resourceCode: string
Maximum Length:
60
The unique identifier for the resource or role. -
resourceId: integer
(int64)
The unique identifier for the resource or role.
-
resourceName: string
Maximum Length:
255
The name of the resource or role. -
roleCode: string
Maximum Length:
60
The unique identifier for the resource or role. -
roleId: integer
(int64)
The unique identifier for the resource or role.
-
roleName: string
Maximum Length:
255
The name of the resource or role. -
spread:
spread
The aggregate that contains the lists of spread dates and spread values for the assignment spread items in the request. The spread values and dates are correlated by the indices in the lists. This aggregate applicable when downloading the spread output for Calculate Assignment Spread jobs.
Nested Schema : spread
The aggregate that contains the lists of spread dates and spread values for the assignment spread items in the request. The spread values and dates are correlated by the indices in the lists. This aggregate applicable when downloading the spread output for Calculate Assignment Spread jobs.
Match All
Show Source
-
object
ApiEntitySpreadOutputAssignmentSpread
Title:
ApiEntitySpreadOutputAssignmentSpread
Nested Schema : ApiEntitySpreadOutputAssignmentSpread
Type:
object
Title:
Show Source
ApiEntitySpreadOutputAssignmentSpread
-
actualCost: array
actualCost
The actual cost for the resource assignment on the activity. This field is in base currency and is calculated from actualCostProject field based on the specified exchange rate.
-
actualCostProject: array
actualCostProject
The actual cost for the resource assignment on the activity. This value is based on the project currency.
-
actualUnits: array
actualUnits
The sum of the actual non-overtime and the overtime units worked by the resource on the activity.
-
atCompletionCost: array
atCompletionCost
The sum of the actual costs plus remaining costs for the resource assignment on the activity. This field is in base currency and is calculated from atCompletionCostProject field based on the specified exchange rate.
-
atCompletionCostProject: array
atCompletionCostProject
The sum of the actual costs plus remaining costs for the resource assignment on the activity. This value is based on the project currency.
-
atCompletionUnits: array
atCompletionUnits
The sum of the actual units and remaining units for the resource assignment on the activity.
Calculated as Actual Units plus Remaining Units. -
plannedCost: array
plannedCost
The expected total cost of the item, such as an assignment, expense, or response plan. This field is in base currency and is calculated from plannedCostProject field based on the specified exchange rate.
-
plannedCostProject: array
plannedCostProject
The expected total cost of the item, such as an assignment, expense, or response plan. This value is based on the project currency.
-
plannedUnits: array
plannedUnits
The planned units of work for the resource assignment on the activity.
-
remainingCost: array
remainingCost
The remaining cost for the activity resource assignment. Calculated as Remaining Units multiplied by Cost/Time. This field is in base currency and is calculated from remainingCostProject field based on the specified exchange rate.
-
remainingCostProject: array
remainingCostProject
The remaining cost for the resource assignment on the activity. This value is based on the project currency.
-
remainingUnits: array
remainingUnits
The remaining units of work to be performed by the resource on the activity.
-
spreadDates: array
spreadDates
The list of spread dates derived according to the timescale for all the spread items in the request.
Nested Schema : actualCost
Type:
array
The actual cost for the resource assignment on the activity. This field is in base currency and is calculated from actualCostProject field based on the specified exchange rate.
Show Source
Nested Schema : actualCostProject
Type:
array
The actual cost for the resource assignment on the activity. This value is based on the project currency.
Show Source
Nested Schema : actualUnits
Type:
array
The sum of the actual non-overtime and the overtime units worked by the resource on the activity.
Show Source
Nested Schema : atCompletionCost
Type:
array
The sum of the actual costs plus remaining costs for the resource assignment on the activity. This field is in base currency and is calculated from atCompletionCostProject field based on the specified exchange rate.
Show Source
Nested Schema : atCompletionCostProject
Type:
array
The sum of the actual costs plus remaining costs for the resource assignment on the activity. This value is based on the project currency.
Show Source
Nested Schema : atCompletionUnits
Type:
array
The sum of the actual units and remaining units for the resource assignment on the activity.
Calculated as Actual Units plus Remaining Units.
Show Source
Calculated as Actual Units plus Remaining Units.
Nested Schema : plannedCost
Type:
array
The expected total cost of the item, such as an assignment, expense, or response plan. This field is in base currency and is calculated from plannedCostProject field based on the specified exchange rate.
Show Source
Nested Schema : plannedCostProject
Type:
array
The expected total cost of the item, such as an assignment, expense, or response plan. This value is based on the project currency.
Show Source
Nested Schema : plannedUnits
Type:
array
The planned units of work for the resource assignment on the activity.
Show Source
Nested Schema : remainingCost
Type:
array
The remaining cost for the activity resource assignment. Calculated as Remaining Units multiplied by Cost/Time. This field is in base currency and is calculated from remainingCostProject field based on the specified exchange rate.
Show Source
Nested Schema : remainingCostProject
Type:
array
The remaining cost for the resource assignment on the activity. This value is based on the project currency.
Show Source
Nested Schema : remainingUnits
Type:
array
The remaining units of work to be performed by the resource on the activity.
Show Source
Nested Schema : spreadDates
Type:
array
The list of spread dates derived according to the timescale for all the spread items in the request.
Show Source
400 Response
Invalid input for the Action service.