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. 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}