Power BI Connector for Microsoft Planner

Build 24.0.8963

TaskComments

null

Table Specific Information

Select

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

If Scope = NoAdminConsent, List the data related to the groups that the user is a member of.

If Scope = AdminConsent, List all the data related to groups.

  • GroupId supports the '=' operator.
  • ConversationThreadId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM TaskComments
SELECT * FROM TaskComments WHERE GroupId = '73094928-3786-4246-a0d1-90c'
SELECT * FROM TaskComments WHERE ConversationThreadId = 'AAQkADBlMTk2ZmZjLTJlZmYtNGQ0Zi05ZmViLTQwNzM0MWM0NWU5ZAMkABAAWZ7-9ddvEUa7ZFI'
SELECT * FROM TaskComments WHERE ConversationThreadId = 'AAQkADBlMTk2ZmZjLTJlZmYtNGQ0Zi05ZmViLTQwNzM0MWM0NWU5ZAMkABAAWZ7-9ddvEUa7ZFI' and GroupId = '73094928-3786-4246-a0d1-90c'

Columns

Name Type Description
body_content String
body_contentType String
conversationId [KEY] String
conversationThreadId String
from_emailAddress_address String
from_emailAddress_name String
hasAttachments Bool
newParticipants String
receivedDateTime Datetime
sender_emailAddress_address String
sender_emailAddress_name String
inReplyTo_id String
GroupId String

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