The ODataV2 schema implements the ProjectServer service endpoints. Unlike the ODataV1 schema, which is entirely read-only, this schema contains both tables and views.

Tables

テーブル represent Microsoft Project objects like Calendars, Phases, and TimeSheets. Tables support write operations (INSERT, UPDATE, and DELETE) and are retrieved dynamically from the authenticated Microsoft Project account.

Views

ビュー are table-like schema objects that represent read-only Microsoft Project objects like Events and TimeSheetPeriods. They are retrieved dynamically from the authenticated Microsoft Project account.

Stored Procedures

ストアドプロシージャ are function-like interfaces to Microsoft Project. Stored procedures allow you to execute operations to Microsoft Project.

ODataV2 Limitations

• In order to query some tables and views, such as DraftAssignments, DraftProjectResources, DraftTaskLinks and DraftTasks, you must specify the ProjectId column in the query's WHERE clause criteria or via the ProjectId connection property.
• Custom fields are not exposed in this schema.

Published and Draft Objects

Several objects in the OData V2 data model come in pairs, including a draft version (having a name starting with "Draft") and a published version (having a name starting with "Published").

While they are exposed as views, data can be inserted indirectly into published objects using draft objects as an intermediary. See 発行済みオブジェクトと下書きオブジェクト for more details.