Microsoft 365 Excel Online Connector Objects
This Data 360 connector is a beta service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot or beta service is at the Customer's sole discretion.
| 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