Excel Add-In for Microsoft Planner

Build 24.0.8963

TaskComments

null

Table Specific Information

Select

The add-in 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 add-in.

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