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

Activities and Assignments

Create, Update, and Remove Assignments

Get Assignments

Create or Update Assignment Spreads

Get Assignment Spread

Get Activity Spread

Get Spread File

Get Spread Job Status

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 Manual Activity Sheet

Create or Update Baseline Schedule for Manual Activity Sheet

Get Activities in the Manual Activity Sheet of a Specific Shell

Schedule Creation of Manual Activity Sheet

Recost Project for Manual Activity Sheet

Create Activity Dependency



Last Published Tuesday, July 1, 2025