TDV Adapter for Microsoft Planner

Build 21.0.8137

Buckets

The Buckets resource provides methods that allow you to manage buckets for the account.

Table Specific Information

Select

The adapter 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 adapter.

  • 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
name String False

orderHint String False

planId String False

Linkedtasks String False

BucketId [KEY] String False

Etag String False

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137