Projects
Retrieve projects.
Columns
| Name | Type | References | Description |
| ProjectId [KEY] | String | ||
| EnterpriseProjectTypeDescription | String | ||
| EnterpriseProjectTypeId | String | ||
| EnterpriseProjectTypeIsDefault | Bool | ||
| EnterpriseProjectTypeName | String | ||
| OptimizerCommitDate | Datetime | ||
| OptimizerDecisionAliasLookupTableId | String | ||
| OptimizerDecisionAliasLookupTableValueId | String | ||
| OptimizerDecisionID | Int | ||
| OptimizerDecisionName | String | ||
| OptimizerSolutionName | String | ||
| ParentProjectId | String | ||
| PlannerCommitDate | Datetime | ||
| PlannerDecisionAliasLookupTableId | String | ||
| PlannerDecisionAliasLookupTableValueId | String | ||
| PlannerDecisionID | Int | ||
| PlannerDecisionName | String | ||
| PlannerEndDate | Datetime | ||
| PlannerSolutionName | String | ||
| PlannerStartDate | Datetime | ||
| ProjectActualCost | Decimal | ||
| ProjectActualDuration | Decimal | ||
| ProjectActualFinishDate | Datetime | ||
| ProjectActualOvertimeCost | Decimal | ||
| ProjectActualOvertimeWork | Decimal | ||
| ProjectActualRegularCost | Decimal | ||
| ProjectActualRegularWork | Decimal | ||
| ProjectActualStartDate | Datetime | ||
| ProjectActualWork | Decimal | ||
| ProjectACWP | Decimal | ||
| ProjectAuthorName | String | ||
| ProjectBCWP | Decimal | ||
| ProjectBCWS | Decimal | ||
| ProjectBudgetCost | Decimal | ||
| ProjectBudgetWork | Decimal | ||
| ProjectCalculationsAreStale | Bool | ||
| ProjectCalendarDuration | Int | ||
| ProjectCategoryName | String | ||
| ProjectCompanyName | String | ||
| ProjectCost | Decimal | ||
| ProjectCostVariance | Decimal | ||
| ProjectCPI | Decimal | ||
| ProjectCreatedDate | Datetime | ||
| ProjectCurrency | String | ||
| ProjectCV | Decimal | ||
| ProjectCVP | Decimal | ||
| ProjectDepartments | String | ||
| ProjectDescription | String | ||
| ProjectDuration | Decimal | ||
| ProjectDurationVariance | Decimal | ||
| ProjectEAC | Decimal | ||
| ProjectEarlyFinish | Datetime | ||
| ProjectEarlyStart | Datetime | ||
| ProjectEarnedValueIsStale | Bool | ||
| ProjectEnterpriseFeatures | Bool | ||
| ProjectFinishDate | Datetime | ||
| ProjectFinishVariance | Decimal | ||
| ProjectFixedCost | Decimal | ||
| ProjectIdentifier | String | ||
| ProjectKeywords | String | ||
| ProjectLastPublishedDate | Datetime | ||
| ProjectLateFinish | Datetime | ||
| ProjectLateStart | Datetime | ||
| ProjectManagerName | String | ||
| ProjectModifiedDate | Datetime | ||
| ProjectName | String | ||
| ProjectOvertimeCost | Decimal | ||
| ProjectOvertimeWork | Decimal | ||
| ProjectOwnerId | String | ||
| ProjectOwnerName | String | ||
| ProjectPercentCompleted | Int | ||
| ProjectPercentWorkCompleted | Int | ||
| ProjectRegularCost | Decimal | ||
| ProjectRegularWork | Decimal | ||
| ProjectRemainingCost | Decimal | ||
| ProjectRemainingDuration | Decimal | ||
| ProjectRemainingOvertimeCost | Decimal | ||
| ProjectRemainingOvertimeWork | Decimal | ||
| ProjectRemainingRegularCost | Decimal | ||
| ProjectRemainingRegularWork | Decimal | ||
| ProjectRemainingWork | Decimal | ||
| ProjectResourcePlanWork | Decimal | ||
| ProjectSPI | Decimal | ||
| ProjectStartDate | Datetime | ||
| ProjectStartVariance | Decimal | ||
| ProjectStatusDate | Datetime | ||
| ProjectSubject | String | ||
| ProjectSV | Decimal | ||
| ProjectSVP | Decimal | ||
| ProjectTCPI | Decimal | ||
| ProjectTimephased | String | ||
| ProjectTitle | String | ||
| ProjectType | Int | ||
| ProjectVAC | Decimal | ||
| ProjectWork | Decimal | ||
| ProjectWorkspaceInternalUrl | String | ||
| ProjectWorkVariance | Decimal | ||
| ResourcePlanUtilizationDate | Datetime | ||
| ResourcePlanUtilizationType | Int | ||
| WorkflowError | String | ||
| WorkflowErrorResponseCode | Int | ||
| WorkflowInstanceId | String | ||
| WorkflowOwnerId | String | ||
| WorkflowOwnerName | String | ||
| LinkedAssignmentBaselines | String | ||
| LinkedAssignments | String | ||
| LinkedDeliverables | String | ||
| LinkedDependencies | String | ||
| LinkedIssues | String | ||
| LinkedRisks | String | ||
| LinkedStagesInfo | String | ||
| LinkedTasks | String |