ODBC Driver for Workday

Build 25.0.9434

TaskResources

Retrieves a collection of task resources, including metadata and dependencies associated with tasks within Workday.

Workday Resource Information

Retrieves all task resources for a given project.

You can filter the task resources by the Project {id}, or projectPlanTask {id}.

Secured by: Manage: Project Task Resources

Scope: Projects

Aggregate Fields

The driver represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

ProjectResources_Aggregate


[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
 -processingUserHasAccessToViewWorker: Boolean /* Processing user has view access to \~Worker\~ */
 -unnamedResource: Boolean /* If true, the project resource is an unnamed resource. */
}]

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier for the project task resource instance.

Allocation Decimal False

The percentage of time allocated to this task resource within the project.

Descriptor String False

A brief preview of the task resource instance.

EndDate Datetime False

The scheduled end date for this task resource assignment.

EstimatedHours Decimal False

The estimated number of hours required for the task resource to complete the assigned work.

Memo String False

Additional notes or comments associated with the project task resource.

ProjectPlanLine_AssociationResourcePlanDetail Bool False

Indicates whether this resource plan detail is an association-type resource allocation.

ProjectPlanLine_Descriptor String False

A brief preview of the project plan line instance.

ProjectPlanLine_Id String False

The unique identifier for the project plan line.

ProjectPlanTask_Descriptor String False

A description of the specific project task to which this resource is assigned.

ProjectPlanTask_Href String False

A direct link to the project plan task instance.

ProjectPlanTask_Id String False

The Workday ID of the project plan task.

ProjectResources_Aggregate String False

A collection of workers or unnamed resources assigned to this resource plan.

StartDate Datetime False

The scheduled start date for this task resource assignment.

WarningCustomValidations String False

List of warning messages for custom validations associated with this project task resource.

ProjectPlanTask_Prompt String False

Filters task resources by the specified project plan task.

Project_Prompt String False

Filters task resources by the specified project.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434