Retrieve all posts for an organization.

Select

The OrganizationId column is required and must be specified in the criteria to use this view.

The connector will use the LinkedIn Marketing Solutions API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

• OrganizationId supports the '=' comparisons.

OrganizationID

You can obtain OrganizationId information from the LinkedIn dashboard. The syntax is:

"com.linkedin.common.CompanyAttributedEntity": { "company": "urn:li:organization:12345" }

Code Samples

The following queries are processed server side:

SELECT * FROM Posts WHERE OrganizationId = '123456789'

Columns

Name	Type	Description
Id [KEY]	String	Id of the post.
Author	String	Author of the post.
Commentary	String	The user generated commentary for the post.
Content	String	The posted content.
CreatedAt	Datetime	Datetime when the post was created.
IsReshareDisabledByAuthor	Boolean	Indicates whether resharing of the post has been disabled by the author.
LastModifiedAt	Datetime	Datetime when the post was lastly modified.
LifecycleState	String	Lifecycle state of the post.
PublishedAt	Datetime	Datetime at which the content was published.
Visibility	String	Visibility restrictions on content.
OrganizationId	String	Id of the organization who created the post.
ContentLandingPage	String	Web page that is opened when the member clicks on the associated content.
IsDirectSponsoredContent	Boolean	Whether or not this post is Direct Sponsored Content.
DirectSponsoredContentAdAccount	String	The Ad Account that created the Direct Sponsored Content.
DirectSponsoredContentAdType	String	The type of Direct Sponsored Content.
DirectSponsoredContentName	String	Plain text name of the Direct Sponsored Content post.
DirectSponsoredContentStatus	String	The status of the advertising company content.