ODBC Driver for Microsoft Planner

Build 23.0.8839


The Tasks resource provides methods that allow you to manage tasks for the account.

Table Specific Information


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

  • TaskId supports the '=' operator.
  • PlanId supports the '=' and 'IN' operators.
  • BucketId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM TaskAssignments WHERE TaskId = 'BCrvyMoiLEafem-3RxIESmUAHbLK'
SELECT * FROM TaskAssignments WHERE PlanId = 'nETc1IDpYk3r3e317w8TxGmUAGFWC'
SELECT * FROM TaskAssignments WHERE PlanId IN ('nETc1IDpYk3r3e317w8TxGmUAGFWC', 'v8iK3uCb30C5I_ocMGu3SGUAHQLI', 't2eNwoPxpEqhZs38GwT1HWUADwjN')
SELECT * FROM TaskAssignments WHERE BucketId = 'qIguxctMLEGHYhmgSVGSNGUAAZOZ'


Name Type Description
PlanId [KEY] String
BucketId String
TaskId [KEY] String
AssignedToUser String
AssignedByUserId String
AssignedByUserName String
AssignedDateTime Datetime
OrderHint String

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