TDV Adapter for Microsoft Office 365

Build 22.0.8462

Plans

The Office365 table Plans.

Table Specific Information

Using Plans requires access to Groups permissions. This requires Admin approval. For this reason, you must use your own OAuth App to add the Groups permissions and from the Microsoft Graph. See Creating a Custom AzureAD App for more details.

Select

All plans in MS Planner exist as a part of a group. In order to retrieve the list of available plans, you must retrieve a list of available plans per group. If no GroupId is specified, then the following WHERE condition will be appended to any query:

GroupId IN (SELECT Id FROM Groups)

Columns

Name Type ReadOnly References Description
createdBy_application_displayName String False

The createdBy_application_displayName column for the table Plans.

createdBy_application_id String False

The createdBy_application_id column for the table Plans.

createdDateTime Datetime False

The createdDateTime column for the table Plans.

owner String False

The owner column for the table Plans.

title String False

The title column for the table Plans.

GroupId [KEY] String False

The GroupId column for the table Plans.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462