TDV Adapter for Microsoft Planner

Build 21.0.8137

TaskDetails

The TaskDetails resource provides methods that allow you to manage task details for the account.

Table Specific Information

Select

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

  • TaskId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM TaskDetails WHERE TaskId='7POTl5DUfkOsgzptPrzdzGUAHy1z'

Insert

Insert is not supported for this table.

Update

Microsoft Planner allows updates for the title, bucketId, percentComplete, assigneePriority, conversationThreadId, orderHint, dueDateTime and startDateTime columns.

Update TaskDetails set  description = 'Task description', previewType='reference' where TaskId='7POTl5DUfkOsgzptPrzdzGUAHy1z'

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
isChecked Bool False

title String False

orderHint String False

checklist_lastModifiedBy_application_displayName String False

checklist_lastModifiedBy_application_id String False

lastModifiedDateTime Datetime False

description String False

previewType String False

TaskId [KEY] String False

CheckListId String False

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137