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

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

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

### Changes of This Table, 26.0 to 27.0

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

##### Discourse.Categories.CategorySettings: type changes

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

<a id="DCE-27.0-D117"></a><a id="DCE-27.0-D118"></a><a id="DCE-27.0-D119"></a><a id="DCE-27.0-D1430"></a><a id="DCE-27.0-D1431"></a><a id="DCE-27.0-D1432"></a><a id="DCE-27.0-D1433"></a><a id="DCE-27.0-D1434"></a><a id="DCE-27.0-D1435"></a><a id="DCE-27.0-D1436"></a><a id="DCE-27.0-D1437"></a><a id="DCE-27.0-D1438"></a><a id="DCE-27.0-D1439"></a><a id="DCE-27.0-D1440"></a>

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

<details>
<summary>

3 more changes

</summary>

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

##### Parameter include_subcategories is added to Discourse.Categories.CategorySettings

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="DCE-27.0-D1441"></a><a id="DCE-27.0-D1442"></a>

- `+` `text_color` (`varchar2`)
- `+` `topic_featured_links_allowed` (`char`)

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

