Tasks

The Tasks resource provides methods that allow you to manage tasks 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.

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
assigneePriority	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
referenceCount	Int	False
startDateTime	Datetime	False
title	String	False
LinkedassignedToTaskBoardFormat	String	False
LinkedbucketTaskBoardFormat	String	False
Linkeddetails	String	False
LinkedprogressTaskBoardFormat	String	False
TaskId [KEY]	String	False
UserId	String	False
Etag	String	False