Microsoft 365 Excel Online Connector Objects
| Name | Description |
|---|---|
| Drives | Retrieve a list of drive objects. |
| Folders | Retrieve a list of Folder objects. |
| SharedDocuments | Retrieve the list of all shared documents. Not every item listed by this view can be used as a workbook since the driver will filter out non excel files. See the Workbook and Worksheets views for more information. |
| SharePointSites | Retrieve the list of all sites in your SharePoint account. |
| Workbooks | Retrieve a list of workbook objects. |
| Worksheets | Retrieve a list of worksheet objects. If listing sheets in a workbook which do not belong to the user's drive, please specify the drive id using the Drive connection property. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier of the drive. | |
| SiteId | String | False | SharePointSites.Id | No | The ID of the SharePoint site or subsite that this drive belongs to. |
| ListId | String | False | No | The ID of the list this drive corresponds to. | |
| Name | String | False | No | The name of the drive. | |
| Description | String | False | No | The description of the drive. | |
| CreatedByName | String | False | No | The display name of the identity. | |
| CreatedById | String | False | No | Unique identifier for the identity. | |
| CreatedDateTime | Datetime | False | No | Date and time the drive was created. | |
| LastModifiedDateTime | Datetime | False | No | Date and time the drive was last modified. | |
| WebUrl | String | False | No | URL that displays the resource in the browser. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier of the folder. | |
| Name | String | False | No | The Name of the folder | |
| DriveId | String | False | Drives.Id | No | The ID of the drive that this folder belongs to. |
| ParentPath | String | False | No | The path of the folder's parent. | |
| ParentId | String | False | No | The id of the folder's parent. | |
| ParentName | String | False | No | The name of the folder's parent. | |
| CreatedByName | String | False | No | The display name of the identity. | |
| CreatedById | String | False | No | Unique identifier for the identity. | |
| CreatedDateTime | Datetime | False | No | Date and time the item was created. | |
| LastModifiedDateTime | Datetime | False | No | Date and time the item was last modified. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the shared document | |
| SharedFileId | String | False | No | The shared file Id of the document. | |
| DriveId | String | False | No | The drive Id where this document resides. | |
| Name | String | False | No | The name of the shared document. | |
| Size | String | False | No | The size of the shared document. | |
| SharedByUserName | String | False | No | The name of the user who shared this document. | |
| SharedDateTime | String | False | No | The date and time when this document was shared. | |
| CreatedDateTime | Datetime | False | No | The date and time when this document was created. | |
| LastModifiedDateTime | Datetime | False | No | The date and time when this document was last modified. | |
| WebUrl | String | False | No | The web URL of this shared document. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The full identifier of the site. | |
| SiteId | String | False | No | The unique identifier of the site collection. | |
| WebId | String | False | No | The Web Id of the site. | |
| SiteName | String | False | No | The name of the site. | |
| Title | String | False | No | The title of the site. | |
| SiteDescription | String | False | No | The description of the site. | |
| Description | String | False | No | The description of the item. | |
| CreatedDateTime | Datetime | False | No | Date and time the site was created. | |
| LastModifiedDateTime | Datetime | False | No | Date and time the site was last modified. | |
| SPWebUrl | String | False | No | URL that displays the resource in the browser. | |
| Author | String | False | No | The author of the site. | |
| DocumentSignature | String | False | No | The document signature of the site. | |
| FileExtension | String | False | No | The extension of the site's file. | |
| SecondaryFileExtension | String | False | No | The secondary extension of the site's file. | |
| FileType | String | False | No | The file type of the site. | |
| DocId | Long | False | No | The unique identifier of the site within a geo location. | |
| GeoLocationSource | String | False | No | The geo location of the site. | |
| HitHighlightedSummary | String | False | No | The heighted summary of the site. | |
| Importance | Long | False | No | The importance of the site. | |
| IsContainer | Bool | False | No | Specifies whether the site is a folder. | |
| IsDocument | Bool | False | No | Specifies whether the site is a document. | |
| OriginalPath | String | False | No | The original site path. | |
| Path | String | False | No | The current site path. | |
| Rank | Double | False | No | The rank of the site. | |
| RenderTemplateId | String | False | No | The site's control render template name. | |
| SiteLogo | String | False | No | The URI of the site's logo. | |
| ViewsLifeTime | Long | False | No | The total view count since the site was created. | |
| ViewsRecent | Long | False | No | The total view count of the site in the last 14 days. | |
| WebTemplate | String | False | No | The web temple from which the site is created. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The unique identifier of the item within the Drive. | |
| Name | String | False | No | The name of the item. | |
| CreatedByName | String | False | No | The display name of the identity. | |
| CreatedById | String | False | No | Unique identifier for the identity. | |
| CreatedDateTime | Datetime | False | No | Date and time the item was created. | |
| LastModifiedDateTime | Datetime | False | No | Date and time the item was last modified. | |
| Size | Long | False | No | Size of the item in bytes. | |
| WebUrl | String | False | No | URL that displays the resource in the browser. | |
| DriveId | String | False | Drives.Id | No | The ID of the drive that this workbook belongs to. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | Returns a value that uniquely identifies the worksheet in a given workbook. The value of the identifier remains the same even when the worksheet is renamed or moved. | |
| WorkbookId | String | False | Workbooks.Id | No | The Id of the workbook containing this worksheet. |
| Name | String | False | No | The display name of the worksheet. | |
| Position | Integer | False | No | The zero-based position of the worksheet within the workbook. | |
| Visibility | String | False | No | The visibility of the worksheet. Possible values are: Visible, Hidden, VeryHidden. |