Tasks

Lists individual tasks from Microsoft To Do or Planner, with details like titles, due dates, and completion status.

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 Entra ID (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		Number of checklist items that are not yet completed in the task.
appliedCategories	String	False		Set of category labels applied to the task, such as category1, category2, category3.
assigneePriority	String	False		Priority value used to determine task assignment order among multiple users.
assignments	String	False		List of user assignments for the task, including details like assignment status and assigned time.
bucketId	String	False		Identifier of the bucket within the plan where the task is located.
checklistItemCount	Int	False		Total number of checklist items associated with the task.
completedBy_application_displayName	String	False		Display name of the application that marked the task as completed.
completedBy_application_id	String	False		Identifier of the application that marked the task as completed.
completedDateTime	Datetime	False		Timestamp indicating when the task was marked as completed.
conversationThreadId	String	False		Identifier of the conversation thread associated with the task in Microsoft 365 Groups.
createdBy_application_displayName	String	False		Display name of the application that created the task.
createdBy_application_id	String	False		Identifier of the application that created the task.
createdDateTime	Datetime	False		Timestamp when the task was created.
dueDateTime	Datetime	False		Date and time when the task is due.
hasDescription	Bool	False		Indicates whether the task has a non-empty description.
orderHint	String	False		Ordering hint used to determine the position of the task within the bucket.
percentComplete	Int	False		Percentage of the task that is completed, typically between 0 and 100.
planId	String	False		Identifier of the plan to which the task belongs.
previewType	String	False		Specifies how the task preview is rendered in the UI. Possible values include automatic, checklist, description, reference.
priority	Int	False		Numeric value representing the priority of the task. Lower values indicate higher priority.
referenceCount	Int	False		Number of external references or linked resources associated with the task.
startDateTime	Datetime	False		Date and time when work on the task is scheduled to start.
title	String	False		Title or name of the task.
Etag	String	False		Entity tag used to track the version of the task for concurrency control.
Id [KEY]	String	False		Unique identifier of the task.