live_post |
Social Live Post
Catalog: Odoo
Schema: social
Documentation:
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.
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table live_post are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_id_label |
string |
|
☐ |
|
account_id |
string |
|
☐ |
|
company_id_label |
string |
|
☐ |
Link an account to a company to restrict its usage or keep empty to let all companies use it. |
company_id |
string |
|
☐ |
Link an account to a company to restrict its usage or keep empty to let all companies use it. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
engagement |
int32 |
Engagement |
☐ |
Number of people engagements with the post (Likes, comments...) |
facebook_post_id |
string |
Actual Facebook ID of the post |
☐ |
|
failure_reason |
string |
Failure Reason |
☐ |
The reason why a post is not successfully posted on the Social Media (eg: connection error, duplicated post, ...). |
id |
int32 |
ID |
☐ |
|
instagram_post_id |
string |
Instagram Post ID |
☐ |
|
linkedin_post_id |
string |
Actual LinkedIn ID of the post |
☐ |
|
live_post_link |
string |
Post Link |
☐ |
Link of the live post on the target media. |
message |
string |
Message |
☐ |
Content of the social post message that is post-processed (links are shortened, UTMs, ...) |
post_id_label |
string |
|
☐ |
|
post_id |
string |
|
☐ |
|
reached_visitor_ids |
string |
|
☐ |
|
state |
string |
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_tweet_id |
string |
Twitter tweet id |
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
youtube_video_id |
string |
YouTube Video Id |
☐ |
Contains the ID of the video as returned by the YouTube API |
01-03-2023 15:29 Version 22.1.135-BETA+3826