Excel Add-In for Microsoft Planner

Build 24.0.9063

Tasks

Allows users to manage tasks, plans, and initiatives.

Table Specific Information

Select

The 本製品 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 本製品.

  • 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
TaskId [KEY] String False

The unique identifier of the task.

activeChecklistItemCount Int False

Specifies the active checklist item count.

appliedCategories String False

The categories to which the task has been applied.

assigneePriority String False

The hint used to order items of this type in a list view.

assignments String False

The set of assignees the task is assigned to.

bucketId String False

The bucket ID to which the task belongs.

checklistItemCount Int False

The number of checklist items that are present on the task.

completedBy_application_displayName String False

Label Completed By Application Display Name corresponds to this field.

completedBy_application_id String False

Label Completed By Application ID corresponds to this field.

completedDateTime Datetime False

Specifies the completed date and time.

conversationThreadId String False

The thread ID of the conversation on the task.

createdBy_application_displayName String False

Label Created By Application Display Name corresponds to this field.

createdBy_application_id String False

Label Created By Application ID corresponds to this field.

createdDateTime Datetime False

Specifies the date and time at which the task is created.

dueDateTime Datetime False

Specifies the date and time at which the task is due.

hasDescription Bool False

The value is true if the details object of the task has a nonempty description and false otherwise.

orderHint String False

Typically used to set the relative order of items in the task.

percentComplete Int False

Specifies how much of the task has been completed, given in a percentage.

planId String False

The unique identifier of the plan.

previewType String False

This sets the type of preview that shows up on the task.

priority Int False

The priority of the task.

referenceCount Int False

The number of external references that exist on the task.

startDateTime Datetime False

Specifies the date and time at which the task starts.

title String False

The title of the task item.

assignedToTaskBoardFormat_id String True

Typically used to render the task correctly in the task board view when grouped by assignedTo.

bucketTaskBoardFormat_id String True

Typically used to render the task correctly in the task board view when grouped by bucket.

details_id String True

Specifies more details about the task.

progressTaskBoardFormat_id String True

Typically used to render the task correctly in the task board view when grouped by progress.

UserId String False

Unique identifier of the user.

Etag String False

Unique identifier for a resource version.

GroupId String False

Unique identifier of the group.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063