Power BI Connector for Microsoft Planner

Build 24.0.8963

Tasks

null

Table Specific Information

Select

The connector 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 connector.

  • 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

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

assignedToTaskBoardFormat_id String True

bucketTaskBoardFormat_id String True

details_id String True

progressTaskBoardFormat_id String True

TaskId [KEY] String False

UserId String False

Etag String False

GroupId String False

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