Power BI Connector for Salesforce Chatter

Build 20.0.7587

Comments

Retrieve the Comments feed.

テーブル固有の情報

Select

Comments から情報を取得します。デフォルトでは、コンテキストユーザーが保有するもしくはメンバーであるすべてのグループからコメントを返します。次を取得できます:

- コメントリスト(デフォルトはグループコメント):

SELECT * FROM Comments

- FeedType で指定したコメントリスト:

SELECT * FROM Comments WHERE FeedType = 'Company'

- Id を指定したコメント

SELECT * FROM Comments WHERE Id = '0D740000005cQ8MCAU'

Columns

Name Type Description
Id [KEY] String 18-character ID of the comment.
Text String Message text for the comment.
AttachmentAggregate String If the comment does not contain an attachment returns null.
ApplicationName String Name of the connected app used for authentication.
ApplicationUrl String Value from the Info URL field of the connected app used for authentication.
CreatedDate Datetime ISO8601 date string, for example, 2011-02-25T18:24:31.000Z.
UserId String The ID of the user that commented.
UserDisplayName String The name of the user that commented.
UserPhoto String The photo of the user that commented.
UserTitle String The title of the user that commented.
FeedElementId String The ID of the record being referenced, which could be an 18-character ID or some other string identifier.
FeedElementUrl String The URL to the resource endpoint.
IsDeleteRestricted Boolean Returns true if a comment cannot be deleted by the context user. If it returns false, possibly the context user can delete the comment.
LikesUrl String URL to the current page of likes.
LikeItemsAggregate String Collection of likes.
TotalLikes Integer Total number of likes for the item.
LikesMessageAggregate String A message body that describes who likes the comment.
MyLikeId String The ID of the record being referenced, which could be an 18-character ID or some other string identifier.
MyLikeUrl String The URL to the resource endpoint.
ParentId String The ID of the record being referenced, which could be an 18-character ID or some other string identifier.
ParentUrl String The URL to the resource endpoint.
Type String Indicates the type of comment. Valid values are ContentComment or TextComment.
Url String URL to this comment.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
FeedType String Specifies the feed type. The default value is Groups. Valid values are Groups, News, User, or Company.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587