Buckets
null
Table Specific Information
Select
The add-in 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 add-in.
- 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 | |
BucketId [KEY] | String | False | |
Etag | String | False |