Microsoft 365 Excel Online Connector Objects
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. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.
| 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. |
Return to Top
| 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. |
Return to Top
| 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
| 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
| 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. |
Return to Top
| 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. |
Return to Top