Plans
Represents individual plans, each associated with a group, to organize and track project-related tasks.
Table Specific Information
Select
The connector 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 connector.
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 |
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. |