FileMetadataInstances

Retrieves metadata applied to specific files, showing key-value fields associated with metadata templates.

To select from the File Metadata Instances view, you must specify FileID, or FileID and Scope and Template in the WHERE clause. For example:

SELECT * FROM FileMetadataInstances WHERE FileId = '1723610396614';

Columns


Name	Type	Description
Id	String	A universally unique identifier (UUID) assigned to the metadata instance.
FileId [KEY]	String	Identifier of the file to which the metadata instance is attached.
Template	String	The name of the metadata template applied to the file.
Parent	String	Identifier of the parent item the metadata instance is attached to, formatted as {type}_{id} to combine item type and identifier.
Scope	String	Specifies the scope in which the metadata template is applied. This can be enterprise_{enterprise_id} for enterprise-specific templates or global for templates available across all enterprises.
Version	String	The version number of the metadata instance, starting at 0 and incrementing each time a user-defined property is updated.
CanEdit	String	Indicates whether the current user has permission to edit this metadata instance.
Type	String	The object type identifier for the metadata instance.
TypeVersion	String	The version of the metadata template definition that was last applied to this instance.
UserDefinedFieldName	String	The name of a user-defined field included in the metadata template.
UserDefinedFieldValue	String	The value assigned to a user-defined field in the metadata template.