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
The folder_view_viewType column for the table Files.
image_height
Int
False
The image_height column for the table Files.
image_width
Int
False
The image_width column for the table Files.
location_altitude
Double
False
The location_altitude column for the table Files.
location_latitude
Double
False
The location_latitude column for the table Files.
location_longitude
Double
False
The location_longitude column for the table Files.
package_type
String
False
The package_type column for the table Files.
pendingOperations_pendingContentUpdate_queuedDateTime
Datetime
False
The pendingOperations_pendingContentUpdate_queuedDateTime column for the table Files.
photo_cameraMake
String
False
The photo_cameraMake column for the table Files.
photo_cameraModel
String
False
The photo_cameraModel column for the table Files.
photo_exposureDenominator
Double
False
The photo_exposureDenominator column for the table Files.
photo_exposureNumerator
Double
False
The photo_exposureNumerator column for the table Files.
photo_fNumber
Double
False
The photo_fNumber column for the table Files.
photo_focalLength
Double
False
The photo_focalLength column for the table Files.
photo_iso
Int
False
The photo_iso column for the table Files.
photo_orientation
Int
False
The photo_orientation column for the table Files.
photo_takenDateTime
Datetime
False
The photo_takenDateTime column for the table Files.
publication_level
String
False
The publication_level column for the table Files.
publication_versionId
String
False
The publication_versionId column for the table Files.
remoteItem_createdBy_application_displayName
String
False
The remoteItem_createdBy_application_displayName column for the table Files.
remoteItem_createdBy_application_id
String
False
The remoteItem_createdBy_application_id column for the table Files.
remoteItem_createdDateTime
Datetime
False
The remoteItem_createdDateTime column for the table Files.
remoteItem_file_hashes_crc32Hash
String
False
The remoteItem_file_hashes_crc32Hash column for the table Files.
remoteItem_file_hashes_quickXorHash
String
False
The remoteItem_file_hashes_quickXorHash column for the table Files.
remoteItem_file_hashes_sha1Hash
String
False
The remoteItem_file_hashes_sha1Hash column for the table Files.
remoteItem_file_hashes_sha256Hash
String
False
The remoteItem_file_hashes_sha256Hash column for the table Files.
remoteItem_file_mimeType
String
False
The remoteItem_file_mimeType column for the table Files.
remoteItem_file_processingMetadata
Bool
False
The remoteItem_file_processingMetadata column for the table Files.
remoteItem_fileSystemInfo_createdDateTime
Datetime
False
The remoteItem_fileSystemInfo_createdDateTime column for the table Files.
remoteItem_fileSystemInfo_lastAccessedDateTime
Datetime
False
The remoteItem_fileSystemInfo_lastAccessedDateTime column for the table Files.
remoteItem_fileSystemInfo_lastModifiedDateTime
Datetime
False
The remoteItem_fileSystemInfo_lastModifiedDateTime column for the table Files.
remoteItem_folder_childCount
Int
False
The remoteItem_folder_childCount column for the table Files.
remoteItem_folder_view_sortBy
String
False
The remoteItem_folder_view_sortBy column for the table Files.
remoteItem_folder_view_sortOrder
String
False
The remoteItem_folder_view_sortOrder column for the table Files.
remoteItem_folder_view_viewType
String
False
The remoteItem_folder_view_viewType column for the table Files.
remoteItem_id
String
False
The remoteItem_id column for the table Files.
remoteItem_image_height
Int
False
The remoteItem_image_height column for the table Files.
remoteItem_image_width
Int
False
The remoteItem_image_width column for the table Files.
remoteItem_lastModifiedDateTime
Datetime
False
The remoteItem_lastModifiedDateTime column for the table Files.
remoteItem_name
String
False
The remoteItem_name column for the table Files.
remoteItem_package_type
String
False
The remoteItem_package_type column for the table Files.
remoteItem_parentReference_driveId
String
False
The remoteItem_parentReference_driveId column for the table Files.
remoteItem_parentReference_driveType
String
False
The remoteItem_parentReference_driveType column for the table Files.
remoteItem_parentReference_id
String
False
The remoteItem_parentReference_id column for the table Files.
remoteItem_parentReference_name
String
False
The remoteItem_parentReference_name column for the table Files.
remoteItem_parentReference_path
String
False
The remoteItem_parentReference_path column for the table Files.
remoteItem_parentReference_shareId
String
False
The remoteItem_parentReference_shareId column for the table Files.
remoteItem_parentReference_sharepointIds_listId
String
False
The remoteItem_parentReference_sharepointIds_listId column for the table Files.
remoteItem_parentReference_sharepointIds_listItemId
String
False
The remoteItem_parentReference_sharepointIds_listItemId column for the table Files.
remoteItem_parentReference_sharepointIds_listItemUniqueId
String
False
The remoteItem_parentReference_sharepointIds_listItemUniqueId column for the table Files.
remoteItem_parentReference_sharepointIds_siteId
String
False
The remoteItem_parentReference_sharepointIds_siteId column for the table Files.
remoteItem_parentReference_sharepointIds_siteUrl
String
False
The remoteItem_parentReference_sharepointIds_siteUrl column for the table Files.
remoteItem_parentReference_sharepointIds_tenantId
String
False
The remoteItem_parentReference_sharepointIds_tenantId column for the table Files.
remoteItem_parentReference_sharepointIds_webId
String
False
The remoteItem_parentReference_sharepointIds_webId column for the table Files.
remoteItem_parentReference_siteId
String
False
The remoteItem_parentReference_siteId column for the table Files.
remoteItem_shared_scope
String
False
The remoteItem_shared_scope column for the table Files.
remoteItem_shared_sharedDateTime
Datetime
False
The remoteItem_shared_sharedDateTime column for the table Files.
remoteItem_size
Long
False
The remoteItem_size column for the table Files.
remoteItem_specialFolder_name
String
False
The remoteItem_specialFolder_name column for the table Files.
remoteItem_video_audioBitsPerSample
Int
False
The remoteItem_video_audioBitsPerSample column for the table Files.
remoteItem_video_audioChannels
Int
False
The remoteItem_video_audioChannels column for the table Files.
remoteItem_video_audioSamplesPerSecond
Int
False
The remoteItem_video_audioSamplesPerSecond column for the table Files.
remoteItem_video_bitrate
Int
False
The remoteItem_video_bitrate column for the table Files.
remoteItem_video_duration
Long
False
The remoteItem_video_duration column for the table Files.
remoteItem_video_fourCC
String
False
The remoteItem_video_fourCC column for the table Files.
remoteItem_video_frameRate
Double
False
The remoteItem_video_frameRate column for the table Files.
remoteItem_video_height
Int
False
The remoteItem_video_height column for the table Files.
remoteItem_video_width
Int
False
The remoteItem_video_width column for the table Files.
remoteItem_webDavUrl
String
False
The remoteItem_webDavUrl column for the table Files.
remoteItem_webUrl
String
False
The remoteItem_webUrl column for the table Files.
searchResult_onClickTelemetryUrl
String
False
The searchResult_onClickTelemetryUrl column for the table Files.
shared_owner_application_displayName
String
False
The shared_owner_application_displayName column for the table Files.
shared_owner_application_id
String
False
The shared_owner_application_id column for the table Files.
shared_scope
String
False
The shared_scope column for the table Files.
shared_sharedDateTime
Datetime
False
The shared_sharedDateTime column for the table Files.
sharepointIds_listId
String
False
The sharepointIds_listId column for the table Files.
sharepointIds_listItemId
String
False
The sharepointIds_listItemId column for the table Files.
sharepointIds_listItemUniqueId
String
False
The sharepointIds_listItemUniqueId column for the table Files.
sharepointIds_siteId
String
False
The sharepointIds_siteId column for the table Files.
sharepointIds_siteUrl
String
False
The sharepointIds_siteUrl column for the table Files.
sharepointIds_tenantId
String
False
The sharepointIds_tenantId column for the table Files.
sharepointIds_webId
String
False
The sharepointIds_webId column for the table Files.
size
Long
False
The size column for the table Files.
specialFolder_name
String
False
The specialFolder_name column for the table Files.
video_audioBitsPerSample
Int
False
The video_audioBitsPerSample column for the table Files.
video_audioChannels
Int
False
The video_audioChannels column for the table Files.
video_audioFormat
String
False
The video_audioFormat column for the table Files.
video_audioSamplesPerSecond
Int
False
The video_audioSamplesPerSecond column for the table Files.
video_bitrate
Int
False
The video_bitrate column for the table Files.
video_duration
Long
False
The video_duration column for the table Files.
video_fourCC
String
False
The video_fourCC column for the table Files.
video_frameRate
Double
False
The video_frameRate column for the table Files.
video_height
Int
False
The video_height column for the table Files.
video_width
Int
False
The video_width column for the table Files.
webDavUrl
String
False
The webDavUrl column for the table Files.
UserId
String
False
The UserId column for the table Files.
Last updated