invantive documentation
Invantive Support ForumsLog In / Sign Up

Top: Discourse Top

read only REST

  • Catalog: Discourse
  • Schema: Topics
  • Label: Top

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 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
topic_list_can_create_topic char Topic List Can Create Topic filters on the platform, writable, 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, topic_list.draft_key
topic_list_draft_sequence decimal Topic List Draft Sequence filters on the platform, writable, topic_list.draft_sequence
topic_list_for_period varchar2 Topic List for Period filters on the platform, writable, topic_list.for_period
topic_list_more_topics_url varchar2 Topic List More Topics URL filters on the platform, writable, topic_list.more_topics_url
topic_list_per_page decimal Topic List Per Page filters on the platform, writable, topic_list.per_page

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

Discourse.Topics.Top: type changes

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

What to Do

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

  • can break a statement
  • table → tablefunction
  • importance 3
Parameter per_page is added to Discourse.Topics.Top

Optional.

  • importance 2
Parameter period is added to Discourse.Topics.Top

Optional.

  • importance 2

  • ~ topic_list_draft_sequence (database_data_type: decimal → int64)
  • ~ topic_list_draft_sequence (dotnet_data_type: decimal → int64)
  • ~ topic_list_per_page (database_data_type: decimal → int64)
  • ~ topic_list_per_page (dotnet_data_type: decimal → int64)

All changes of the driver, 26.0 to 27.0