live_post: Odoo itgen_odoo_live_post
read only per partition
- Catalog:
Odoo - Schema:
social - Label: itgen_odoo_live_post
Social Live Post
Can only retrieve data.
Summary
A social 'live' post, as opposed to a social.post, represents a post that is actually on a social.account instance.
Basically, a social.post that is posted on 4 social.accounts will create 4 instances
of the social.live.post.
Table Columns
The columns of the table live_post are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
account_ |
varchar2 |
||||
account_ |
varchar2 |
||||
company_ |
varchar2 |
Link an account to a company to restrict its usage or keep empty to let all companies use it. | |||
company_ |
varchar2 |
Link an account to a company to restrict its usage or keep empty to let all companies use it. | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
engagement |
int32 |
Engagement | Number of people engagements with the post (Likes, comments...) | ||
facebook_ |
varchar2 |
Actual Facebook ID of the post | |||
failure_ |
varchar2 |
Failure Reason | The reason why a post is not successfully posted on the Social Media (eg: connection error, duplicated post, ...). | ||
id |
int32 |
ID | |||
instagram_ |
varchar2 |
Instagram Post ID | |||
linkedin_ |
varchar2 |
Actual LinkedIn ID of the post | |||
live_ |
varchar2 |
Post Link | Link of the live post on the target media. | ||
message |
varchar2 |
Message | Content of the social post message that is post-processed (links are shortened, UTMs, ...) | ||
post_ |
varchar2 |
||||
post_ |
varchar2 |
||||
reached_ |
varchar2 |
||||
state |
varchar2 |
Status | Most social.live.posts directly go from Ready to Posted/Failed since they result of a single call to the third party API. A 'Posting' state is also available for those that are sent through batching (like push notifications). | ||
twitter_ |
varchar2 |
Twitter tweet id | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
||||
youtube_ |
varchar2 |
YouTube Video Id | Contains the ID of the video as returned by the YouTube API |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: