Tasks

The Office365 table Tasks.

Table Specific Information

Tasks requires the Groups and Tasks permissions from the Microsoft Graph. For this reason, you must create your own OAuth App. Please see Creating an Azure AD Application for more details.

Select

By default, if no criteria is specified, only Tasks personally assigned to you will show up. For example:

SELECT * FROM Tasks

To bring back tasks across the organization, provide the specific plans ids, or use a subselect for the plan id. For example:

SELECT * FROM Tasks WHERE PlanId IN (SELECT Id FROM Plans)

Insert

To insert a Task, the associated plan must be specified:

INSERT INTO Tasks (Title, PlanId) VALUES ('My Title', '99999999-eeeeeeeee')

Update

To update a Task, both the Id and Etag must be specified:

UPDATE Tasks SET Title = 'New Title' WHERE Id = 'xxxxxx-AAAAAAAAAAA' AND Etag = 'W/\"XXXXXXQEBAQEBAQEBAQEBAQEBARCc=\"'

Delete

To delete a Task, both the Id and Etag must be specified:

DELETE FROM Tasks WHERE Id = 'xxxxxx-AAAAAAAAAAA' AND Etag = 'W/\"XXXXXXQEBAQEBAQEBAQEBAQEBARCc=\"'

Columns


Name	Type	ReadOnly	References	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
Etag	String	False
Id [KEY]	String	False