TaskComments
Represents conversations about a plan.
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 |
| conversationId [KEY] | String | The ID of the conversation. |
| body_content | String | Specifies the body content. |
| body_contentType | String | Specifies the body content type. |
| conversationThreadId | String | The ID of the conversation thread. |
| from_emailAddress_address | String | Specifies the email address from which the email was sent. |
| from_emailAddress_name | String | Specifies the name of the person from which the email was sent. |
| hasAttachments | Bool | Specifies whether the message has attachments |
| newParticipants | String | Specifies the new participants. |
| receivedDateTime | Datetime | Specifies the received date and time. |
| sender_emailAddress_address | String | Specifies the email address of the sender. |
| sender_emailAddress_name | String | Specifies the name of the sender. |
| inReplyTo_id | String | Specifies the ID to reply to. |
| GroupId | String | The ID of the group. |