Files
Columns
Name
Type
ReadOnly
References
Description
id [KEY]
String
True
The id column for the table Files.
Etag
String
False
The Etag column for the table Files.
createdBy_application_displayName
String
False
The createdBy_application_displayName column for the table Files.
createdBy_application_id
String
False
The createdBy_application_id column for the table Files.
createdDateTime
Datetime
False
The createdDateTime column for the table Files.
description
String
False
The description column for the table Files.
lastModifiedBy_application_displayName
String
False
The lastModifiedBy_application_displayName column for the table Files.
lastModifiedBy_application_id
String
False
The lastModifiedBy_application_id column for the table Files.
lastModifiedDateTime
Datetime
False
The lastModifiedDateTime column for the table Files.
name
String
False
The name column for the table Files.
parentReference_driveId
String
False
The parentReference_driveId column for the table Files.
parentReference_driveType
String
False
The parentReference_driveType column for the table Files.
parentReference_id
String
False
The parentReference_id column for the table Files.
parentReference_name
String
False
The parentReference_name column for the table Files.
parentReference_path
String
False
The parentReference_path column for the table Files.
parentReference_shareId
String
False
The parentReference_shareId column for the table Files.
parentReference_sharepointIds_listId
String
False
The parentReference_sharepointIds_listId column for the table Files.
parentReference_sharepointIds_listItemId
String
False
The parentReference_sharepointIds_listItemId column for the table Files.
parentReference_sharepointIds_listItemUniqueId
String
False
The parentReference_sharepointIds_listItemUniqueId column for the table Files.
parentReference_sharepointIds_siteId
String
False
The parentReference_sharepointIds_siteId column for the table Files.
parentReference_sharepointIds_siteUrl
String
False
The parentReference_sharepointIds_siteUrl column for the table Files.
parentReference_sharepointIds_tenantId
String
False
The parentReference_sharepointIds_tenantId column for the table Files.
parentReference_sharepointIds_webId
String
False
The parentReference_sharepointIds_webId column for the table Files.
parentReference_siteId
String
False
The parentReference_siteId column for the table Files.
webUrl
String
False
The webUrl column for the table Files.
audio_album
String
False
The audio_album column for the table Files.
audio_albumArtist
String
False
The audio_albumArtist column for the table Files.
audio_artist
String
False
The audio_artist column for the table Files.
audio_bitrate
Long
False
The audio_bitrate column for the table Files.
audio_composers
String
False
The audio_composers column for the table Files.
audio_copyright
String
False
The audio_copyright column for the table Files.
audio_disc
Int
False
The audio_disc column for the table Files.
audio_discCount
Int
False
The audio_discCount column for the table Files.
audio_duration
Long
False
The audio_duration column for the table Files.
audio_genre
String
False
The audio_genre column for the table Files.
audio_hasDrm
Bool
False
The audio_hasDrm column for the table Files.
audio_isVariableBitrate
Bool
False
The audio_isVariableBitrate column for the table Files.
audio_title
String
False
The audio_title column for the table Files.
audio_track
Int
False
The audio_track column for the table Files.
audio_trackCount
Int
False
The audio_trackCount column for the table Files.
audio_year
Int
False
The audio_year column for the table Files.
content
String
False
The content column for the table Files.
cTag
String
False
The cTag column for the table Files.
deleted_state
String
False
The deleted_state column for the table Files.
file_hashes_crc32Hash
String
False
The file_hashes_crc32Hash column for the table Files.
file_hashes_quickXorHash
String
False
The file_hashes_quickXorHash column for the table Files.
file_hashes_sha1Hash
String
False
The file_hashes_sha1Hash column for the table Files.
file_hashes_sha256Hash
String
False
The file_hashes_sha256Hash column for the table Files.
file_mimeType
String
False
The file_mimeType column for the table Files.
file_processingMetadata
Bool
False
The file_processingMetadata column for the table Files.
fileSystemInfo_createdDateTime
Datetime
False
The fileSystemInfo_createdDateTime column for the table Files.
fileSystemInfo_lastAccessedDateTime
Datetime
False
The fileSystemInfo_lastAccessedDateTime column for the table Files.
fileSystemInfo_lastModifiedDateTime
Datetime
False
The fileSystemInfo_lastModifiedDateTime column for the table Files.
folder_childCount
Int
False
The folder_childCount column for the table Files.
folder_view_sortBy
String
False
The folder_view_sortBy column for the table Files.
folder_view_sortOrder
String
False
The folder_view_sortOrder column for the table Files.
folder_view_viewType
String
False