Posts

Retrieves and manages sponsored posts (Direct Sponsored Content) for a LinkedIn organization. These posts are not published to the public LinkedIn feed and are used exclusively for advertising in ad accounts.

Table Specific Information

Select

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

The provider 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 provider.

OrganizationId supports the '=' comparisons.

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

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

The following queries are processed server side:

SELECT * FROM Posts WHERE OrganizationId = '123456789'

Insert

To create a new post, the following fields are required: Author, Commentary, LifecycleState, Visibility, FeedDistribution.

The following fields are optional: Content, IsReshareDisabledByAuthor, ContentLandingPage, DirectSponsoredContentName, DirectSponsoredContentStatus.

    INSERT INTO Posts ( Author, Commentary, Content, IsReshareDisabledByAuthor, LifecycleState, Visibility, ContentLandingPage, DirectSponsoredContentName, DirectSponsoredContentStatus, FeedDistribution ) VALUES ( 'urn:li:organization:12345', 'This is a sample post commentary with important updates.', 'Sample content for the post', FALSE, 'DRAFT', 'PUBLIC', 'https://example.com/landing-page', 'Sample DSC Name', 'ACTIVE', 'MAIN_FEED' );

Update

To modify an existing post, use an UPDATE statement. Note that the Id column is required in the WHERE clause.

The following columns are the ones that are mutable after creation:

Commentary
LifecycleState
DirectSponsoredContentName
DirectSponsoredContentStatus

    UPDATE Posts SET Commentary = 'Updated post commentary with new information.' WHERE Id = 'post123456';

Delete

DELETE FROM Posts WHERE Id = 'post123456';

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique identifier assigned to the post.
Author	String	False		Identifier of the author who created the post, which can represent either a LinkedIn member or organization.
Commentary	String	False		User-generated commentary or text content included in the post.
Content	String	False		Main content of the post, which may include text, images, videos, or links.
CreatedAt	Datetime	True		Date and time when the post was originally created.
IsReshareDisabledByAuthor	Boolean	False		If the value is 'true', the post cannot be reshared because the author has disabled resharing.
LastModifiedAt	Datetime	True		Date and time when the post was last modified.
LifecycleState	String	False		Indicates the current lifecycle state of the post. The allowed values are DRAFT, PUBLISHED, PUBLISH_REQUESTED, PUBLISH_FAILED.
PublishedAt	Datetime	True		Date and time when the post was published and made visible to its audience.
Visibility	String	False		Defines the visibility settings of the post. The allowed values are CONNECTIONS, PUBLIC, LOGGED_IN, CONTAINER.
OrganizationId	String	True		Identifier of the organization that created or owns the post.
ContentLandingPage	String	False		URL of the landing page opened when a member clicks on the content associated with the post.
IsDirectSponsoredContent	Boolean	True		If the value is 'true', the post is classified as Direct Sponsored Content created for advertising purposes.
DirectSponsoredContentAdAccount	String	True		Identifier of the advertising account that created the Direct Sponsored Content.
DirectSponsoredContentAdType	String	True		Specifies the type of Direct Sponsored Content. The allowed values are VIDEO, STANDARD, CAROUSEL, JOB_POSTING, NATIVE_DOCUMENT, EVENT.
DirectSponsoredContentName	String	False		Plain-text name assigned to the Direct Sponsored Content post for identification purposes.
DirectSponsoredContentStatus	String	False		Indicates the current status of the Direct Sponsored Content. The allowed values are ACTIVE, ARCHIVED.
FeedDistribution	String	True		Specifies how the post is distributed in LinkedIn feeds. Always NONE for sponsored posts, ensuring they are not published to the public feed and are only available for use in ads.