# Activities: Nextcloud Nextcloud Activities ## Documentation Activity feed of the connected account, one row per activity, most recent first. Reads the page Nextcloud answers by default and no further. - Catalog: `Nextcloud` - Schema: `Nextcloud` - Primary Keys: `activity_id` - Label: Nextcloud Activities This is a read-only table function. The Nextcloud API may not support changing the data or the Invantive UniversalSQL driver for Nextcloud does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Nextcloud API. ## Columns of Table Function The columns of the table function `Activities` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activity_date` | `datetime` | | ☐ | Moment the activity occurred (UTC). | | `activity_id` | `int64` | | ☑ | Identifier of the activity. | | `activity_type` | `varchar2` | | ☐ | Type of the activity within its application. | | `app` | `varchar2` | | ☐ | Application the activity originated from. | | `icon` | `varchar2` | | ☐ | URL of the icon shown beside the activity. | | `link` | `varchar2` | | ☐ | Link the activity points to. | | `message_rich` | `varchar2` | | ☐ | Message with rich-text placeholders, as JSON: a template plus the objects to substitute into it. The shape differs per activity type. | | `message` | `varchar2` | | ☐ | Plain-text message body; empty for most activity types. | | `object_id` | `int64` | | ☐ | Identifier of the object the activity is about. | | `object_name` | `varchar2` | | ☐ | Name of the object the activity is about, such as a file path. | | `object_type` | `varchar2` | | ☐ | Type of the object the activity is about. | | `objects` | `varchar2` | | ☐ | Every object the activity touched, identifier to name, as JSON. Which identifiers appear differs per activity. | | `subject_rich` | `varchar2` | | ☐ | Subject with rich-text placeholders, as JSON: a template plus the objects to substitute into it. The shape differs per activity type. | | `subject` | `varchar2` | | ☐ | Plain-text subject, in the connected account's own language. | | `user` | `varchar2` | | ☐ | Login name of the account the activity is shown to. |