Tasks
null
Table Specific Information
Select
The connector 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 connector.
- TaskId supports the '=' operator.
- PlanId supports the '=' operator.
- UserId supports the '=' operator.
- BucketId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Tasks WHERE TaskId = 'BCrvyMoiLEafem-3RxIESmUAHbLK' SELECT * FROM Tasks WHERE PlanId = 'nETc1IDpYk3r3e317w8TxGmUAGFWC' SELECT * FROM Tasks WHERE UserId = '92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe' SELECT * FROM Tasks WHERE BucketId = 'qIguxctMLEGHYhmgSVGSNGUAAZOZ'
Insert
Required fields for an insert are: title and planId.
Optional: bucketId.
INSERT INTO Tasks (title, planId) VALUES ('test44', 'nETc1IDpYkmb1E17w8TxGmUAGFWC') INSERT INTO Tasks (title, planId, bucketId) VALUES ('test44', 'nETc1IDpYkmb1E17w8TxGmUAGFWC', 'ZfzKVriNQ0yzR4IqJp-8FWUADq0Y')
Update
Microsoft Planner allows updates for the title, bucketId, percentComplete, assigneePriority, conversationThreadId, orderHint, dueDateTime and startDateTime columns.
UPDATE Tasks SET assigneePriority = '8377555 94446!', bucketId = 'rWpNKGmHukm84GaiDF_ZL2UAOlMj', conversationThreadId = 'AAQkADlmMzE1ZGIzLWY3OTctNDcyMy1iYmNlLWNlZmNlZTc5', dueDateTime = '2019-09-30T14:49:23', orderHint = '343d 454fd!', startDateTime = '2019-07-31T14:49:23.269', title = 'updatedTask', percentComplete = '35' WHERE TaskId = '7POTl5DUfkOsgzptPrzdzGUAHy1z'
Delete
Tasks can be deleted by providing TaskId.
DELETE FROM Tasks WHERE TaskId = 'BCrvyMoiLEafem-3RxIESmUAHbLK'
Columns
Name | Type | ReadOnly | Description |
activeChecklistItemCount | Int | False | |
appliedCategories | String | False | |
assigneePriority | String | False | |
assignments | String | False | |
bucketId | String | False | |
checklistItemCount | Int | False | |
completedBy_application_displayName | String | False | |
completedBy_application_id | String | False | |
completedDateTime | Datetime | False | |
conversationThreadId | String | False | |
createdBy_application_displayName | String | False | |
createdBy_application_id | String | False | |
createdDateTime | Datetime | False | |
dueDateTime | Datetime | False | |
hasDescription | Bool | False | |
orderHint | String | False | |
percentComplete | Int | False | |
planId | String | False | |
previewType | String | False | |
priority | Int | False | |
referenceCount | Int | False | |
startDateTime | Datetime | False | |
title | String | False | |
assignedToTaskBoardFormat_id | String | True | |
bucketTaskBoardFormat_id | String | True | |
details_id | String | True | |
progressTaskBoardFormat_id | String | True | |
TaskId [KEY] | String | False | |
UserId | String | False | |
Etag | String | False | |
GroupId | String | False |