PublishedTasks
Retrieve published tasks.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | ||
| ActualCostWorkPerformed | Double | ||
| ActualDuration | String | ||
| ActualDurationMilliseconds | Int | ||
| ActualDurationTimeSpan | Time | ||
| ActualOvertimeCost | Double | ||
| ActualOvertimeWork | String | ||
| ActualOvertimeWorkMilliseconds | Int | ||
| ActualOvertimeWorkTimeSpan | Time | ||
| BaselineCost | Double | ||
| BaselineDuration | String | ||
| BaselineDurationMilliseconds | Int | ||
| BaselineDurationTimeSpan | Time | ||
| BaselineFinish | Datetime | ||
| BaselineStart | Datetime | ||
| BaselineWork | String | ||
| BaselineWorkMilliseconds | Int | ||
| BaselineWorkTimeSpan | Time | ||
| BudgetCost | Double | ||
| BudgetedCostWorkPerformed | Double | ||
| BudgetedCostWorkScheduled | Double | ||
| Contact | String | ||
| CostPerformanceIndex | Double | ||
| CostVariance | Double | ||
| CostVarianceAtCompletion | Double | ||
| CostVariancePercentage | Int | ||
| Created | Datetime | ||
| CurrentCostVariance | Double | ||
| DurationVariance | String | ||
| DurationVarianceMilliseconds | Int | ||
| DurationVarianceTimeSpan | Time | ||
| EarliestFinish | Datetime | ||
| EarliestStart | Datetime | ||
| EstimateAtCompletion | Double | ||
| ExternalProjectUid | String | ||
| ExternalTaskUid | String | ||
| FinishSlack | String | ||
| FinishSlackMilliseconds | Int | ||
| FinishSlackTimeSpan | Time | ||
| FinishVariance | String | ||
| FinishVarianceMilliseconds | Int | ||
| FinishVarianceTimeSpan | Time | ||
| FreeSlack | String | ||
| FreeSlackMilliseconds | Int | ||
| FreeSlackTimeSpan | Time | ||
| IgnoreResourceCalendar | Bool | ||
| IsCritical | Bool | ||
| IsDurationEstimate | Bool | ||
| IsExternalTask | Bool | ||
| IsOverAllocated | Bool | ||
| IsRecurring | Bool | ||
| IsRecurringSummary | Bool | ||
| IsRolledUp | Bool | ||
| IsSubProject | Bool | ||
| IsSubProjectReadOnly | Bool | ||
| IsSubProjectScheduledFromFinish | Bool | ||
| IsSummary | Bool | ||
| LatestFinish | Datetime | ||
| LatestStart | Datetime | ||
| LevelingDelay | String | ||
| LevelingDelayMilliseconds | Int | ||
| LevelingDelayTimeSpan | Time | ||
| Modified | Datetime | ||
| Notes | String | ||
| OutlinePosition | String | ||
| OvertimeCost | Double | ||
| OvertimeWork | String | ||
| OvertimeWorkMilliseconds | Int | ||
| OvertimeWorkTimeSpan | Time | ||
| PercentWorkComplete | Int | ||
| PreLevelingFinish | Datetime | ||
| PreLevelingStart | Datetime | ||
| RegularWork | String | ||
| RegularWorkMilliseconds | Int | ||
| RegularWorkTimeSpan | Time | ||
| RemainingCost | Double | ||
| RemainingOvertimeCost | Double | ||
| RemainingOvertimeWork | String | ||
| RemainingOvertimeWorkMilliseconds | Int | ||
| RemainingOvertimeWorkTimeSpan | Time | ||
| RemainingWork | String | ||
| RemainingWorkMilliseconds | Int | ||
| RemainingWorkTimeSpan | Time | ||
| Resume | Datetime | ||
| ScheduleCostVariance | Double | ||
| ScheduledDuration | String | ||
| ScheduledDurationMilliseconds | Int | ||
| ScheduledDurationTimeSpan | Time | ||
| ScheduledFinish | Datetime | ||
| ScheduledStart | Datetime | ||
| SchedulePerformanceIndex | Double | ||
| ScheduleVariancePercentage | Int | ||
| StartSlack | String | ||
| StartSlackMilliseconds | Int | ||
| StartSlackTimeSpan | Time | ||
| StartVariance | String | ||
| StartVarianceMilliseconds | Int | ||
| StartVarianceTimeSpan | Time | ||
| Stop | Datetime | ||
| ToCompletePerformanceIndex | Double | ||
| TotalSlack | String | ||
| TotalSlackMilliseconds | Int | ||
| TotalSlackTimeSpan | Time | ||
| WorkBreakdownStructure | String | ||
| WorkVariance | String | ||
| WorkVarianceMilliseconds | Int | ||
| WorkVarianceTimeSpan | Time | ||
| SubProject_Id | String | ||
| LinkedCustomFields | String | ||
| LinkedSubProject | String | ||
| ActualCost | Double | ||
| ActualFinish | Datetime | ||
| ActualStart | Datetime | ||
| ActualWork | String | ||
| ActualWorkMilliseconds | Int | ||
| ActualWorkTimeSpan | Time | ||
| BudgetWork | String | ||
| BudgetWorkMilliseconds | Int | ||
| BudgetWorkTimeSpan | Time | ||
| Completion | Datetime | ||
| ConstraintStartEnd | Datetime | ||
| ConstraintType | Int | ||
| Cost | Double | ||
| Deadline | Datetime | ||
| Duration | String | ||
| DurationMilliseconds | Int | ||
| DurationTimeSpan | Time | ||
| Finish | Datetime | ||
| FinishText | String | ||
| FixedCost | Double | ||
| FixedCostAccrual | Int | ||
| IsActive | Bool | ||
| IsEffortDriven | Bool | ||
| IsLockedByManager | Bool | ||
| IsManual | Bool | ||
| IsMarked | Bool | ||
| IsMilestone | Bool | ||
| LevelingAdjustsAssignments | Bool | ||
| LevelingCanSplit | Bool | ||
| Name | String | ||
| OutlineLevel | Int | ||
| PercentComplete | Int | ||
| PercentPhysicalWorkComplete | Int | ||
| Priority | Int | ||
| RemainingDuration | String | ||
| RemainingDurationMilliseconds | Int | ||
| RemainingDurationTimeSpan | Time | ||
| Start | Datetime | ||
| StartText | String | ||
| TaskType | Int | ||
| UsePercentPhysicalWorkComplete | Bool | ||
| Work | String | ||
| WorkMilliseconds | Int | ||
| WorkTimeSpan | Time | ||
| Calendar_Id | String | ||
| Parent_Id | String | ||
| StatusManager_Id | Int | ||
| TaskPlanLink_Id | String | ||
| LinkedAssignments | String | ||
| LinkedCalendar | String | ||
| LinkedEntityLinks | String | ||
| LinkedParent | String | ||
| LinkedPredecessors | String | ||
| LinkedStatusManager | String | ||
| LinkedSuccessors | String | ||
| LinkedTaskPlanLink | String | ||
| ProjectId [KEY] | String | Id of the parent. This column only supports equality (=) and IN filters. |