Query Comments data for Posts in the Organization Pages that you administer.

Note: Requires the r_organization_social OAuth scope.

Select

The Comments view supports filtering on the WHERE clause only for the UpdateId column and only for the = and IN operators. The = operator is fully supported server-side, whereas the IN operator is partially supported server-side and partially client-side. Refer to the query examples below:

SELECT * FROM Comments WHERE UpdateId = 'urn:li:share:7155174232715386880';
SELECT * FROM Comments WHERE UpdateId IN ('urn:li:share:7155174232715386880', 'urn:li:share:7165681621608738816');

The following query returns the data for the columns we expose in the view, for each Post in each Organization Page that the user administers.

SELECT * FROM Comments;

To retrieve information on Posts in your Organization Pages, use CompanyStatusUpdates.

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier for the comment.
UpdateId	String	Id of the Update associated with the comment.
Text	String	Content of the update comment.
CreatedBy	String	The unique identifier for the person or company.
Date	Datetime	Comment created time.
Mentions	String	The URNs of the organizations or people mentioned in comment.