invantive documentation
Invantive Support ForumsLog In / Sign Up

CategorySettings: Discourse Category Settings

insert REST

  • Catalog: Discourse
  • Schema: Categories
  • Label: Category Settings

Get a list of categories The Categories endpoint returns a list of all the categories for your discourse site that you have access to.

Can retrieve data and change data using insert.

Summary

The Categories endpoint returns a list of all the categories for your discourse site that you have access to.

API Source

  • Endpoint: /categories.json
  • Operation: get /categories.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 CategorySettings 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
can_create_category char Can Create Category filters on the platform, writable, can_create_category
can_create_topic char Can Create Topic filters on the platform, writable, can_create_topic
draft char Draft filters on the platform, writable, draft
draft_key varchar2 Draft Key filters on the platform, writable, draft_key
draft_sequence int64 Draft Sequence filters on the platform, writable, draft_sequence

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.Categories.CategorySettings: type changes

Type of Discourse.Categories.CategorySettings 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

  • - draft
  • - draft_key
  • - draft_sequence
  • + allow_badges (char)
  • + color (varchar2)
  • + emoji (varchar2)
  • + icon (varchar2)
  • + name (varchar2)
  • + parent_category_id (int32)
  • + permissions_everyone (int32)
  • + permissions_staff (int32)
  • + search_priority (int32)
  • + slug (varchar2)
  • + style_type (varchar2)

3 more changes

Parameter include_subcategories is added to Discourse.Categories.CategorySettings

Optional.

  • importance 2

  • + text_color (varchar2)
  • + topic_featured_links_allowed (char)

All changes of the driver, 26.0 to 27.0