---
title: "Top_Users (Discourse)"
description: "Top Users"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Topics.Top_Users
original: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Topics.Top_Users
updated: 2026-11-01T16:08:49Z
license: https://documentation.invantive.eu/en/
---

# Top_Users: Discourse Top Users

`read only` `REST`

- Catalog: `Discourse`
- Schema: `Topics`
- Label: Top Users

Get the top topics

Can only retrieve data.

## Summary

Get the top topics

## API Source

- Endpoint: `/top.json`
- Operation: `get /top.json`

## Performance Characteristics

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

The result can be cached on the client.

## Table Columns

The columns of the table `Top_Users` 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, `admin` |  |
| `avatar_template` | `varchar2` | Avatar Template | [ ] | writable, `avatar_template` |  |
| `id` | `decimal` | ID | [ ] | writable, `id` |  |
| `moderator` | `char` | Moderator | [ ] | filters on the platform, writable, `moderator` |  |
| `topic_list_can_create_topic` | `char` | Topic List Can Create Topic | [ ] | filters on the platform, writable, `::ancestor.topic_list.can_create_topic` |  |
| `topic_list_draft` | `varchar2` | Topic List Draft | [ ] | writable | The JSON text of the nested object. |
| `topic_list_draft_key` | `varchar2` | Topic List Draft Key | [ ] | filters on the platform, writable, `::ancestor.topic_list.draft_key` |  |
| `topic_list_draft_sequence` | `decimal` | Topic List Draft Sequence | [ ] | filters on the platform, writable, `::ancestor.topic_list.draft_sequence` |  |
| `topic_list_for_period` | `varchar2` | Topic List for Period | [ ] | filters on the platform, writable, `::ancestor.topic_list.for_period` |  |
| `topic_list_per_page` | `decimal` | Topic List Per Page | [ ] | filters on the platform, writable, `::ancestor.topic_list.per_page` |  |
| `trust_level` | `int32` | Trust Level | [ ] | filters on the platform, writable, `trust_level` |  |
| `username` | `varchar2` | User Name | [ ] | writable, `username` |  |

## Referenced By

- [Top_Topic_listTopics](Discourse.Topics.Top_Topic_listTopics) `last_poster_username` (Candidate)
- [Top_Topic_listTopicsPosters](Discourse.Topics.Top_Topic_listTopicsPosters) `user_id` (Key)



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

<div class="rn-item" id="DCE-27.0-D1081">

##### Discourse.Topics.Top_Users: type changes

Type of Discourse.Topics.Top_Users changes from table to tablefunction.

<div class="rn-action">

**What to Do**

Check statements, views and scripts that use it before the upgrade.

</div>

<div class="rn-chips">

- **can break a statement**
- `table` &rarr; `tablefunction`
- importance 3

</div>

</div>

<div class="rn-item" id="DCE-27.0-D2389">

##### Parameter per_page is added to Discourse.Topics.Top_Users

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="DCE-27.0-D2390">

##### Parameter period is added to Discourse.Topics.Top_Users

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="DCE-27.0-D602"></a><a id="DCE-27.0-D603"></a><a id="DCE-27.0-D604"></a><a id="DCE-27.0-D605"></a><a id="DCE-27.0-D606"></a><a id="DCE-27.0-D607"></a><a id="DCE-27.0-D1598"></a>

- `~` `id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `topic_list_draft_sequence` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `topic_list_draft_sequence` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `topic_list_per_page` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `topic_list_per_page` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `+` `name` (`varchar2`)

[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)

