Get Activities in the Manual Activity Sheet of a Specific Shell

Get/ws/rest/service/v2/activity/sheet/manualactivities?project_number={project number}&activity_sheet_name={manual activity sheet name}

Purpose

Retrieve a list of activities from the Manual Activity Sheet of a shell based on the project_number and activity sheet name mentioned in the query parameters.

Prerequisites

To get activities in Manual Activity Sheet, the Manual Activity Sheet should be present under the Activity Sheet sub-node.

To access the API, you should have "Get" permission Access in integration → Activity Sheet Services.

Notes:

Request Parameters

Field Name

Data Type

Description

project_number

String

Valid 'Active' Unifier shell number (shell number into which the system is going to update project details). For example, "P-0001".

activity_sheet_name

String

The name of the activity sheet.

Validation Use-Cases and Error Codes

The following table lists the messages displayed in each use-case or scenario.

Use-Case

Status

Message

project_number provided as blank

12128

The API request contains empty value for: [project_number].

Missing the project_number property in url

12206

The API request is missing the required information: [project_number].

Invalid project_number or null

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 activity sheet name is missing in url

12206

The API request is missing the required information: [activity_sheet_name`].

If activity sheet name is empty/null for activity sheet type "manual", throwing validation

12128

The API request contains empty value for: [activity_sheet_name].

Activity Sheet Name exceeded 50 characters.

12202

Invalid value was found in a field: [activity_sheet_name]. Allowed length: [50]

Activity Sheet Name doesn't exist.

12205

The API request contains an invalid value: [activity_sheet_name]. Please check if this activity_sheet_name has been configured in Unifier.

Responses

If the provided project number and activity sheet name are correct, then a success response is displayed.

Otherwise, if any of the validations is not satisfied, the response will display a message and data will return as empty.

Sample Success Response Output:

{

"data": [

{

"uuu_P6ActivityType": "Task Dependent",

"uuu_P6ActualFinish": null,

"uuu_P6ActualStart": "2022-12-10T16:00:00",

"uuu_P6RemainingEarlyStart": "2022-11-30T08:00:00",

"uuu_P6ActivityId": "A22TestSheet",

"uuu_P6ActualDuration": 0.0,

"uuu_P6AtCompletionDuration": 0.0,

"uuu_P6Finish": "2022-12-13T16:00:00",

"uuu_P6PercentComplete": 100.0,

"uuu_P6RemainingTotalCost": 0.0,

"uuu_P6RemainingEarlyFinish": "2022-12-13T16:00:00",

"uuu_P6ActivityStatus": "Not Started",

"uuu_P6PlannedDuration": 0.0,

"uuu_P6ActualTotalCost": 0.0,

"uuu_P6PlannedFinish": null,

"id": 1482795,

"uuu_P6PlannedStart": null,

"uuu_P6EVCost": 40.0,

"uuu_P6ActivityName": "A22TestSheet",

"uuu_P6PlannedTotalCost": 1.0,

"uuu_P6Start": "2022-11-30T08:00:00",

"uuu_P6RemainingDuration": 80.0

}

],

"message": [

"success"

],

"status": 200,

"rest_audit_id": 18722

}

Sample Error Response Output

{

"data": [],

"message": [

"The API request contains empty value for: [activity_sheet_name]."

],

"status": 12128,

"rest_audit_id": 18721

}

Related Topics

Activities and Assignments

Create, Update, and Remove Assignments

Create or Update Assignment Spreads

Get Spread Job Status

Create or Update Activity Spreads

Create, Update, and Remove Activities from the System Activity Sheet of a Specific Shell

Get Activities from the System Activity Sheet of a Specific Shell

Create, Update, and Delete Activities in the Manual Activity Sheet of a Specific Shell



Last Published Tuesday, July 1, 2025