TDV Adapter for Office 365

Build 21.0.8137

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 OAuth 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.

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