DirectoryItems_Directory_items: Discourse Directory Item Entries
read only REST
- Catalog:
Discourse - Schema:
Users - Label: Directory Item Entries
Get a public list of users
Can only retrieve data.
Summary
Get a public list of users
API Source
- Endpoint:
/directory_items.json?period={period} - Operation:
get /directory_items.json?period={period}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 243 |
| Write rows per minute | 219 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
asc |
`` | Values: True. | ||
order |
`` | Values: likes_received, likes_given, topic_count, post_count, topics_entered, posts_read, days_visited. | ||
period |
`` | Values: daily, weekly, monthly, quarterly, yearly, all. |
Table Columns
The columns of the table DirectoryItems_Directory_items 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 |
|---|---|---|---|---|---|
days_ |
decimal |
Days Visited | writable, days_ |
||
id |
decimal |
ID | writable, id |
||
likes_ |
decimal |
Likes Given | writable, likes_ |
||
likes_ |
decimal |
Likes Received | writable, likes_ |
||
load_ |
varchar2 |
Load More Directory Items | filters on the platform, writable, ::ancestor. |
||
post_ |
decimal |
#Posts | writable, post_ |
||
posts_ |
decimal |
Posts Read | writable, posts_ |
||
topic_ |
decimal |
#Topics | writable, topic_ |
||
topics_ |
decimal |
Topics Entered | writable, topics_ |
||
total_ |
decimal |
Total Rows Directory Items | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Avatar Template | writable, user. |
||
user_ |
decimal |
User ID | writable, user. |
||
user_ |
varchar2 |
User Name | writable, user. |
||
user_ |
varchar2 |
User Title | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Name | writable, user. |
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
~days_visited(database_data_type:decimal→int64)~days_visited(dotnet_data_type:decimal→int64)~id(database_data_type:decimal→int64)~id(dotnet_data_type:decimal→int64)~likes_given(database_data_type:decimal→int64)~likes_given(dotnet_data_type:decimal→int64)~likes_received(database_data_type:decimal→int64)~likes_received(dotnet_data_type:decimal→int64)-load_more_directory_items~post_count(database_data_type:decimal→int64)~post_count(dotnet_data_type:decimal→int64)~posts_read(database_data_type:decimal→int64)~posts_read(dotnet_data_type:decimal→int64)~topic_count(database_data_type:decimal→int64)~topic_count(dotnet_data_type:decimal→int64)
10 more changes
Parameter asc of Discourse.Users.DirectoryItems_Directory_items: dotnet data type changes
Dotnet data type changes from boolean to string.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
boolean→string- importance 3
Parameter order of Discourse.Users.DirectoryItems_Directory_items: presence required changes
Presence required changes from false to true.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
false→true- importance 3
~topics_entered(database_data_type:decimal→int64)~topics_entered(dotnet_data_type:decimal→int64)-total_rows_directory_items~user_id(database_data_type:decimal→int64)~user_id(dotnet_data_type:decimal→int64)+meta_last_updated_at(varchar2)+meta_load_more_directory_items(varchar2)+meta_total_rows_directory_items(int64)