--- schema_version: "1" id: d7d8b34a599f4b8875f492a25d1569547b60a0e6b26052e63dae5798866d2eb7 title: Microsoft 365 Excel Online Connector Objects collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/excelonline/c360-a-excelonline-objects.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-excelonline-objects.html source_site: developer.salesforce.com content_type: documentation content_hash: 0b7ba83200a952061c1f7ee1c6e709984a0165fcc0f453886dbbfd2da8d1c11f products: - Data 360 Integration Guide - Data 360 Developer Documentation --- # Microsoft 365 Excel Online Connector Objects **note:** This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at [Agreements and Terms.](https://www.salesforce.com/company/legal/agreements/) If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at [datacloud-connectors-beta@salesforce.com.](mailto:datacloud-connectors-beta@salesforce.com) ## Objects Supported | Name | Description | | ----------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [Drives](#drives) | Retrieve a list of drive objects. | | [Folders](#folders) | Retrieve a list of Folder objects. | | [SharedDocuments](#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](#sharepointsites) | Retrieve the list of all sites in your SharePoint account. | | [Workbooks](#workbooks) | Retrieve a list of workbook objects. | | [Worksheets](#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. | ## Drives | Name | Type | ReadOnly | References | FilterOnly | Description | | -------------------- | -------- | -------- | -------------------------------------- | ---------- | -------------------------------------------------------------------- | | Id [KEY] | String | False | | No | The unique identifier of the drive. | | SiteId | String | False | [SharePointSites.Id](#sharepointsites) | 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. | [Return to Top](#objects-supported) ## Folders | 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](#drives) | 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. | [Return to Top](#objects-supported) ## SharedDocuments | 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. | [Return to Top](#objects-supported) ## SharePointSites | 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. | [Return to Top](#objects-supported) ## Workbooks | 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](#drives) | No | The ID of the drive that this workbook belongs to. | [Return to Top](#objects-supported) ## Worksheets | 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](#workbooks) | 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. | [Return to Top](#objects-supported)