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 |