Discourse Data ModelGet a list of categoriesThe Categories endpoint returns a list of all the categories for your discourse site that you have access to.
Catalog: Discourse
Schema: Categories
Label: Categories
This is a read-only table. The Discourse API may not support changing the data or the Invantive SQL driver for Discourse does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Discourse API.
Select Discourse API URL: /categories.json
Insert Discourse API URL: /categories.json
Update Discourse API URL: /categories.json
Delete Discourse API URL: /categories.json
Field Selection Method: NotRequired
Base Path: category_list.categories[*]
Select Discourse API Operation: get /categories.json
Table Columns
The columns of the table Categories are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
background_url |
string |
Background URL |
☐ |
|
can_create_category |
boolean |
Can Create Category |
☐ |
|
can_create_topic |
boolean |
Can Create Topic |
☐ |
|
can_edit |
boolean |
Can Edit |
☐ |
|
color |
string |
Colour |
☐ |
|
description |
string |
Description |
☐ |
|
description_excerpt |
string |
Description Excerpt |
☐ |
|
description_text |
string |
Description Text |
☐ |
|
draft |
boolean |
Draft |
☐ |
|
draft_key |
string |
Draft Key |
☐ |
|
draft_sequence |
int64 |
Draft Sequence |
☐ |
|
has_children |
boolean |
Has Children |
☐ |
|
id |
int64 |
ID |
☐ |
|
logo_url |
string |
Logo URL |
☐ |
|
name |
string |
Name |
☐ |
|
notification_level |
string |
Notification Level |
☐ |
|
permission |
int64 |
Permission |
☐ |
|
position |
int64 |
Position |
☐ |
|
post_count |
int64 |
#Posts |
☐ |
|
read_restricted |
boolean |
Read Restricted |
☐ |
|
slug |
string |
Slug |
☐ |
|
text_color |
string |
Text Color |
☐ |
|
topic_count |
int64 |
#Topics |
☐ |
|
topic_template |
string |
Topic Template |
☐ |
|
topic_url |
string |
Topic URL |
☐ |
|
topics_all_time |
int64 |
Topics All Time |
☐ |
|
topics_day |
int64 |
Topics Day |
☐ |
|
topics_month |
int64 |
Topics Month |
☐ |
|
topics_week |
int64 |
Topics Week |
☐ |
|
topics_year |
int64 |
Topics Year |
☐ |
|
12-12-2020 18:47 Version 20.1.301-BETA+3023
