Retrieve and modify published projects.

Table Specific Information

Unlike most published tables, PublishedProjects does support executing INSERT and DELETE queries directly without the four-step process described in Published and Draft Objects:

INSERT INTO PublishedProjects (Description, EnterpriseProjectTypeId, Name, Start) VALUES ('New Test Published Project', '74ef28dd-b9d5-ef11-a65b-00155df09101', 'My test Temp Project', '2025-04-18');

DELETE FROM PublishedProjects WHERE ID = 'projectId'

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 function. This is the default and is recommended. Set to 'ODATA' to use standard ODATA insert functionality. This input is only applicable during inserts. The value set in this input overrides the value set in the InsertMode connection property (see the documentation page for the InsertMode connection property for more information).