MCP Server for Microsoft Project

Build 25.0.9440

PublishedProjects

Retrieve and modify published projects.

Columns

Name Type ReadOnly References Required Description
Id [KEY] String False False

ApprovedEnd Datetime False False

ApprovedStart Datetime False False

CalculateActualCosts Bool False False

CalculatesActualCosts Bool False False

CheckedOutDate Datetime False False

CheckOutDescription String False False

CheckOutId String False False

CreatedDate Datetime False False

CriticalSlackLimit Int False False

DefaultFinishTime Datetime False False

DefaultOvertimeRateUnits Int False False

DefaultStandardRateUnits Int False False

DefaultStartTime Datetime False False

HasMppPendingImport Bool False False

HonorConstraints Bool False False

IsCheckedOut Bool False False

LastPublishedDate Datetime False False

LastSavedDate Datetime False False

ListId String False False

MoveActualIfLater Bool False False

MoveActualToStatus Bool False False

MoveRemainingIfEarlier Bool False False

MoveRemainingToStatus Bool False False

MultipleCriticalPaths Bool False False

OptimizerDecision Int False False

PercentComplete Int False False

PlannerDecision Int False False

ProjectSiteUrl String False False

ProjectType Int False False

SplitInProgress Bool False False

SpreadActualCostsToStatus Bool False False

SpreadPercentCompleteToStatus Bool False False

SummaryTaskId String False False

TaskListId String False False

WebId String False False

CheckedOutBy_Id Int True False

EnterpriseProjectType_Id String True False

Phase_Id String True False

ProjectSummaryTask_Id String True False

Stage_Id String True False

LinkedCheckedOutBy String False False

LinkedCustomFields String False False

LinkedEngagements String False False

LinkedEnterpriseProjectType String False False

LinkedPhase String False False

LinkedProjectSummaryTask String False False

LinkedQueueJobs String False False

LinkedStage String False False

LinkedUserPermissions String False False

CurrencyCode String False False

CurrencyDigits Int False False

CurrencyPosition Int False False

CurrencySymbol String False False

CurrentDate Datetime False False

DaysPerMonth Int False False

DefaultEffortDriven Bool False False

DefaultEstimatedDuration Bool False False

DefaultFixedCostAccrual Int False False

DefaultOvertimeRate Double False False

DefaultStandardRate Double False False

DefaultTaskType Int False False

DefaultWorkFormat Int False False

Description String False False

EnterpriseProjectTypeId String False False

FinishDate Datetime False False

FiscalYearStartMonth Int False False

IsEnterpriseProject Bool False False

MinutesPerDay Int False False

MinutesPerWeek Int False False

Name String False False

NewTasksAreManual Bool False False

NumberFiscalYearFromStart Bool False False

OwnerId String False False

ProjectIdentifier String False False

ProtectedActualsSynch Bool False False

ScheduledFromStart Bool False False

ShowEstimatedDurations Bool False False

StartDate Datetime False False

StatusDate Datetime False False

TrackingMode Int False False

UtilizationDate Datetime False False

UtilizationType Int False False

WeekStartDay Int False False

WinprojVersion Decimal False False

Calendar_Id String True False

Draft_Id String True False

IncludeCustomFields_Id String True False

Owner_Id Int True False

ProjectWorkflowInstance_Id String True False

LinkedAssignments String False False

LinkedCalendar String False False

LinkedDraft String False False

LinkedEntityLinks String False False

LinkedIncludeCustomFields String False False

LinkedOwner String False False

LinkedProjectResources String False False

LinkedProjectWorkflowInstance String False False

LinkedTaskLinks String False False

LinkedTasks String False False

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
InsertMode String

Determines the Insert Mode. Set to 'ADD' to use standard MSProject Add functions. Set to 'ODATA' to use standard ODATA insert functionality. Only applicable during inserts.

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