ODBC Driver for Microsoft Planner

Build 24.0.9063

Buckets

Represents a custom column to organize tasks into phases, types of work, or departments.

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

  • PlanId supports the '=' operator.
  • BucketId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Buckets WHERE PlanId = 'nETc1IDpYk3r3e317w8TxGmUAGFWC'
SELECT * FROM Buckets WHERE BucketId = 'qIguxctMLEGHYhmgSVGSNGUAAZOZ'

Insert

Required fields for an insert are: name and planId.
Optional: orderHint.

INSERT INTO Buckets (Name, PlanId) VALUES ('Advertising', 'xqQg5FS2LkCp935s-FIFm2QAFkHM')
INSERT INTO Buckets (Name, PlanId, orderHint) VALUES ('Advertising', 'xqQg5FS2LkCp935s-FIFm2QAFkHM', ' !')

Update

Microsoft Planner allows updates for the name and orderHint columns.

UPDATE Buckets SET Name = 'To do', orderHint = ' !' WHERE BucketId = 'rWpNKGmHukm84GaiDF_ZL2UAOlMj'

Delete

Buckets can be deleted by providing BucketId.

DELETE FROM Buckets WHERE BucketId = 'yHiJQjZK0kGVt4flhItk0mUANJwN'

Columns

Name Type ReadOnly Description
BucketId [KEY] String False

The unique identifier of the bucket.

name String False

The name of the bucket.

orderHint String False

The hint used to order items of this type in a list view.

planId String False

The plan ID to which the bucket belongs.

Etag String False

The unique identifier for a resource version.

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