Create or Update Activity Spreads

POST /ws/rest/service/v2/activity/sheets/activities/spread

Purpose:

Create or update Activity Spreads in a specific shell from the source system.

Permissions:

The user must have Create permissions enabled. Selecting or clearing Update permissions has no impact on a user’s ability to utilize this REST Service.

Prerequisites:

The Project Shell should already be created.
The System Activity Sheet should already be available in the Project Shell.
The SourceProjectID should be configured in the System Activity Sheet.
The user should have token for accessing the API.

This REST Service is specific to updating externally synced Assignment Spread data from other applications. Therefore, sourceProjectID should be configured or added in the user interface tab Shell Details → Primavera Cloud Integration.

Note: Validations are not implemented for System Activity Sheet data in any API assuming the data from the source system is sent properly.

CurrentActivitySpread JSON Sample:

{

"activities": [

{

"activityCode": "A1000",

"activityId": 502202,

"activityName": "act1",

"actualTotalCost": 0,

"actualTotalCostProject": 0,

"atCompletionTotalCost": 0,

"atCompletionTotalCostProject": 0,

"earnedValueCost": 0,

"earnedValueCostProject": 0,

"estimateAtCompletionCost": 0,

"estimateAtCompletionCostProject": 0,

"estimateToCompleteCost": 0,

"estimateToCompleteCostProject": 0,

"estimateToCompleteLaborUnits": 40,

"plannedTotalCost": 0,

"plannedTotalCostProject": 0,

"plannedValueCost": 0,

"plannedValueCostProject": 0,

"remainingTotalCost": 0,

"remainingTotalCostProject": 0,

"spread": {

"actualTotalCost": [

0,

0

],

"actualTotalCostProject": [

0,

0

],

"atCompletionTotalCost": [

0,

0

],

"atCompletionTotalCostProject": [

0,

0

],

"earnedValueCost": [

0,

0

],

"earnedValueCostProject": [

0,

0

],

"estimateAtCompletionCost": [

0,

0

],

"estimateAtCompletionCostProject": [

0,

0

],

"estimateToCompleteCost": [

0,

0

],

"estimateToCompleteCostProject": [

0,

0

],

"estimateToCompleteLaborUnits": [

8,

0,

8

],

"plannedTotalCost": [

0,

0

],

"plannedTotalCostProject": [

0,

0

],

"plannedValueCost": [

0,

0

],

"plannedValueCostProject": [

0,

0

],

"remainingTotalCost": [

0,

0

],

"remainingTotalCostProject": [

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 Request (Success Scenario):

{hosturl}ws/rest/service/v2/activity/sheets/activities/spread

Inputs in Raw JSON-data:

{

"options": {

"project_number": "P-0056",

"sourceProjectId": "P-0056",

"source": "Primavera Cloud",

"projectType": "Current"

},

"_attachment": {

"zipped_file_name": "557118_activitySpreads.zip",

"zipped_file_size": 812,

"zipped_file_content": "UEsDBBQAAAAIABxu3FYgih2MigIAADgqAAAOAAAAb3Bjc3ByZWFkLmpzb27tV8tq4zAU3QfyD8ZrF+RHEqe7kG4KZRiYzMBQZqEmYvDg2MFW

p5SSf6/iR/1QIl0lLVZAIZAc32Pp+Fi+1nkbjyzLxmsa/Y9oRHL71npkh9jnrfxpqq/LdENY3V64ru1w1fsNq7lBEKBgxle/4W15bu/UZxyvUorjZZpTVkcni9+z9B9Z9zl0mW53

MaFRmtRMCOXoYARnCdn8wvEzYZzTxdMD5DTaYkoWrSkZGcgSDrlKK/JhdhAHONwDfkqzn0lED3c+aFF3MU7YFfOu8tVmNp7UNo2vSi3NyBZHSZT8rWeS1o8Ok+8ygtn6bBY1v8Cqlf/x

CZ0vQA34UxREa72viF3QF6C+IsFjwwmaO6eRi7rQ7UJPCH0VVRq4xbeOx871TBwRnHbhTAjDLpzDFOng0ZG+p4tZ0pY8uGud5q6hIi2tal5un9Xce0pAzb3/riy1DLneK0U6ddDWbmDwFX7

Qolnz7O5zhmublgWUp4Fn5abvjnUE7vG3PeT5N2hyg7wVQrfF13aOM3wpI5AyJlLGVMqYSRlhw2hZUv/dN9vhl6e8SGvePJwilx0uytLY53ni2BcKYp9nYh81se8KYp9C34Gj8eiC2AffnSig

8QgesAa16DoTn8IEcASTooM5wKinMBMcKWrSyC6T8c4QdhUZT+XK4QioRYPbZtLdhelOYQ44AqvRwCIT5kBhzgOHOd8Xh7m5IMz5JsxRE+ZMmDsjzCnMA0fjETw7aSdIA6NMmANsuU2YU5JmwtwZ

wkyYs0yYu0SLBvaYMCcVZcIcKMz5VZhjP5V/9q68efUuuDlS5zpmKf1R7pSdLqMcdxIGyO1VWK7rn3sg7MspWY8m+RrHBeVucf/wm1X371BLAQI/ABQAAAAIABxu3FYgih2MigIAADgqAAAOACQAA

AAAAAAAIAAAAAAAAABvcGNzcHJlYWQuanNvbgoAIAAAAAAAAQAYAJmTLy6ZqdkBAAAAAAAAAAAAAAAAAAAAAFBLBQYAAAAAAQABAGAAAAC2AgAAAAA="

}

Sample Response (Success Scenario):

{

"data": {

"jobId": 1688383768969

},

"message": [

"Job for spread data created successfully."

],

"status": 202,

"rest_audit_id": 12676

}

Sample Request (Failed Scenario):

{hosturl}/ws/rest/service/v2/activity/sheets/activities/spread

Inputs in Raw JSON-data:

{

"options": {

"project_number": "P-0056",

"sourceProjectId": "P-0056",

"source": "Primavera Cloud",

"projectType": ""

},

"_attachment": {

"zipped_file_name": "557118_activitySpreads.zip",

"zipped_file_size": 812,

"zipped_file_content": "UEsDBBQAAAAIABxu3FYgih2MigIAADgqAAAOAAAAb3Bjc3ByZWFkLmpzb27tV8tq4zAU3QfyD8ZrF+RHEqe7kG4KZRiYzMBQZqEmYvDg2MFWp5SSf6/iR/1QIl0lLVZAIZAc32Pp+Fi+1nkbjyzLxmsa/Y9oRHL71npkh9jnrfxpqq/LdENY3V64ru1w1fsNq7lBEKBgxle/4W15bu/UZxyvUorjZZpTVkcni9+z9B9Z9zl0mW53MaFRmtRMCOXoYARnCdn8wvEzYZzTxdMD5DTaYkoWrSkZGcgSDrlKK/JhdhAHONwDfkqzn0lED3c+aFF3MU7YFfOu8tVmNp7UNo2vSi3NyBZHSZT8rWeS1o8Ok+8ygtn6bBY1v8Cqlf/xCZ0vQA34UxREa72viF3QF6C+IsFjwwmaO6eRi7rQ7UJPCH0VVRq4xbeOx871TBwRnHbhTAjDLpzDFOng0ZG+p4tZ0pY8uGud5q6hIi2tal5un9Xce0pAzb3/riy1DLneK0U6ddDWbmDwFX7Qolnz7O5zhmublgWUp4Fn5abvjnUE7vG3PeT5N2hyg7wVQrfF13aOM3wpI5AyJlLGVMqYSRlhw2hZUv/dN9vhl6e8SGvePJwilx0uytLY53ni2BcKYp9nYh81se8KYp9C34Gj8eiC2AffnSig8QgesAa16DoTn8IEcASTooM5wKinMBMcKWrSyC6T8c4QdhUZT+XK4QioRYPbZtLdhelOYQ44AqvRwCIT5kBhzgOHOd8Xh7m5IMz5JsxRE+ZMmDsjzCnMA0fjETw7aSdIA6NMmANsuU2YU5JmwtwZwkyYs0yYu0SLBvaYMCcVZcIcKMz5VZhjP5V/9q68efUuuDlS5zpmKf1R7pSdLqMcdxIGyO1VWK7rn3sg7MspWY8m+RrHBeVucf/wm1X371BLAQI/ABQAAAAIABxu3FYgih2MigIAADgqAAAOACQAAAAAAAAAIAAAAAAAAABvcGNzcHJlYWQuanNvbgoAIAAAAAAAAQAYAJmTLy6ZqdkBAAAAAAAAAAAAAAAAAAAAAFBLBQYAAAAAAQABAGAAAAC2AgAAAAA="

}

Sample Response (Failed Scenario):

{

"data": [],

"message": [

{

"message": "The API request contains empty value for: [projectType].",

"status": 12144

}

],

"status": 3000,

"rest_audit_id": 14302

}

Response Format:

JSON Map {

"status" : <integer value> ,

"data" : [ ] ,

"messages": [ <list of string>] ,

"rest_audit_id": <id from the rest audit table matching this request>

}

Related Topics