SharedLinkMetadata
Retrieves metadata about a shared link, such as link visibility, expiration date, and associated resource details.
Select
To query the Shared Link Metadata view, Url must be specified in the WHERE clause. For example:
SELECT * FROM SharedLinkMetadata WHERE Url = 'https://www.dropbox.com/scl/fo/fdc98vi57mlxv7wt6suc7/AI7kXKLxhDUJIx04RfDqvTQ?rlkey=cjafltizui04c28w1t4n0in4f&st=z0t9vo0v&dl=0';
Columns
| Name | Type | Description |
| Type | String | The type of the linked entry: file or folder. |
| ClientModified | Timestamp | The timestamp when the file was last modified by the desktop client before being uploaded to Dropbox. |
| Id | String | A unique identifier for the file or folder referenced by the shared link. |
| AllowComments | Boolean | Indicates whether comments are allowed on the shared link. |
| AllowDownload | Boolean | Indicates whether users can download the file or folder from the shared link. |
| AudienceOptions | String | Specifies the audience settings that determine who can access the shared link. |
| CanAllowDownload | Boolean | Indicates whether download permission can be enabled for the shared link. |
| CanDisallowDownload | Boolean | Indicates whether download permission can be disabled for the shared link. |
| CanRemoveExpiry | Boolean | Indicates whether the expiration date on the shared link can be removed. |
| CanRemovePassword | Boolean | Indicates whether password protection can be removed from the shared link. |
| CanRevoke | Boolean | Indicates whether the shared link can be revoked by the user. |
| CanSetExpiry | Boolean | Indicates whether an expiration date can be set on the shared link. |
| CanSetPassword | Boolean | Indicates whether a password can be set for the shared link. |
| RequirePassword | Boolean | Indicates whether a password is required to access the shared link. |
| ResolvedVisibility | String | The final visibility setting of the link after applying all folder and team-level sharing policies. |
| RevokeFailureReason | String | The reason the link cannot be revoked, if applicable. |
| TeamRestrictsComments | Boolean | Indicates whether the team has restricted commenting on shared links. |
| VisibilityPolicies | String | Details the visibility policies that govern how the link can be shared. |
| Name | String | The name of the file or folder associated with the shared link. |
| PathLower | String | The full Dropbox path of the file or folder, in lowercase format. |
| Rev | String | The revision identifier for the file, used to track changes over time. |
| ServerModified | Timestamp | The timestamp when the file was last modified on Dropbox servers. |
| Size | String | The size of the file in bytes. |
| OwnerDisplayName | String | The display name of the user who owns the file or folder. |
| OwnerMemberId | String | The member Id of the file or folder owner. |
| OwnerTeamId | String | The unique Id of the team that owns the file or folder. |
| OwnerTeamName | String | The name of the team that owns the file or folder. |
| Url [KEY] | String | The URL of the shared link. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Password | String | The password protecting the shared link, if one is set. |