CompanyStatusUpdates

Read and write posts in your organizations.

Table-specific Information

Note: Requires the w_organization_social OAuth scope.

Select

For the CompanyId column, the = operator is fully supported server-side. Refer to the query examples below:

SELECT * FROM CompanyStatusUpdates WHERE CompanyId = '183432'

Insert

The CompanyStatusUpdates table supports creating new posts in the organization pages that you administer. The following columns are required when creating a new post:

Comment
CreatedBy
Visibility
LifecycleState

Refer to the query examples below:

INSERT INTO CompanyStatusUpdates(Comment, CreatedBy, Visibility, LifecycleState, IsReshareDisabled) VALUES('Test Post', 'urn:li:organization:101409996', 'PUBLIC', 'DRAFT', true);

Update

The CompanyStatusUpdates table supports updating the posts in the organization pages that you administer. Only the following columns can be updated:

Comment
LifecycleState

The Id column must be specified in the criteria. Refer to the query examples below:

UPDATE CompanyStatusUpdates SET Comment = 'My Post', LifecycleState = 'PUBLISHED' WHERE Id = 'urn:li:share:7383870244806791168'

Delete

The CompanyStatusUpdates table supports deleting the posts in the organization pages that you administer. The Id column must be specified in the criteria. Refer to the query examples below:

DELETE FROM CompanyStatusUpdates WHERE Id = 'urn:li:share:7383870244806791168'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique identifier for the post.
Comment	String	False		Text comment associated with the post.
CompanyId	String	True		Identifier of the company to which the post belongs.
Date	Datetime	True		Timestamp when the post was created.
CreatedBy	String	False		Identifier of the user who created the post.
FirstPublishedAt	Datetime	True		Timestamp when the post was published.
LastModified	Datetime	True		Timestamp when the post most last modified.
Visibility	String	False		Specifies who can view the post. The allowed values are CONNECTIONS, PUBLIC, LOGGED_IN.
LifecycleState	String	False		Current lifecycle state of the post. The allowed values are DRAFT, PUBLISHED, PUBLISH_REQUESTED, PUBLISH_FAILED.
Content	String	False		Main content of the post.
ContentCTALabel	String	True		The call-to-action label used in the post's content. The allowed values are APPLY, DOWNLOAD, VIEW_QUOTE, LEARN_MORE, SIGN_UP, SUBSCRIBE, REGISTER, JOIN, ATTEND, REQUEST_DEMO, SEE_MORE, BUY_NOW, SHOP_NOW.
IsReshareDisabled	Boolean	False		Indicates if the author has disabled re-sharing for the post.
ParentPostURN	String	False	CompanyStatusUpdates.Id	URN of the parent post if the post is a re-share.
RootPostURN	String	True	CompanyStatusUpdates.Id	URN of the root post in the re-share chain if the post is a re-share.