Have some questions on Files Connect:
1. What type of access does the Files Connect need to have to SharePoint Online?
2. Is the Files Connect using SharePoint Online search to return the results in SalesForce or is Files Connect crawling and indexing the SharePoint Online documents?
3. Can you scope the Files Connect access to just certain sites collections or sites or even libraries in SharePoint Online?
4.How does File Connect access OneDrive since each user has his/her own account?
1) We need read-access to the site collections and/or sites that users want to access from Salesforce.
2) We use the SPOnline search engine: Files Connect does not index anything.
3) You can scope the access to any site collection (including the root site collection) or to any site. You can NOT scope the access to a specific document library though (this is a limitation of the SPOnline public API).
4) Files Connect connects to the generic OneDrive endpoint (something like "
https://[COMPANY]-my.sharepoint.com") and then authenticates on behalf of the current user using Oauth. Once the authentication is done, Files Connect can only "see" the files the current user is allowed to see.