TaskComments
Retrieves comments of a task.
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 | The contents of the post. |
body_contentType | String | The content type of the post. |
conversationId [KEY] | String | Unique ID of the conversation. |
conversationThreadId | String | Unique ID of the conversation thread. |
from_emailAddress_address | String | Indicates the email address, who posted the message on behalf of another user. |
from_emailAddress_name | String | Indicates the name, who posted the message on behalf of another user. |
hasAttachments | Bool | Indicates whether the post has at least one attachment. |
newParticipants | String | Conversation participants that were added to the thread as part of this post. |
receivedDateTime | Datetime | Specifies when the post was received. |
sender_emailAddress_address | String | Contains the email address of the sender. |
sender_emailAddress_name | String | Contains the name of the sender. |
inReplyTo_id | String | Reply to post id. |
GroupId | String | Group Id. |