ODBC Driver for Microsoft Planner

Build 23.0.8839


Retrieves comments of a task.

Table Specific Information


The 本製品 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 本製品.

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'


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.

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