ODBC Driver for Microsoft Planner

Build 23.0.8839

Plans

The Plans resource provides methods that allow you to manage plans for the account.

Table Specific Information

Select

The 本製品 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 本製品.

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
createdBy_application_displayName String False

createdBy_application_id String False

createdDateTime Datetime False

owner String False

title String False

Linkedbuckets String False

Linkeddetails String False

Linkedtasks String False

GroupId String False

PlanId [KEY] String False

Etag String False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839