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.