JDBC Driver for LinkedIn Marketing Solutions

Build 22.0.8462

Posts

Retrieve all posts for an organization.

Select

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

  • 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 UGCPosts 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462