---
title: "stream_post (Odoo)"
description: "itgen_odoo_stream_post"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.social.stream_post
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.social.stream_post
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# stream_post: Odoo itgen_odoo_stream_post

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `social`
- Label: itgen_odoo_stream_post

Social Stream Post

Can only retrieve data.

## Summary

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.

## Table Columns

The columns of the table `stream_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_id` | `varchar2` |  | [ ] |  |  |
| `account_id_label` | `varchar2` |  | [ ] |  |  |
| `author_link` | `varchar2` | Author Link | [ ] |  | Author link to the external social.media (ex: link to the Twitter Account). |
| `author_name` | `varchar2` | Author Name | [ ] |  | The post author name based on third party information (ex: 'John Doe'). |
| `company_id` | `varchar2` |  | [ ] |  | Link an account to a company to restrict its usage or keep empty to let all companies use it. |
| `company_id_label` | `varchar2` |  | [ ] |  | 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` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `facebook_author_id` | `varchar2` | Facebook Author ID | [ ] |  |  |
| `facebook_comments_count` | `int32` | Comments | [ ] |  |  |
| `facebook_is_event_post` | `boolean` | Is event post | [ ] |  |  |
| `facebook_likes_count` | `int32` | Likes | [ ] |  |  |
| `facebook_post_id` | `varchar2` | Facebook Post ID | [ ] |  |  |
| `facebook_reach` | `int32` | Reach | [ ] |  |  |
| `facebook_shares_count` | `int32` | Shares | [ ] |  |  |
| `facebook_user_likes` | `boolean` | User Likes | [ ] |  |  |
| `formatted_published_date` | `varchar2` | Formatted Published Date | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `instagram_comments_count` | `int32` | Instagram Comments | [ ] |  |  |
| `instagram_facebook_author_id` | `varchar2` | 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` | `varchar2` | Instagram Post ID | [ ] |  |  |
| `instagram_post_link` | `varchar2` | Instagram Post URL | [ ] |  |  |
| `link_description` | `varchar2` | Link Description | [ ] |  |  |
| `link_image_url` | `varchar2` | Link Image URL | [ ] |  |  |
| `link_title` | `varchar2` | Link Title | [ ] |  |  |
| `link_url` | `varchar2` | Link URL | [ ] |  |  |
| `linkedin_author_id` | `varchar2` | LinkedIn author ID | [ ] |  |  |
| `linkedin_author_image_url` | `varchar2` | LinkedIn author image URL | [ ] |  |  |
| `linkedin_author_urn` | `varchar2` | LinkedIn author URN | [ ] |  |  |
| `linkedin_author_vanity_name` | `varchar2` | 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` | `varchar2` | LinkedIn post URN | [ ] |  |  |
| `media_type` | `varchar2` | Related Social Media | [ ] |  | Used to make comparisons when we need to restrict some features to a specific media ('facebook', 'twitter', ...). |
| `message` | `varchar2` | Message | [ ] |  |  |
| `post_link` | `varchar2` | 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` | `varchar2` |  | [ ] |  |  |
| `stream_id_label` | `varchar2` |  | [ ] |  |  |
| `stream_post_image_ids` | `varchar2` |  | [ ] |  | Images that were shared with this post. |
| `stream_post_image_urls` | `varchar2` | Stream Post Images URLs | [ ] |  |  |
| `twitter_author_id` | `varchar2` | 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` | `varchar2` | Twitter Profile Image URL | [ ] |  |  |
| `twitter_quoted_tweet_author_link` | `varchar2` | Quoted tweet author Link | [ ] |  |  |
| `twitter_quoted_tweet_author_name` | `varchar2` | Quoted tweet author Name | [ ] |  |  |
| `twitter_quoted_tweet_id_str` | `varchar2` | Twitter Quoted Tweet ID | [ ] |  |  |
| `twitter_quoted_tweet_message` | `varchar2` | Quoted tweet message | [ ] |  |  |
| `twitter_quoted_tweet_profile_image_url` | `varchar2` | Quoted tweet profile image URL | [ ] |  |  |
| `twitter_retweet_count` | `int32` | Re-tweets | [ ] |  |  |
| `twitter_retweeted_tweet_id_str` | `varchar2` | Twitter Retweet ID | [ ] |  |  |
| `twitter_screen_name` | `varchar2` | Twitter Screen Name | [ ] |  |  |
| `twitter_tweet_id` | `varchar2` | Twitter Tweet ID | [ ] |  |  |
| `twitter_user_likes` | `boolean` | Twitter User Likes | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |
| `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` | `varchar2` | YouTube Thumbnail Url | [ ] |  |  |
| `youtube_video_id` | `varchar2` | YouTube Video ID | [ ] |  |  |
| `youtube_views_count` | `int32` | YouTube Views | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

