Plans
null
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 |
container_containerId | String | False | |
container_type | String | False | |
container_url | String | False | |
createdBy_application_displayName | String | False | |
createdBy_application_id | String | False | |
createdDateTime | Datetime | False | |
owner | String | False | |
title | String | False | |
details_id | String | True | |
GroupId | String | False | |
PlanId [KEY] | String | False | |
Etag | String | False |