Search only in titles

---

Get Spread File

GET /ws/rest/service/v2/activity/sheets/spread/download?jobId={jobId}

Purpose

Gets the spread file downloaded after completion of spread job for Activity and Assignment Spread API.

Request Format

Send a GET request in the format specified above.

Request Parameters

The following parameter must be specified in the request:

Request Parameter	Required?	Data Type	Description
jobId	Yes	Integer	This parameter is a background job reference ID of Unifier Essentials. Request raised with activity spread download is considered as a background job and a jobId is returned in the response after the background job is initiated. The same jobId is used for downloading the spread in the get API.

Response Format

A zip file containing the activity spread in JSON format for the current project or baseline project can be downloaded.

Sample Success Request

{hosturl}/ws/rest/service/v2/activity/sheets/spread/download?jobId=121820230812

Sample Success Response File for Activity Spread for Current Project

A successful response with status code 200 displays in the following format:

{

"activities": [

{

"activityCode": "A1000",

"activityId": 502202,

"activityName": "act1",

"spread": {

"actualTotalCost": [0, 0, 0, 0, 0, 0, 0],

"atCompletionTotalCost": [0, 0, 0, 0, 0, 0, 0],

"earnedValueCost": [0, 0, 0, 0, 0, 0, 0],

"estimateAtCompletionCost": [0, 0, 0, 0, 0, 0, 0],

"estimateToCompleteCost": [0, 0, 0, 0, 0, 0, 0],

"estimateToCompleteCostProject": [ 0, 0, 0, 0, 0, 0, 0],

"estimateToCompleteLaborUnits": [8, 8, 8, 8, 0, 0, 8],

"plannedTotalCost": [0, 0, 0, 0, 0, 0, 0],

"plannedValueCost": [0, 0, 0, 0, 0, 0, 0],

"remainingTotalCost": [0, 0, 0, 0, 0, 0, 0],

"spreadDates": ["2023-05-02T00:00:00", "2023-05-03T00:00:00", "2023-05-04T00:00:00", "2023-05-05T00:00:00", "2023-05-06T00:00:00",

"2023-05-07T00:00:00", "2023-05-08T00:00:00"] },

"wbsId": 298601

}

],

"project": {

"projectCode": "testSpread",

"projectId": 258401,

"projectName": "testSpread"

},

"timescale": "DAILY"

}

Sample Success Response File for Activity Spread for Baseline Project

This is an example of a JSON file returned with the activity spread data for a baseline project:

{

"activities": [

{

"activityCode": "A1000",

"activityId": 258003,

"activityName": "Act1",

"spread": {

"actualTotalCost": [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,

0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],

"atCompletionTotalCost": [ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240 ],

"plannedTotalCost": [ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240],

"remainingTotalCost": [ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240],

"spreadDates": ["2023-01-02T00:00:00", "2023-01-03T00:00:00", "2023-01-04T00:00:00", "2023-01-05T00:00:00", "2023-01-06T00:00:00", "2023-01-07T00:00:00", "2023-01-08T00:00:00", "2023-01-09T00:00:00", "2023-01-10T00:00:00", "2023-01-11T00:00:00", "2023-01-12T00:00:00", "2023-01-13T00:00:00", "2023-01-14T00:00:00", "2023-01-15T00:00:00", "2023-01-16T00:00:00", "2023-01-17T00:00:00", "2023-01-18T00:00:00", "2023-01-19T00:00:00", "2023-01-20T00:00:00", "2023-01-21T00:00:00", "2023-01-22T00:00:00", "2023-01-23T00:00:00", "2023-01-24T00:00:00", "2023-01-25T00:00:00", "2023-01-26T00:00:00", "2023-01-27T00:00:00", "2023-01-28T00:00:00", "2023-01-29T00:00:00", "2023-01-30T00:00:00", "2023-01-31T00:00:00", "2023-02-01T00:00:00", "2023-02-02T00:00:00", "2023-02-03T00:00:00", "2023-02-04T00:00:00", "2023-02-05T00:00:00", "2023-02-06T00:00:00", "2023-02-07T00:00:00", "2023-02-08T00:00:00", "2023-02-09T00:00:00", "2023-02-10T00:00:00", "2023-02-11T00:00:00", "2023-02-12T00:00:00", "2023-02-13T00:00:00", "2023-02-14T00:00:00", "2023-02-15T00:00:00", "2023-02-16T00:00:00", "2023-02-17T00:00:00", "2023-02-18T00:00:00", "2023-02-19T00:00:00", "2023-02-20T00:00:00", "2023-02-21T00:00:00", "2023-02-22T00:00:00", "2023-02-23T00:00:00", "2023-02-24T00:00:00", "2023-02-25T00:00:00", "2023-02-26T00:00:00", "2023-02-27T00:00:00", "2023-02-28T00:00:00", "2023-03-01T00:00:00", "2023-03-02T00:00:00", "2023-03-03T00:00:00", "2023-03-04T00:00:00", "2023-03-05T00:00:00", "2023-03-06T00:00:00", "2023-03-07T00:00:00", "2023-03-08T00:00:00", "2023-03-09T00:00:00", "2023-03-10T00:00:00", "2023-03-11T00:00:00", "2023-03-12T00:00:00", "2023-03-13T00:00:00", "2023-03-14T00:00:00", "2023-03-15T00:00:00", "2023-03-16T00:00:00", "2023-03-17T00:00:00", "2023-03-18T00:00:00", "2023-03-19T00:00:00", "2023-03-20T00:00:00", "2023-03-21T00:00:00", "2023-03-22T00:00:00", "2023-03-23T00:00:00", "2023-03-24T00:00:00", "2023-03-25T00:00:00", "2023-03-26T00:00:00", "2023-03-27T00:00:00", "2023-03-28T00:00:00", "2023-03-29T00:00:00", "2023-03-30T00:00:00", "2023-03-31T00:00:00", "2023-04-01T00:00:00", "2023-04-02T00:00:00", "2023-04-03T00:00:00", "2023-04-04T00:00:00", "2023-04-05T00:00:00", "2023-04-06T00:00:00", "2023-04-07T00:00:00", "2023-04-08T00:00:00", "2023-04-09T00:00:00", "2023-04-10T00:00:00", "2023-04-11T00:00:00", "2023-04-12T00:00:00", "2023-04-13T00:00:00", "2023-04-14T00:00:00", "2023-04-15T00:00:00", "2023-04-16T00:00:00", "2023-04-17T00:00:00", "2023-04-18T00:00:00", "2023-04-19T00:00:00", "2023-04-20T00:00:00", "2023-04-21T00:00:00", "2023-04-22T00:00:00", "2023-04-23T00:00:00", "2023-04-24T00:00:00", "2023-04-25T00:00:00", "2023-04-26T00:00:00", "2023-04-27T00:00:00", "2023-04-28T00:00:00"]

},

"wbsId": 334101

}

],

"project": {

"baselineId": 186201,

"baselineName": "ACTSR2",

"isBaseline": true,

"projectCode": "ACTSR2",

"projectId": 326301,

"projectName": "ACTSR2"

},

"timescale": "DAILY"

}

Sample Failed Response

A failed response is returned with a status code in the following format:

{

"data": [],

"message": [

"The API request contains invalid characters in: [source_project_id]. The following characters are not allowed : / \\ : * ? \" < > | ' ="

],

"status": 12204,

"rest_audit_id": 4633

}

Sample Success Response - JSON data with Current and Baseline Project

This is an example of JSON file containing the spread data for current and baseline project:

{

"project":

{

"projectCode":"P-0115",

"projectName":"23.11_Shell",

"projectId":1252

},

"timescale":"DAILY",

"resourceAssignments": [

{

"activityCode":"A1010",

"activityId":1483094,

"resourceId":38095,

"resourceCode":"Ravi",

"activityName":"Act02",

"resourceName":"Ravi Sharma",

"rateSource":"RESOURCE",

"spread":{

"plannedCost":[ 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000],

"actualUnits":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"atCompletionCost":[ 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000],

"remainingCost":[ 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000, 12000, 0, 0, 12000, 12000, 12000, 12000],

"plannedUnits":[ 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80],

"spreadDates":[ "2024-01-22T00:00:00", "2024-01-23T00:00:00", "2024-01-24T00:00:00", "2024-01-25T00:00:00", "2024-01-26T00:00:00", "2024-01-27T00:00:00", "2024-01-28T00:00:00", "2024-01-29T00:00:00", "2024-01-30T00:00:00", "2024-01-31T00:00:00", "2024-02-01T00:00:00", "2024-02-02T00:00:00", "2024-02-03T00:00:00", "2024-02-04T00:00:00", "2024-02-05T00:00:00", "2024-02-06T00:00:00", "2024-02-07T00:00:00", "2024-02-08T00:00:00", "2024-02-09T00:00:00", "2024-02-10T00:00:00", "2024-02-11T00:00:00", "2024-02-12T00:00:00", "2024-02-13T00:00:00", "2024-02-14T00:00:00", "2024-02-15T00:00:00", "2024-02-16T00:00:00", "2024-02-17T00:00:00", "2024-02-18T00:00:00", "2024-02-19T00:00:00", "2024-02-20T00:00:00", "2024-02-21T00:00:00", "2024-02-22T00:00:00" ],

"atCompletionUnits":[ 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80 ],

"remainingUnits":[ 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80],

"actualCost":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]

}

},

{

"activityCode":"A1010",

"activityId":1483094,

"resourceId":38097,

"resourceCode":"Ravi12",

"activityName":"Act02",

"resourceName":"Ravi2",

"rateSource":"RESOURCE",

"spread":{

"plannedCost":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"actualUnits":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"atCompletionCost":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"remainingCost":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"plannedUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"spreadDates":[ "2024-01-22T00:00:00", "2024-01-23T00:00:00", "2024-01-24T00:00:00", "2024-01-25T00:00:00", "2024-01-26T00:00:00", "2024-01-27T00:00:00", "2024-01-28T00:00:00", "2024-01-29T00:00:00", "2024-01-30T00:00:00", "2024-01-31T00:00:00", "2024-02-01T00:00:00", "2024-02-02T00:00:00", "2024-02-03T00:00:00", "2024-02-04T00:00:00", "2024-02-05T00:00:00", "2024-02-06T00:00:00", "2024-02-07T00:00:00", "2024-02-08T00:00:00", "2024-02-09T00:00:00", "2024-02-10T00:00:00", "2024-02-11T00:00:00", "2024-02-12T00:00:00", "2024-02-13T00:00:00", "2024-02-14T00:00:00", "2024-02-15T00:00:00", "2024-02-16T00:00:00", "2024-02-17T00:00:00", "2024-02-18T00:00:00", "2024-02-19T00:00:00", "2024-02-20T00:00:00", "2024-02-21T00:00:00", "2024-02-22T00:00:00"],

"atCompletionUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"remainingUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"actualCost": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]

}

},

{

"activityCode":"A1000",

"activityId":1483093,

"resourceId":38118,

"resourceCode":"Ranand",

"activityName":"Act01",

"resourceName":"Rahul Anand",

"rateSource":"RESOURCE",

"spread":{

"plannedCost":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"actualUnits":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"atCompletionCost": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"remainingCost": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"plannedUnits":[ 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80],

"spreadDates":[ "2024-01-22T00:00:00", "2024-01-23T00:00:00", "2024-01-24T00:00:00", "2024-01-25T00:00:00", "2024-01-26T00:00:00", "2024-01-27T00:00:00", "2024-01-28T00:00:00", "2024-01-29T00:00:00", "2024-01-30T00:00:00", "2024-01-31T00:00:00", "2024-02-01T00:00:00", "2024-02-02T00:00:00", "2024-02-03T00:00:00", "2024-02-04T00:00:00", "2024-02-05T00:00:00", "2024-02-06T00:00:00", "2024-02-07T00:00:00", "2024-02-08T00:00:00", "2024-02-09T00:00:00", "2024-02-10T00:00:00", "2024-02-11T00:00:00", "2024-02-12T00:00:00", "2024-02-13T00:00:00", "2024-02-14T00:00:00", "2024-02-15T00:00:00", "2024-02-16T00:00:00", "2024-02-17T00:00:00", "2024-02-18T00:00:00", "2024-02-19T00:00:00", "2024-02-20T00:00:00", "2024-02-21T00:00:00", "2024-02-22T00:00:00", "2024-02-23T00:00:00", "2024-02-24T00:00:00", "2024-02-25T00:00:00", "2024-02-26T00:00:00", "2024-02-27T00:00:00", "2024-02-28T00:00:00", "2024-02-29T00:00:00", "2024-03-01T00:00:00", "2024-03-02T00:00:00", "2024-03-03T00:00:00", "2024-03-04T00:00:00", "2024-03-05T00:00:00", "2024-03-06T00:00:00", "2024-03-07T00:00:00", "2024-03-08T00:00:00", "2024-03-09T00:00:00", "2024-03-10T00:00:00", "2024-03-11T00:00:00", "2024-03-12T00:00:00", "2024-03-13T00:00:00", "2024-03-14T00:00:00", "2024-03-15T00:00:00", "2024-03-16T00:00:00", "2024-03-17T00:00:00", "2024-03-18T00:00:00", "2024-03-19T00:00:00", "2024-03-20T00:00:00", "2024-03-21T00:00:00", "2024-03-22T00:00:00", "2024-03-23T00:00:00", "2024-03-24T00:00:00", "2024-03-25T00:00:00", "2024-03-26T00:00:00", "2024-03-27T00:00:00", "2024-03-28T00:00:00"],

"atCompletionUnits":[ 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80],

"remainingUnits":[ 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80, 80, 0, 0, 80, 80, 80, 80],

"actualCost":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]

}

},

{

"activityCode":"A1010",

"activityId":1483094,

"roleId":131075,

"roleCode":"RoleCode7399",

"activityName":"Act02",

"roleName":"RoleName7399",

"rateSource":"ROLE",

"spread":{

"plannedCost":[ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240 ],

"actualUnits":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"atCompletionCost":[ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240],

"remainingCost":[ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240],

"plannedUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"spreadDates":[ "2024-01-22T00:00:00", "2024-01-23T00:00:00", "2024-01-24T00:00:00", "2024-01-25T00:00:00", "2024-01-26T00:00:00", "2024-01-27T00:00:00", "2024-01-28T00:00:00", "2024-01-29T00:00:00", "2024-01-30T00:00:00", "2024-01-31T00:00:00", "2024-02-01T00:00:00", "2024-02-02T00:00:00", "2024-02-03T00:00:00", "2024-02-04T00:00:00", "2024-02-05T00:00:00", "2024-02-06T00:00:00", "2024-02-07T00:00:00", "2024-02-08T00:00:00", "2024-02-09T00:00:00", "2024-02-10T00:00:00", "2024-02-11T00:00:00", "2024-02-12T00:00:00", "2024-02-13T00:00:00", "2024-02-14T00:00:00", "2024-02-15T00:00:00", "2024-02-16T00:00:00", "2024-02-17T00:00:00", "2024-02-18T00:00:00", "2024-02-19T00:00:00", "2024-02-20T00:00:00", "2024-02-21T00:00:00", "2024-02-22T00:00:00"],

"atCompletionUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"remainingUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"actualCost":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]

}

},

{

"activityCode":"A1000",

"activityId":1483093,

"roleId":131072,

"roleCode":"RoleCode7396",

"activityName":"Act01",

"roleName":"RoleName7396",

"rateSource":"ROLE",

"spread":{

"plannedCost":[ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240],

"actualUnits":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0],

"atCompletionCost":[ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240],

"remainingCost":[ 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240, 240, 0, 0, 240, 240, 240, 240],

"plannedUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"spreadDates":[ "2024-01-22T00:00:00", "2024-01-23T00:00:00", "2024-01-24T00:00:00", "2024-01-25T00:00:00", "2024-01-26T00:00:00", "2024-01-27T00:00:00", "2024-01-28T00:00:00", "2024-01-29T00:00:00", "2024-01-30T00:00:00", "2024-01-31T00:00:00", "2024-02-01T00:00:00", "2024-02-02T00:00:00", "2024-02-03T00:00:00", "2024-02-04T00:00:00", "2024-02-05T00:00:00", "2024-02-06T00:00:00", "2024-02-07T00:00:00", "2024-02-08T00:00:00", "2024-02-09T00:00:00", "2024-02-10T00:00:00", "2024-02-11T00:00:00", "2024-02-12T00:00:00", "2024-02-13T00:00:00", "2024-02-14T00:00:00", "2024-02-15T00:00:00", "2024-02-16T00:00:00", "2024-02-17T00:00:00", "2024-02-18T00:00:00", "2024-02-19T00:00:00", "2024-02-20T00:00:00", "2024-02-21T00:00:00", "2024-02-22T00:00:00", "2024-02-23T00:00:00", "2024-02-24T00:00:00", "2024-02-25T00:00:00", "2024-02-26T00:00:00", "2024-02-27T00:00:00", "2024-02-28T00:00:00", "2024-02-29T00:00:00", "2024-03-01T00:00:00", "2024-03-02T00:00:00", "2024-03-03T00:00:00", "2024-03-04T00:00:00", "2024-03-05T00:00:00", "2024-03-06T00:00:00", "2024-03-07T00:00:00", "2024-03-08T00:00:00", "2024-03-09T00:00:00", "2024-03-10T00:00:00", "2024-03-11T00:00:00", "2024-03-12T00:00:00", "2024-03-13T00:00:00", "2024-03-14T00:00:00", "2024-03-15T00:00:00", "2024-03-16T00:00:00", "2024-03-17T00:00:00", "2024-03-18T00:00:00", "2024-03-19T00:00:00", "2024-03-20T00:00:00", "2024-03-21T00:00:00", "2024-03-22T00:00:00", "2024-03-23T00:00:00", "2024-03-24T00:00:00", "2024-03-25T00:00:00", "2024-03-26T00:00:00", "2024-03-27T00:00:00", "2024-03-28T00:00:00" ],

"atCompletionUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"remainingUnits":[ 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8],

"actualCost":[ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]

}

}

]

}

Sample Failed Request

A request is sent with an invalid job ID as follows:

URL : {hosturl}/ws/rest/service/v2/activity/sheets/spread/download?jobId=activity_Spread_

Sample Failed Response

A failed response is returned with a status code in the following format:

{

"data": [],

"message": ["The API request contains invalid value for: [jobId]. Allowed only integer values."],

"rest_audit_id": 23433,

"status": 12511

}

Supported Validation Messages and Status Codes

The following validation messages and status codes display in the response when incorrect values are provided in the request:

Field Name	Use-case Scenario	Status Code	Error Message
jobId	jobId is not specified in the request.	12502	The API request is missing the required information: [jobId].
jobId	jobId value is empty.	12512	The API request contains empty value for: [jobId]. Allowed only integer values.
jobId	jobId data type is invalid.	12511	The API request contains invalid value for: [jobId]. Allowed only integer values.
jobId	jobId is not configured in the source Unifier shell.	12520	Job details are not present in Unifier. [jobId] : {jobId}

Related Topics

Activities and Assignments

Create, Update, and Remove Assignments

Get Assignments

Create or Update Assignment Spreads

Get Assignment Spread

Get Activity Spread

Get Spread Job Status

Create or Update Activity Spreads

Create Manual Activity Sheet

Create or Update Baseline Schedule for Manual Activity Sheet

Get Activities in the Manual Activity Sheet of a Specific Shell

Schedule Project for Manual Activity Sheet

Recost Project for Manual Activity Sheet

Create Activity Dependency

---

Last Published Tuesday, April 15, 2025