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:

Retrieve 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

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

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

Validation Use-Cases and Error Codes

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

Responses

If the project number and the source project ID is correct, a success response is displayed.

If any of the validations are not satisfied, then the response will return a message and the data will return as empty.

Sample Response Success Output

{

"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 Error Response Output

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