Plans
Represents individual plans, each associated with a group, to organize and track project-related tasks.
Table Specific Information
Select
The add-in will use the Microsoft Planner API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
If Scope = NoAdminConsent, List the data related to the groups that the user is a member of.
If Scope = AdminConsent, List all the data related to groups.
- PlanId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Plans WHERE PlanId = 'nETc1IDpYk3r3e317w8TxGmUAGFWC'
If no filter is provided, the add-in queries Groups and reads the plans for each group.
Insert
Required fields for an insert are: title and owner.
INSERT INTO Plans (title, owner) VALUES ('Plan#5', 'acc24236-0d62-4d30-9a7f-98cfbcd3a6e7')
Update
Microsoft Planner allows updates for the title and owner columns.
UPDATE Plans SET title = 'Plan#1' WHERE PlanId = 'nETc1IDpYkmb1E17c4TxGmUAGFWC'
Columns
| Name | Type | ReadOnly | Description |
| PlanId [KEY] | String | False |
A globally unique identifier (GUID) representing the specific plan within the system. |
| container_containerId | String | False |
The unique identifier of the container, such as a group or team, that hosts the plan. |
| container_type | String | False |
Indicates the type of resource (for example, group, team) that serves as the container for this plan. |
| container_url | String | False |
A URL that provides a direct reference to the container of the plan, enabling easy access or navigation. |
| createdBy_application_displayName | String | False |
The display name of the application or user that initiated the creation of this plan. |
| createdBy_application_id | String | False |
The unique identifier (ID) of the application or user responsible for creating the plan. |
| createdDateTime | Datetime | False |
The exact date and time when the plan was created, recorded in ISO 8601 format. |
| owner | String | False |
The unique identifier of the group or entity that owns and manages the plan. |
| title | String | False |
The descriptive name or title assigned to the plan for identification and categorization. |
| details_id | String | True |
A unique identifier linking to the details or metadata associated with the plan. |
| GroupId | String | False |
The unique identifier for the group associated with this plan, often used for permissions and ownership. |
| Etag | String | False |
A version control token used to track changes and ensure consistency for this resource. |