Power BI Connector for Salesforce Chatter

Build 20.0.7587

Announcements

Get the announcements for the specified parent or get information about an announcement.

テーブル固有の情報

Select

Announcements から情報を取得します。次を指定する必要があります:CommunityId、GroupId、AnnouncementId [Id]、または2つのId の組み合わせ。使用可能な演算子は '=' と'AND' です。

SELECT * FROM Announcements WHERE GroupId = 'abc123'

Columns

Name Type Description
Id [KEY] String 18-character Id of the announcement.
Text String Text of the announcement.
GroupId String Id of the group associated with the current announcement.
CommunityId String Id of the community associated with the current announcement.
ActorDisplayName String Display name of the user associated with the current announcement.
ActorId String Id user associated with the current announcement.
ActorPhoto String Photo URL of the actor associated with the current announcement.
ActorTitle String Title of the actor associated with the current announcement.
CreatedDate Datetime Date the announcement was created.
ModifiedDate Datetime When the announcement was last modified.
ExpirationDate Datetime The Salesforce UI displays an announcement until 11:59 p.m. on this date unless another announcement is posted first.
CanShare Boolean Whether the announcement can be shared or not.
IsEvent Boolean Whether the announcement is an event.
ParentId String Id of the parent the announcement is associated with.
ParentName String Name of the parent the announcement is associated with.
IsArchived Boolean Specifies whether the announcement is archived.
SendEmails Boolean Specifies whether the announcement is sent as an email to all group members.
URL String The URL to the announcement.

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