# Shares: Nextcloud Nextcloud Shares ## Documentation Shares of the connected account, one row per share. Writable: insert creates a share, update changes one or more fields in a single request, delete removes the share. - Catalog: `Nextcloud` - Schema: `Nextcloud` - Primary Keys: `share_id` - Label: Nextcloud Shares Can retrieve data and change data using insert, update and delete. ## Columns of Table Function The columns of the table function `Shares` 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 | Documentation | |---|:---:|---|:---:|---| | `can_delete` | `char` | | ☐ | Whether the connected account may remove the share. | | `can_edit` | `char` | | ☐ | Whether the connected account may change the share. | | `displayname_owner` | `varchar2` | | ☐ | Display name of uid_owner. | | `expiration` | `varchar2` | | ☐ | Expiry date of the share, where one is set. | | `hide_download` | `char` | | ☐ | Whether downloading through a public link is hidden. | | `item_size` | `int64` | | ☐ | Size of the shared item in bytes. | | `item_type` | `varchar2` | | ☐ | Whether the shared item is a file or a folder. | | `label` | `varchar2` | | ☐ | Label of a public link or email share. | | `mimetype` | `varchar2` | | ☐ | MIME type of the shared item; empty for a folder. | | `note` | `varchar2` | | ☐ | Note attached to the share. | | `password` | `varchar2` | | ☐ | Password of a public link share. Write-only: never answered on a read, accepted on insert and on update. | | `path` | `varchar2` | | ☐ | Path of the shared file or folder, relative to the account's own files. Required on insert. | | `permissions` | `int32` | | ☐ | Permission bitmask of the share. | | `share_date` | `datetime` | | ☐ | Moment the share was created (UTC). | | `share_id` | `varchar2` | | ☑ | Identifier of the share. Required to update or delete; never a value either writes. | | `share_type` | `int32` | | ☑ | Type of share: 0 user, 1 group, 3 public link, 4 email, 6 federated, 7 circle, 10 room, others per the platform's own registry. Required on insert. | | `share_with_displayname` | `varchar2` | | ☐ | Display name of share_with. | | `share_with` | `varchar2` | | ☐ | Login name, group or address the share is with; empty for a public link. | | `token` | `varchar2` | | ☐ | Token of a public link share; empty for any other share type. | | `uid_owner` | `varchar2` | | ☐ | Login name of the account the shared item belongs to. | | `url` | `varchar2` | | ☐ | Public URL of a public link share; empty for any other share type. |