Get Activities from the System Activity Sheet of a Specific Shell
GET /ws/rest/service/v2/activity/sheet/activities?project_number={project number}&source_project_id={integrated source project id}
Purpose
Retrieves a list of activities from the System Activity Sheet of a shell based on the project number and source project ID mentioned in the query parameters.
Request Parameters
The following parameters can be included in the request.
Field Name | Data Type | Description |
|---|---|---|
project_number | String | A valid 'Active' Unifier shell number (shell number into which the system is going to update project details). For example, "P-0001." |
source_project_id | String | The Primavera Cloud project code. For example, "Msk-P1." |
Supported Validation Messages and Status Codes
The following messages and status codes can display in the response:
Use-Case | Status | Message |
|---|---|---|
project_number not given or blank | 620 | Missing Project Number. |
Invalid project_number | 602 | Project/Shell Number is not correct. |
Inactive/On Hold project_number | 12020 | The API request contains an invalid value: [project_number]. Please check the status of this project_number in Unifier. |
If this source_project_id is not configured in the source Unifier shell | 12205 | The API request contains an invalid value: [source_project_id]. Please check if this source_project_id has been configured in Unifier. |
Invalid Special characters source_project_id | 12204 | The API request contains an special characters: [source_project_id]. Please check if this source_project_id should not contain characters: / \\ : * ? \" < > | ' = |
Blank source_project_id | 12201 | The API request is missing the required information: [source_project_id]. |
Length of source_project_id | 12202 | Invalid value was found in a field: 'source_project_id'. Allowed length: [250]. |
Response Format
A JSON object is returned in the following format.
{
"status" : <integer value> ,
"data" : [ ] ,
"messages": [ <list of string>] ,
"rest_audit_id": <id from the rest audit table matching this request>
}
If the project number and the source project ID is correct, a success response is displayed.
A failed response returns a message with no data.
Sample Success Response
{
"data": [
{
"uuu_P6ActualTotalUnits": 0.0,
"uuu_P6EACCost": 0.0,
"uuu_P6ScheduleVariance": 0.0,
"uuu_P6ActualStart": null,
"uuu_P6AtCompletionTotalUnits": 1827.0,
"uuu_P6ActualDuration": 0.0,
"uuu_P6Finish": "2037-08-05T16:00:00",
"uuu_P6WBSName": "New WBS-1",
"uuu_P6WBSPath": "Msk-P1.1.11",
"uuu_P6CostVariance": 0.0,
"uuu_P6BAC": 1461600.0,
"uuu_P6RemainingEarlyFinish": "2037-08-05T16:00:00",
"uuu_P6PlannedFinish": "2037-08-05T16:00:00",
"id": 1482360,
"uuu_P6EVCost": 0.0,
"uuu_P6ActivityName": "Act1",
"uuu_P6PlannedTotalCost": 1461600.0,
"uuu_P6ActivityType": "Task Dependent",
"uuu_P6ActualFinish": null,
"uuu_P6ETC": 1461600.0,
"uuu_P6RemainingEarlyStart": "2030-08-06T08:00:00",
"uuu_P6RemainingTotalUnits": 1827.0,
"uuu_P6ActivityId": "A1000",
"uuu_P6AtCompletionDuration": 1827.0,
"uuu_P6PercentComplete": 0.0,
"uuu_P6CPIndex": 0.0,
"uuu_P6WBSCode": "wbs-1",
"uuu_P6VAC": 0.0,
"uuu_P6PerfPercComplete": 0.0,
"uuu_P6RemainingTotalCost": 1461600.0,
"uuu_P6ActivityStatus": "Not Started",
"uuu_P6PlannedDuration": 1827.0,
"uuu_P6ActualTotalCost": 0.0,
"uuu_P6AtCompletionTotalCost": 1461600.0,
"uuu_P6PVCost": 0.0,
"uuu_P6SPIndex": 0.0,
"uuu_P6PlannedStart": "2030-08-06T08:00:00",
"uuu_P6PlannedTotalUnits": 1827.0,
"uuu_P6Start": "2030-08-06T08:00:00",
"uuu_P6RemainingDuration": 1827.0
},
{
"uuu_P6ActualTotalUnits": 0.0,
"uuu_P6EACCost": 0.0,
"uuu_P6ScheduleVariance": 0.0,
"uuu_P6ActualStart": null,
"uuu_P6AtCompletionTotalUnits": 1827.0,
"uuu_P6ActualDuration": 0.0,
"uuu_P6Finish": "2037-08-05T16:00:00",
"uuu_P6WBSName": "New WBS-1",
"uuu_P6WBSPath": "Msk-P1.1.11",
"uuu_P6CostVariance": 0.0,
"uuu_P6BAC": 1461600.0,
"uuu_P6RemainingEarlyFinish": "2037-08-05T16:00:00",
"uuu_P6PlannedFinish": "2037-08-05T16:00:00",
"id": 1482361,
"uuu_P6EVCost": 0.0,
"uuu_P6ActivityName": "Act2",
"uuu_P6PlannedTotalCost": 1461600.0,
"uuu_P6ActivityType": "Task Dependent",
"uuu_P6ActualFinish": null,
"uuu_P6ETC": 1461600.0,
"uuu_P6RemainingEarlyStart": "2030-08-06T08:00:00",
"uuu_P6RemainingTotalUnits": 1827.0,
"uuu_P6ActivityId": "A1001",
"uuu_P6AtCompletionDuration": 1827.0,
"uuu_P6PercentComplete": 0.0,
"uuu_P6CPIndex": 0.0,
"uuu_P6WBSCode": "wbs-1",
"uuu_P6VAC": 0.0,
"uuu_P6PerfPercComplete": 0.0,
"uuu_P6RemainingTotalCost": 1461600.0,
"uuu_P6ActivityStatus": "Not Started",
"uuu_P6PlannedDuration": 1827.0,
"uuu_P6ActualTotalCost": 0.0,
"uuu_P6AtCompletionTotalCost": 1461600.0,
"uuu_P6PVCost": 0.0,
"uuu_P6SPIndex": 0.0,
"uuu_P6PlannedStart": "2030-08-06T08:00:00",
"uuu_P6PlannedTotalUnits": 1827.0,
"uuu_P6Start": "2030-08-06T08:00:00",
"uuu_P6RemainingDuration": 1827.0
},
{
"uuu_P6ActualTotalUnits": 0.0,
"uuu_P6EACCost": 0.0,
"uuu_P6ScheduleVariance": 0.0,
"uuu_P6ActualStart": null,
"uuu_P6AtCompletionTotalUnits": 1827.0,
"uuu_P6ActualDuration": 0.0,
"uuu_P6Finish": "2037-08-05T16:00:00",
"uuu_P6WBSName": "New WBS-1",
"uuu_P6WBSPath": "Msk-P1.1.11",
"uuu_P6CostVariance": 0.0,
"uuu_P6BAC": 1461600.0,
"uuu_P6RemainingEarlyFinish": "2037-08-05T16:00:00",
"uuu_P6PlannedFinish": "2037-08-05T16:00:00",
"id": 1482359,
"uuu_P6EVCost": 0.0,
"uuu_P6ActivityName": "Act1",
"uuu_P6PlannedTotalCost": 1461600.0,
"uuu_P6ActivityType": "Task Dependent",
"uuu_P6ActualFinish": null,
"uuu_P6ETC": 1461600.0,
"uuu_P6RemainingEarlyStart": "2030-08-06T08:00:00",
"uuu_P6RemainingTotalUnits": 1827.0,
"uuu_P6ActivityId": "true",
"uuu_P6AtCompletionDuration": 1827.0,
"uuu_P6PercentComplete": 0.0,
"uuu_P6CPIndex": 0.0,
"uuu_P6WBSCode": "wbs-1",
"uuu_P6VAC": 0.0,
"uuu_P6PerfPercComplete": 0.0,
"uuu_P6RemainingTotalCost": 1461600.0,
"uuu_P6ActivityStatus": "Not Started",
"uuu_P6PlannedDuration": 1827.0,
"uuu_P6ActualTotalCost": 0.0,
"uuu_P6AtCompletionTotalCost": 1461600.0,
"uuu_P6PVCost": 0.0,
"uuu_P6SPIndex": 0.0,
"uuu_P6PlannedStart": "2030-08-06T08:00:00",
"uuu_P6PlannedTotalUnits": 1827.0,
"uuu_P6Start": "2030-08-06T08:00:00",
"uuu_P6RemainingDuration": 1827.0
}
],
"message": [
"success"
],
"status": 200,
"rest_audit_id": 17150
}
Sample Failed Response
If the API request contains special characters in the source_project_id, the following response is generated.
{
"data": [],
"message": [
"The API request contains an special characters: [source_project_id]. Please check if this source_project_id should not contain characters: / \\ : * ? \" < > | ' ="
],
"status": 12022,
"rest_audit_id": 4180
}
Related Topics
Create, Update, and Remove Assignments
Create or Update Assignment Spreads
Create or Update Activity Spreads
Create, Update, and Remove Activities from the System Activity Sheet of a Specific Shell
Create, Update, and Delete Activities in the Manual Activity Sheet of a Specific Shell
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
Last Published Wednesday, April 9, 2025