Plans
Represents a plan which can be owned by a group.
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'
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 |
The unique identifier of the plan. |
| container_containerId | String | False |
Specifies the container of the plan. |
| container_type | String | False |
The type of the resource that contains the plan. |
| container_url | String | False |
The property that identifies the container of a plan. |
| createdBy_application_displayName | String | False |
The user who created the plan. |
| createdBy_application_id | String | False |
The ID of the user who created the plan. |
| createdDateTime | Datetime | False |
The date and time that the plan is created. |
| owner | String | False |
The ID of the group that owns the plan. |
| title | String | False |
The title of the plan. |
| details_id | String | True |
The unique identifier for the plan details. |
| GroupId | String | False |
The unique identifier of the group. |
| Etag | String | False |
The unique identifier for a resource version. |