Plans
Represents a plan which can be owned by a group.
Table Specific Information
Select
The driver 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 driver.
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. |