invantive documentation
Invantive Support ForumsLog In / Sign Up

Posts_Actions_summaryById: Discourse Post Actions Summary by ID

read only REST

  • Catalog: Discourse
  • Schema: Posts
  • Label: Post Actions Summary by ID

Get a single post

Can only retrieve data.

Summary

Get a single post

API Source

  • Endpoint: /posts/{id}.json
  • Operation: get /posts/{id}.json

Performance Characteristics

Characteristic Value
Average access latency (ms) 243
Write rows per minute 219

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table Posts_Actions_summaryById 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
admin char Administrator filters on the platform, writable, ::ancestor.admin
avatar_template varchar2 Avatar Template filters on the platform, writable, ::ancestor.avatar_template
avg_time varchar2 itgen_dce_avg_time writable The JSON text of the nested object.
can_delete char Can Delete filters on the platform, writable, ::ancestor.can_delete
can_edit char Can Edit filters on the platform, writable, ::ancestor.can_edit
can_recover char Can Recover filters on the platform, writable, ::ancestor.can_recover
can_view_edit_history char Can View Edit History filters on the platform, writable, ::ancestor.can_view_edit_history
can_wiki char Can Wikify filters on the platform, writable, ::ancestor.can_wiki
cooked varchar2 Cooked filters on the platform, writable, ::ancestor.cooked
created_at varchar2 Created at filters on the platform, writable, ::ancestor.created_at
deleted_at varchar2 Deleted At writable The JSON text of the nested object.
display_username varchar2 Display User Name filters on the platform, writable, ::ancestor.display_username
edit_reason varchar2 Edit Reason writable The JSON text of the nested object.
hidden char Hidden filters on the platform, writable, ::ancestor.hidden
hidden_reason_id varchar2 itgen_dce_hidden_reason_id writable The JSON text of the nested object.
id decimal ID filters on the platform, writable, ::ancestor.id
incoming_link_count decimal #Incoming Links filters on the platform, writable, ::ancestor.incoming_link_count
moderator char Moderator filters on the platform, writable, ::ancestor.moderator
name varchar2 Name filters on the platform, writable, ::ancestor.name
post_number decimal Post Number filters on the platform, writable, ::ancestor.post_number
post_type decimal Post Type filters on the platform, writable, ::ancestor.post_type
primary_group_flair_bg_color varchar2 itgen_dce_primary_group_flair_bg_color writable The JSON text of the nested object.
primary_group_flair_color varchar2 itgen_dce_primary_group_flair_color writable The JSON text of the nested object.
primary_group_flair_url varchar2 itgen_dce_primary_group_flair_url writable The JSON text of the nested object.
primary_group_name varchar2 Primary Group Name writable The JSON text of the nested object.
quote_count decimal #Quotes filters on the platform, writable, ::ancestor.quote_count
raw varchar2 Raw filters on the platform, writable, ::ancestor.raw
reads decimal #Reads filters on the platform, writable, ::ancestor.reads
reply_count decimal #Replies filters on the platform, writable, ::ancestor.reply_count
reply_to_post_number varchar2 Reply to Post Number writable The JSON text of the nested object.
score decimal Score filters on the platform, writable, ::ancestor.score
staff char Staff filters on the platform, writable, ::ancestor.staff
topic_id decimal Topic ID filters on the platform, writable, ::ancestor.topic_id
topic_slug varchar2 Topic Slug filters on the platform, writable, ::ancestor.topic_slug
trust_level decimal Trust Level filters on the platform, writable, ::ancestor.trust_level
updated_at varchar2 Updated at filters on the platform, writable, ::ancestor.updated_at
user_deleted char User Deleted filters on the platform, writable, ::ancestor.user_deleted
user_id decimal User ID filters on the platform, writable, ::ancestor.user_id
user_title varchar2 User Title writable The JSON text of the nested object.
username varchar2 User Name filters on the platform, writable, ::ancestor.username
version decimal Version filters on the platform, writable, ::ancestor.version
wiki char Wiki filters on the platform, writable, ::ancestor.wiki
yours char Yours filters on the platform, writable, ::ancestor.yours

Release Notes

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

Changes of This Table, 26.0 to 27.0

  • - avg_time
  • - hidden_reason_id
  • ~ id (database_data_type: decimal → int64)
  • ~ id (dotnet_data_type: decimal → int64)
  • ~ incoming_link_count (database_data_type: decimal → int64)
  • ~ incoming_link_count (dotnet_data_type: decimal → int64)
  • ~ post_number (database_data_type: decimal → int64)
  • ~ post_number (dotnet_data_type: decimal → int64)
  • ~ post_type (database_data_type: decimal → int64)
  • ~ post_type (dotnet_data_type: decimal → int64)
  • - primary_group_flair_bg_color
  • - primary_group_flair_color
  • - primary_group_flair_url
  • ~ quote_count (database_data_type: decimal → int64)
  • ~ quote_count (dotnet_data_type: decimal → int64)

30 more changes

  • ~ reads (database_data_type: decimal → int64)
  • ~ reads (dotnet_data_type: decimal → int64)
  • ~ reply_count (database_data_type: decimal → int64)
  • ~ reply_count (dotnet_data_type: decimal → int64)
  • ~ topic_id (database_data_type: decimal → int64)
  • ~ topic_id (dotnet_data_type: decimal → int64)
  • ~ trust_level (database_data_type: decimal → int64)
  • ~ trust_level (dotnet_data_type: decimal → int64)
  • ~ user_id (database_data_type: decimal → int64)
  • ~ user_id (dotnet_data_type: decimal → int64)
  • ~ version (database_data_type: decimal → int64)
  • ~ version (dotnet_data_type: decimal → int64)
  • + acted (char)
  • + bookmarked (char)
  • + can_act (char)
  • + can_see_hidden_post (char)
  • + can_undo (char)
  • + count (int64)
  • + flair_bg_color (varchar2)
  • + flair_color (varchar2)
  • + flair_group_id (int64)
  • + flair_name (varchar2)
  • + flair_url (varchar2)
  • + id_2 (int64)
  • + post_url (varchar2)
  • + posts_count (int64)
  • + readers_count (int64)
  • + reviewable_id (int64)
  • + reviewable_score_count (int64)
  • + reviewable_score_pending_count (int64)

All changes of the driver, 26.0 to 27.0