# PendingShares
Get all shares that are still pending
- Catalog: `FilesSharing`
- Schema: `FilesSharing`
- Retrieve: True
- Insert: True
- Update: False
- Delete: False
## Table Columns
The columns of the table `PendingShares` 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.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `attributes` | `varchar2` | | ☐ | |
| `can_delete` | `char` | | ☐ | |
| `can_edit` | `char` | | ☐ | |
| `displayname_file_owner` | `varchar2` | | ☐ | |
| `displayname_owner` | `varchar2` | | ☐ | |
| `expiration` | `varchar2` | | ☐ | |
| `file_parent` | `int64` | | ☐ | |
| `file_source` | `int64` | | ☐ | |
| `file_target` | `varchar2` | | ☐ | |
| `has_preview` | `char` | | ☐ | |
| `hide_download` | `int64` | | ☐ | |
| `id` | `varchar2` | | ☐ | |
| `is_mount_root` | `char` | | ☐ | |
| `is_trusted_server` | `char` | | ☐ | |
| `item_mtime` | `int64` | | ☐ | |
| `item_permissions` | `int64` | | ☐ | |
| `item_source` | `int64` | | ☐ | |
| `item_type` | `varchar2` | | ☐ | |
| `label` | `varchar2` | | ☐ | |
| `mail_send` | `int64` | | ☐ | |
| `mimetype` | `varchar2` | | ☐ | |
| `mount_type` | `varchar2` | | ☐ | |
| `note` | `varchar2` | | ☐ | |
| `password_expiration_time` | `varchar2` | | ☐ | |
| `password` | `varchar2` | | ☐ | |
| `path` | `varchar2` | | ☐ | |
| `permissions` | `int64` | | ☐ | |
| `send_password_by_talk` | `char` | | ☐ | |
| `share_type` | `int64` | | ☐ | |
| `share_with_avatar` | `varchar2` | | ☐ | |
| `share_with_displayname_unique` | `varchar2` | | ☐ | |
| `share_with_displayname` | `varchar2` | | ☐ | |
| `share_with_link` | `varchar2` | | ☐ | |
| `share_with` | `varchar2` | | ☐ | |
| `status_clearAt` | `int64` | | ☐ | |
| `status_icon` | `varchar2` | | ☐ | |
| `status_message` | `varchar2` | | ☐ | |
| `status_status` | `varchar2` | | ☐ | |
| `stime` | `int64` | | ☐ | |
| `storage_id` | `varchar2` | | ☐ | |
| `storage` | `int64` | | ☐ | |
| `token` | `varchar2` | | ☐ | |
| `uid_file_owner` | `varchar2` | | ☐ | |
| `uid_owner` | `varchar2` | | ☐ | |
| `url` | `varchar2` | | ☐ | |