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.
Objects Supported
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.
Drives
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
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 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
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
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
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 No The ID of the drive that this workbook belongs to.
Return to Top
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 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
j
