# ChatMessages: Nextcloud Nextcloud Chat Messages View
- Catalog: `Nextcloud`
- Schema: `Views`
- Label: Nextcloud Chat Messages View
This is a read-only view. 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.
## View Columns
The columns of the view `ChatMessages` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `actorDisplayName` | `varchar2` | | ☐ | |
| `actorId` | `varchar2` | | ☐ | |
| `actorType` | `varchar2` | | ☐ | |
| `deleted` | `char` | | ☐ | |
| `expirationTimestamp` | `int64` | | ☐ | |
| `id` | `int64` | | ☐ | |
| `isReplyable` | `char` | | ☐ | |
| `isThread` | `char` | | ☐ | |
| `lastEditActorDisplayName` | `varchar2` | | ☐ | |
| `lastEditActorId` | `varchar2` | | ☐ | |
| `lastEditActorType` | `varchar2` | | ☐ | |
| `lastEditTimestamp` | `int64` | | ☐ | |
| `markdown` | `char` | | ☐ | |
| `messageParameters` | `varchar2` | | ☐ | The JSON text of the nested object. |
| `messageType` | `varchar2` | | ☐ | |
| `message` | `varchar2` | | ☐ | |
| `metaData_pinnedActorDisplayName` | `varchar2` | | ☐ | Display name of the attendee that pinned the message - Required capability: `pinned-messages` |
| `metaData_pinnedActorId` | `varchar2` | | ☐ | Actor ID of the attendee that pinned the message - Required capability: `pinned-messages` |
| `metaData_pinnedActorType` | `varchar2` | | ☐ | Actor type of the attendee that pinned the message - Required capability: `pinned-messages` |
| `metaData_pinnedAt` | `int64` | | ☐ | Timestamp when the message was pinned - Required capability: `pinned-messages` |
| `metaData_pinnedUntil` | `int64` | | ☐ | Timestamp until when the message is pinned. If missing the message is pinned infinitely - Required capability: `pinned-messages` |
| `metaData_threadId` | `int64` | | ☐ | Set when a thread is created with this message. If missing, no thread creation is associated with this message |
| `metaData_threadTitle` | `varchar2` | | ☐ | Set when a thread is created with this message. If missing, no thread creation is associated with this message |
| `reactions` | `varchar2` | | ☐ | The JSON text of the nested object. |
| `referenceId` | `varchar2` | | ☐ | |
| `silent` | `char` | | ☐ | |
| `systemMessage` | `varchar2` | | ☐ | |
| `threadId` | `int64` | | ☐ | |
| `threadReplies` | `int64` | | ☐ | |
| `threadTitle` | `varchar2` | | ☐ | |
| `timestamp` | `int64` | | ☐ | |
| `token2` | `varchar2` | | ☐ | |
| `token` | `varchar2` | | ☐ | Token identifier of the conversation which is used for further interaction |