Excel Add-In for Microsoft Office 365

Build 25.0.9434

Files

Lists files stored in OneDrive or SharePoint, with metadata including file names, locations, last modified times, and sharing status.

Table Specific Information

Select

Retrieve files by using the UserId or File Id (Id) for instance, or simply filter by a certain column: 

SELECT * FROM Files WHERE UserId = 'MyUserId'

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

To work for Folder-level files, we need to specify the parentReference_path in the query. 

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

INSERT

INSERT operation is not supported for this table.

Note: See UploadFile (or CreateFolder to create a folder) to insert and update content to a file.

Columns

Name Type ReadOnly References Description
id [KEY] String True

Unique identifier for the file object.

Etag String False

Entity tag representing the version of the file for concurrency control.

createdBy_application_displayName String False

Display name of the application that created the file.

createdBy_application_id String False

Identifier of the application that created the file.

createdDateTime Datetime False

Timestamp indicating when the file was created.

description String False

User-defined or system-generated description of the file.

lastModifiedBy_application_displayName String False

Display name of the application that last modified the file.

lastModifiedBy_application_id String False

Identifier of the application that last modified the file.

lastModifiedDateTime Datetime False

Timestamp indicating the last modification time of the file.

name String False

Name of the file.

parentReference_driveId String False

Drive ID of the parent folder that contains the file.

parentReference_driveType String False

Type of drive (for example, personal, business, or document library) where the file resides.

parentReference_id String False

ID of the parent folder or drive reference.

parentReference_name String False

Name of the parent folder containing the file.

parentReference_path String False

Path from the drive root to the parent folder.

parentReference_shareId String False

Sharing ID associated with the parent reference.

parentReference_sharepointIds_listId String False

SharePoint list ID linked to the parent reference.

parentReference_sharepointIds_listItemId String False

List item ID in SharePoint for the parent reference.

parentReference_sharepointIds_listItemUniqueId String False

Unique ID of the list item in SharePoint for the parent reference.

parentReference_sharepointIds_siteId String False

Site ID in SharePoint associated with the parent reference.

parentReference_sharepointIds_siteUrl String False

URL of the SharePoint site related to the parent reference.

parentReference_sharepointIds_tenantId String False

Tenant ID for the SharePoint environment of the parent reference.

parentReference_sharepointIds_webId String False

Web ID in SharePoint for the parent reference.

parentReference_siteId String False

Site ID associated with the file's parent location.

webUrl String False

Web-accessible URL pointing to the file.

audio_album String False

Album title associated with the audio file.

audio_albumArtist String False

Primary artist for the album associated with the audio file.

audio_artist String False

Artist of the audio file.

audio_bitrate Long False

Bitrate of the audio content in bits per second.

audio_composers String False

List of composers for the audio content.

audio_copyright String False

Copyright statement for the audio file.

audio_disc Int False

Disc number for multi-disc audio content.

audio_discCount Int False

Total number of discs in the album.

audio_duration Long False

Duration of the audio content in milliseconds.

audio_genre String False

Genre of the audio content.

audio_hasDrm Bool False

Indicates whether the audio file is protected by digital rights management.

audio_isVariableBitrate Bool False

Indicates whether the audio file uses variable bitrate encoding.

audio_title String False

Title of the audio track.

audio_track Int False

Track number of the audio file within the album.

audio_trackCount Int False

Total number of tracks in the album.

audio_year Int False

Year the audio track was released.

content String False

File contents in raw or encoded format.

cTag String False

Client tag used for managing file changes and synchronization.

deleted_state String False

Indicates the deletion state of the file, such as deleted or notDeleted.

file_hashes_crc32Hash String False

CRC32 hash value used to validate file content integrity.

file_hashes_quickXorHash String False

QuickXorHash used for content comparison and validation.

file_hashes_sha1Hash String False

SHA-1 hash of the file contents.

file_hashes_sha256Hash String False

SHA-256 hash of the file contents.

file_mimeType String False

MIME type indicating the file format, such as text/plain or application/pdf.

file_processingMetadata Bool False

Indicates whether metadata processing is complete for the file.

fileSystemInfo_createdDateTime Datetime False

Creation timestamp of the file from the file system.

fileSystemInfo_lastAccessedDateTime Datetime False

Last accessed timestamp recorded by the file system.

fileSystemInfo_lastModifiedDateTime Datetime False

Last modified timestamp recorded by the file system.

folder_childCount Int False

Number of child items within the folder.

folder_view_sortBy String False

Default column used to sort items in the folder view.

folder_view_sortOrder String False

Sort order (ascending or descending) used in the folder view.

folder_view_viewType String False

Type of folder view, such as details or thumbnails.

image_height Int False

Height of the image in pixels.

image_width Int False

Width of the image in pixels.

location_altitude Double False

Altitude where the image or file was captured, in meters.

location_latitude Double False

Latitude coordinate where the file or photo was created.

location_longitude Double False

Longitude coordinate where the file or photo was created.

package_type String False

Type of file package, such as oneNote or PDFPackage.

pendingOperations_pendingContentUpdate_queuedDateTime Datetime False

Timestamp when a pending content update was queued.

photo_cameraMake String False

Manufacturer of the camera used to take the photo.

photo_cameraModel String False

Model of the camera used to take the photo.

photo_exposureDenominator Double False

Denominator value for the exposure time used in the photo.

photo_exposureNumerator Double False

Numerator value for the exposure time used in the photo.

photo_fNumber Double False

F-number indicating the aperture setting of the camera.

photo_focalLength Double False

Focal length of the camera lens in millimeters.

photo_iso Int False

ISO setting used when the photo was taken.

photo_orientation Int False

Orientation value of the photo, indicating how it was rotated when taken.

photo_takenDateTime Datetime False

Timestamp when the photo was captured.

publication_level String False

Indicates the publication level, such as draft or published.

publication_versionId String False

Version ID of the published file.

remoteItem_createdBy_application_displayName String False

Display name of the application that originally created the remote item.

remoteItem_createdBy_application_id String False

Identifier of the application that created the remote item.

remoteItem_createdDateTime Datetime False

Timestamp when the remote item was created.

remoteItem_file_hashes_crc32Hash String False

CRC32 hash of the remote file used to verify data integrity.

remoteItem_file_hashes_quickXorHash String False

QuickXorHash of the remote file for efficient content comparison.

remoteItem_file_hashes_sha1Hash String False

SHA-1 hash of the remote file content.

remoteItem_file_hashes_sha256Hash String False

SHA-256 hash of the remote file content.

remoteItem_file_mimeType String False

MIME type of the remote file, identifying its format.

remoteItem_file_processingMetadata Bool False

Indicates whether metadata processing is complete for the remote file.

remoteItem_fileSystemInfo_createdDateTime Datetime False

Timestamp of when the remote file was created in the file system.

remoteItem_fileSystemInfo_lastAccessedDateTime Datetime False

Timestamp of when the remote file was last accessed.

remoteItem_fileSystemInfo_lastModifiedDateTime Datetime False

Timestamp of when the remote file was last modified.

remoteItem_folder_childCount Int False

Number of child items in the remote folder.

remoteItem_folder_view_sortBy String False

Field used to sort child items in the remote folder view.

remoteItem_folder_view_sortOrder String False

Sort order used in the remote folder view (ascending or descending).

remoteItem_folder_view_viewType String False

Type of view used for the remote folder, such as list or grid.

remoteItem_id String False

Unique identifier for the remote item.

remoteItem_image_height Int False

Height of the remote image in pixels.

remoteItem_image_width Int False

Width of the remote image in pixels.

remoteItem_lastModifiedDateTime Datetime False

Timestamp indicating when the remote item was last modified.

remoteItem_name String False

Name of the remote item.

remoteItem_package_type String False

Package type of the remote item, such as oneNote or PDFPackage.

remoteItem_parentReference_driveId String False

Drive ID of the parent folder of the remote item.

remoteItem_parentReference_driveType String False

Type of drive containing the remote item.

remoteItem_parentReference_id String False

Identifier of the remote item's parent folder.

remoteItem_parentReference_name String False

Name of the folder containing the remote item.

remoteItem_parentReference_path String False

Full path from the drive root to the remote item's parent.

remoteItem_parentReference_shareId String False

Share ID associated with the parent of the remote item.

remoteItem_parentReference_sharepointIds_listId String False

SharePoint list ID associated with the remote item's parent.

remoteItem_parentReference_sharepointIds_listItemId String False

SharePoint list item ID for the remote item's parent.

remoteItem_parentReference_sharepointIds_listItemUniqueId String False

Unique ID of the SharePoint list item for the remote item's parent.

remoteItem_parentReference_sharepointIds_siteId String False

SharePoint site ID associated with the parent of the remote item.

remoteItem_parentReference_sharepointIds_siteUrl String False

SharePoint site URL associated with the remote item's parent.

remoteItem_parentReference_sharepointIds_tenantId String False

Tenant ID of the SharePoint site for the remote item's parent.

remoteItem_parentReference_sharepointIds_webId String False

Web ID of the SharePoint site for the remote item's parent.

remoteItem_parentReference_siteId String False

Site ID where the remote item's parent folder is located.

remoteItem_shared_scope String False

Scope of sharing for the remote item, such as users or organization.

remoteItem_shared_sharedDateTime Datetime False

Timestamp when the remote item was shared.

remoteItem_size Long False

Size of the remote item in bytes.

remoteItem_specialFolder_name String False

Name of the special folder associated with the remote item, such as documents or photos.

remoteItem_video_audioBitsPerSample Int False

Bit depth per audio sample in the remote video file.

remoteItem_video_audioChannels Int False

Number of audio channels in the remote video file.

remoteItem_video_audioSamplesPerSecond Int False

Audio sample rate in samples per second for the remote video.

remoteItem_video_bitrate Int False

Bitrate of the remote video content in bits per second.

remoteItem_video_duration Long False

Duration of the remote video in milliseconds.

remoteItem_video_fourCC String False

Four-character code (FourCC) identifying the video codec of the remote video.

remoteItem_video_frameRate Double False

Frame rate of the remote video in frames per second.

remoteItem_video_height Int False

Height of the remote video in pixels.

remoteItem_video_width Int False

Width of the remote video in pixels.

remoteItem_webDavUrl String False

WebDAV URL that provides remote access to the item.

remoteItem_webUrl String False

Publicly accessible web URL of the remote item.

searchResult_onClickTelemetryUrl String False

URL used to collect telemetry when a search result is clicked.

shared_owner_application_displayName String False

Display name of the application that owns the shared item.

shared_owner_application_id String False

Identifier of the application that owns the shared item.

shared_scope String False

Scope of the sharing, such as anonymous or organization.

shared_sharedDateTime Datetime False

Timestamp indicating when the item was shared.

sharepointIds_listId String False

SharePoint list ID associated with the item.

sharepointIds_listItemId String False

List item ID within the SharePoint list.

sharepointIds_listItemUniqueId String False

Globally unique identifier of the SharePoint list item.

sharepointIds_siteId String False

SharePoint site ID where the item resides.

sharepointIds_siteUrl String False

URL of the SharePoint site containing the item.

sharepointIds_tenantId String False

Tenant ID of the SharePoint organization.

sharepointIds_webId String False

Web ID of the SharePoint site.

size Long False

Total size of the file in bytes.

specialFolder_name String False

Type of special folder, such as documents or photos, associated with the item.

video_audioBitsPerSample Int False

Number of bits per audio sample in the video file.

video_audioChannels Int False

Number of audio channels in the video.

video_audioFormat String False

Format of the audio stream embedded in the video.

video_audioSamplesPerSecond Int False

Sampling rate of the audio stream in samples per second.

video_bitrate Int False

Bitrate of the video content in bits per second.

video_duration Long False

Total duration of the video in milliseconds.

video_fourCC String False

FourCC representing the video codec.

video_frameRate Double False

Video frame rate measured in frames per second.

video_height Int False

Vertical resolution of the video in pixels.

video_width Int False

Horizontal resolution of the video in pixels.

webDavUrl String False

WebDAV endpoint URL to access the file remotely.

UserId String False

Identifier of the user who owns or uploaded the file.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434