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

}