invantive documentation
Invantive Support ForumsLog In / Sign Up

UserActions: Discourse User Actions

read only REST

  • Catalog: Discourse
  • Schema: Users
  • Label: User Actions

Get a list of user actions

Can only retrieve data.

Summary

Get a list of user actions

API Source

  • Endpoint: /user_actions.json
  • Operation: get /user_actions.json

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
filter ``
offset ``
username ``

Table Columns

The columns of the table UserActions 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
acting_avatar_template varchar2 Acting Avatar Template filters on the platform, writable, acting_avatar_template
acting_name varchar2 Acting Name filters on the platform, writable, acting_name
acting_user_id int64 Acting User ID filters on the platform, writable, acting_user_id
acting_username varchar2 Acting User Name filters on the platform, writable, acting_username
action_code varchar2 Action Code writable The JSON text of the nested object.
action_type int64 Action Type filters on the platform, writable, action_type
archived char Archived filters on the platform, writable, archived
avatar_template varchar2 Avatar Template filters on the platform, writable, avatar_template
category_id int64 Category ID filters on the platform, writable, category_id
closed char Closed filters on the platform, writable, closed
created_at varchar2 Created at filters on the platform, writable, created_at
delete char Delete filters on the platform, writable, delete
exerpt varchar2 Exerpt filters on the platform, writable, exerpt
hidden char Hidden filters on the platform, writable, hidden
name varchar2 Name filters on the platform, writable, name
post_id int64 Post ID filters on the platform, writable, post_id
slug varchar2 Slug filters on the platform, writable, slug
target_name varchar2 Target Name filters on the platform, writable, target_name
target_user_id varchar2 Target User ID filters on the platform, writable, target_user_id
target_username varchar2 Target User Name filters on the platform, writable, target_username
title varchar2 Title filters on the platform, writable, title
topic_id int64 Topic ID filters on the platform, writable, topic_id
user_id int64 User ID filters on the platform, writable, user_id
username varchar2 User Name filters on the platform, writable, username

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

Parameter offset of Discourse.Users.UserActions: dotnet data type changes

Dotnet data type changes from string to int64.

What to Do

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

  • can break a statement
  • string → int64
  • importance 3

  • - delete
  • - exerpt
  • ~ hidden (database_data_type: char → varchar2)
  • ~ hidden (dotnet_data_type: boolean → string)
  • ~ post_id (database_data_type: int64 → varchar2)
  • ~ post_id (dotnet_data_type: int64 → string)
  • ~ target_user_id (database_data_type: varchar2 → int64)
  • ~ target_user_id (dotnet_data_type: string → int64)
  • + deleted (char)
  • + excerpt (varchar2)
  • + post_number (int64)
  • + post_type (varchar2)

All changes of the driver, 26.0 to 27.0