Navigation: Schema: social > Tables

stream_post

Social Stream Post

Catalog: Odoo

Schema: social

Documentation:

A 'stream' post, as opposed to a regular social.post, references a post that

actually exists on a social.media external database (a Facebook post, a Tweet, ...).

Stream posts are created by fetching data from the related social media third party API.

They should not be directly created/modified.

social.stream.posts are used to fill the 'Feed' view that allows users to follow the social.media activity

based on their interest (a Facebook Page, a Twitter hashtag, ...).

They are directly created by their related social.stream.

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 stream_post are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required	Documentation
account_id_label	string		☐
account_id	string		☐
author_link	string	Author Link	☐	Author link to the external social.media (ex: link to the Twitter Account).
author_name	string	Author Name	☐	The post author name based on third party information (ex: 'John Doe').
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	☐
facebook_author_id	string	Facebook Author ID	☐
facebook_comments_count	int32	Comments	☐
facebook_is_event_post	boolean	Is event post	☐
facebook_likes_count	int32	Likes	☐
facebook_post_id	string	Facebook Post ID	☐
facebook_reach	int32	Reach	☐
facebook_shares_count	int32	Shares	☐
facebook_user_likes	boolean	User Likes	☐
formatted_published_date	string	Formatted Published Date	☐
id	int32	ID	☐
instagram_comments_count	int32	Instagram Comments	☐
instagram_facebook_author_id	string	Instagram Facebook Author ID	☐	The Facebook ID of this Instagram post author, used to fetch the profile picture.
instagram_likes_count	int32	Instagram Likes	☐
instagram_post_id	string	Instagram Post ID	☐
instagram_post_link	string	Instagram Post URL	☐
link_description	string	Link Description	☐
link_image_url	string	Link Image URL	☐
link_title	string	Link Title	☐
link_url	string	Link URL	☐
linkedin_author_id	string	LinkedIn author ID	☐
linkedin_author_image_url	string	LinkedIn author image URL	☐
linkedin_author_urn	string	LinkedIn author URN	☐
linkedin_author_vanity_name	string	LinkedIn Vanity Name	☐	Vanity name, used to generate a link to the author
linkedin_comments_count	int32	LinkedIn Comments	☐
linkedin_likes_count	int32	LinkedIn Likes	☐
linkedin_post_urn	string	LinkedIn post URN	☐
media_type	string	Related Social Media	☐	Used to make comparisons when we need to restrict some features to a specific media ('facebook', 'twitter', ...).
message	string	Message	☐
post_link	string	Post Link	☐	Post link to the external social.media (ex: link to the actual Facebook Post).
published_date	datetime	Published date	☐	The post published date based on third party information.
stream_id_label	string		☐
stream_id	string		☐
stream_post_image_ids	string		☐	Images that were shared with this post.
stream_post_image_urls	string	Stream Post Images URLs	☐
twitter_author_id	string	Twitter Author ID	☐
twitter_can_retweet	boolean	Twitter Can Retweet	☐
twitter_comments_count	int32	Twitter Comments	☐
twitter_likes_count	int32	Twitter Likes	☐
twitter_profile_image_url	string	Twitter Profile Image URL	☐
twitter_quoted_tweet_author_link	string	Quoted tweet author Link	☐
twitter_quoted_tweet_author_name	string	Quoted tweet author Name	☐
twitter_quoted_tweet_id_str	string	Twitter Quoted Tweet ID	☐
twitter_quoted_tweet_message	string	Quoted tweet message	☐
twitter_quoted_tweet_profile_image_url	string	Quoted tweet profile image URL	☐
twitter_retweet_count	int32	Re-tweets	☐
twitter_retweeted_tweet_id_str	string	Twitter Retweet ID	☐
twitter_screen_name	string	Twitter Screen Name	☐
twitter_tweet_id	string	Twitter Tweet ID	☐
twitter_user_likes	boolean	Twitter User Likes	☐
write_date	datetime	Last Updated on	☐
write_uid_label	string		☐
write_uid	string		☐
youtube_comments_count	int32	YouTube Comments Count	☐
youtube_dislikes_count	int32	YouTube Dislikes	☐
youtube_likes_count	int32	YouTube Likes	☐
youtube_likes_ratio	int32	YouTube Likes Ratio	☐
youtube_thumbnail_url	string	YouTube Thumbnail Url	☐
youtube_video_id	string	YouTube Video ID	☐
youtube_views_count	int32	YouTube Views	☐

01-03-2023 15:29 Version 22.1.135-BETA+3826

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Odoo API Data Model

stream_post

Table Columns

Important Safety and Usage Information