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 a Custom AzureAD App 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		The activeChecklistItemCount column for the table Tasks.
assigneePriority	String	False		The assigneePriority column for the table Tasks.
bucketId	String	False		The bucketId column for the table Tasks.
checklistItemCount	Int	False		The checklistItemCount column for the table Tasks.
completedBy_application_displayName	String	False		The completedBy_application_displayName column for the table Tasks.
completedBy_application_id	String	False		The completedBy_application_id column for the table Tasks.
completedDateTime	Datetime	False		The completedDateTime column for the table Tasks.
conversationThreadId	String	False		The conversationThreadId column for the table Tasks.
createdBy_application_displayName	String	False		The createdBy_application_displayName column for the table Tasks.
createdBy_application_id	String	False		The createdBy_application_id column for the table Tasks.
createdDateTime	Datetime	False		The createdDateTime column for the table Tasks.
dueDateTime	Datetime	False		The dueDateTime column for the table Tasks.
hasDescription	Bool	False		The hasDescription column for the table Tasks.
orderHint	String	False		The orderHint column for the table Tasks.
percentComplete	Int	False		The percentComplete column for the table Tasks.
planId	String	False		The planId column for the table Tasks.
previewType	String	False		The previewType column for the table Tasks.
referenceCount	Int	False		The referenceCount column for the table Tasks.
startDateTime	Datetime	False		The startDateTime column for the table Tasks.
title	String	False		The title column for the table Tasks.
Etag [KEY]	String	False		The Etag column for the table Tasks.