ODBC Driver for Microsoft Planner

Build 23.0.8839


The PlanDetails resource provides methods that allow you to manage plan details for the account.

Table Specific Information


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

  • PlanId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM PlanDetails WHERE planId = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'


INSERT is not supported for this table.


Microsoft Planner allows updates for the title, bucketId, percentComplete, assigneePriority, conversationThreadId, orderHint, dueDateTime and startDateTime columns.

UPDATE PlanDetails SET categoryDescriptions_category1 = 'Cat#1', categoryDescriptions_category2 = 'Cat#2', categoryDescriptions_category3 = 'Cat#3', categoryDescriptions_category4 = 'Cat#4', categoryDescriptions_category5 = 'Cat#5', categoryDescriptions_category6 = 'Cat#6'  WHERE PlanId = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'


Delete is not supported for this table.


Name Type ReadOnly Description
categoryDescriptions_category1 String False

categoryDescriptions_category2 String False

categoryDescriptions_category3 String False

categoryDescriptions_category4 String False

categoryDescriptions_category5 String False

categoryDescriptions_category6 String False

PlanId [KEY] String False

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