Files

The Office365 table Files.

テーブル固有の情報

Select

例えばUserId やFile Id (Id) を使ってファイルを取得したり、単純に特定のカラムでフィルタしたりします。

SELECT * FROM Files WHERE UserId = 'MyUserId'

SELECT Name, LastModifiedDateTime FROM Files WHERE Name LIKE 'test%'

フォルダレベルのファイルに対応するには、クエリでparentReference_path を指定する必要があります。

 
SELECT * FROM files WHERE parentReference_path = '/drives/b!3LIvU2zISEqicGlWkgVknKxKT-q7gM5IqlBJ4w4MZqaX6BQc_vtwQpnqaldXkH9I/root:/Test_Shubham';

INSERT

INSERT 操作は、このテーブルではサポートされていません。

Note：ファイルの内容を挿入および更新するには、UploadFile を（フォルダを作成するにはCreateFolder を）参照してください。

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.

ODBC Driver for Microsoft Office 365

Files

テーブル固有の情報

Select

INSERT

Columns