---
title: "Posts_Actions_summaryById (Discourse)"
description: "Post Actions Summary by ID"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Posts.Posts_Actions_summaryById
original: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Posts.Posts_Actions_summaryById
updated: 2026-11-01T16:08:49Z
license: https://documentation.invantive.eu/en/
---

# 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` | `` | [x] |  |  |

## 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:

- [Discourse](/en/release-notes/drivers?driver=discourse)

### Changes of This Table, 26.0 to 27.0

<a id="DCE-27.0-D276"></a><a id="DCE-27.0-D277"></a><a id="DCE-27.0-D278"></a><a id="DCE-27.0-D279"></a><a id="DCE-27.0-D280"></a><a id="DCE-27.0-D281"></a><a id="DCE-27.0-D282"></a><a id="DCE-27.0-D283"></a><a id="DCE-27.0-D284"></a><a id="DCE-27.0-D285"></a><a id="DCE-27.0-D286"></a><a id="DCE-27.0-D287"></a><a id="DCE-27.0-D288"></a><a id="DCE-27.0-D289"></a><a id="DCE-27.0-D290"></a>

- `-` `avg_time`
- `-` `hidden_reason_id`
- `~` `id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `incoming_link_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `incoming_link_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `post_number` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `post_number` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `post_type` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `post_type` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `-` `primary_group_flair_bg_color`
- `-` `primary_group_flair_color`
- `-` `primary_group_flair_url`
- `~` `quote_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `quote_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)

<details>
<summary>

30 more changes

</summary>

<a id="DCE-27.0-D291"></a><a id="DCE-27.0-D292"></a><a id="DCE-27.0-D293"></a><a id="DCE-27.0-D294"></a><a id="DCE-27.0-D295"></a><a id="DCE-27.0-D296"></a><a id="DCE-27.0-D297"></a><a id="DCE-27.0-D298"></a><a id="DCE-27.0-D299"></a><a id="DCE-27.0-D300"></a><a id="DCE-27.0-D301"></a><a id="DCE-27.0-D302"></a><a id="DCE-27.0-D1505"></a><a id="DCE-27.0-D1506"></a><a id="DCE-27.0-D1507"></a><a id="DCE-27.0-D1508"></a><a id="DCE-27.0-D1509"></a><a id="DCE-27.0-D1510"></a><a id="DCE-27.0-D1511"></a><a id="DCE-27.0-D1512"></a><a id="DCE-27.0-D1513"></a><a id="DCE-27.0-D1514"></a><a id="DCE-27.0-D1515"></a><a id="DCE-27.0-D1516"></a><a id="DCE-27.0-D1517"></a><a id="DCE-27.0-D1518"></a><a id="DCE-27.0-D1519"></a><a id="DCE-27.0-D1520"></a><a id="DCE-27.0-D1521"></a><a id="DCE-27.0-D1522"></a>

- `~` `reads` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `reads` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `reply_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `reply_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `topic_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `topic_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `trust_level` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `trust_level` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `user_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `user_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `version` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `version` (`dotnet_data_type`: `decimal` &rarr; `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`)

</details>

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)

