SharepointOnlineConnector doesn't return all files

Hi ​@joy, have you tried the SharePoint List Reader? Are you able to read in your lists that way?  

​@saraatsafe No I haven’t tried it that way initially
If I want to read out lists, then I need to use the SharePoint List Reader specifically? 
I tried to use the Sharepoint ListReader just now, but then I encounter the same problem as in Connect to SharePoint list in FME 2020 | Community Web connection is empty and If try to make one, I get the following error 

AADSTS70011: The provided request must include a 'scope' input parameter. The provided value for the input parameter 'scope' is not valid. The scope https://[TENANT].sharepoint.com/.default offline_access is not valid. The scope format is invalid. Scope must be in a valid URI form <https://example/scope> or a valid Guid <guid/scope>.

Hi ​@joy 

Yes! The SharePoint List Reader (and Writer) is designed to specifically read (or write) out lists in SharePoint.

To create a web connection, I recommend this article that walks through the steps to creating a single tenant Connection:

• How to Create a SharePoint List Single Tenant Web Connection

The article makes use of a Microsoft SharePoint Online template web connection, which I believe will help address the error you’re experiencing.

Besides that, our Getting Started with Microsoft SharePoint article has great additional information and more resources, like links to a multi-tenant setup. 

I hope these help! 🙂

​@desiree_at_safe 

Thanks for the links. I’ll look into them. I had another question.

My colleague encountered the following issue: She was given access to a specific folder by another department, but she is not a member of that Teams channel or SharePoint site.

When using the SharePoint Online connector, she doesn't see the SharePoint site from which she only has access to one folder. Is it only possible to see SharePoint sites if you are a member?

Hi ​@joy 

Generally, for the SharepointOnlineConnector to work you usually need some site-level access because the Connector needs to navigate to the site first before accessing the Document library (the folder).

Alternatively, they could try to hard code values in the Advanced Selection Editor to bypass the Connector “searching for the site” as shown in the troubleshooting document here: 

• Application permissions: Sites.Selected

hardcoding <HostURL>,<siteID>,<webId> with their values might help!