Forum Discussion
SharePoint 'sites' API Doesn't Return All Sites
I'm new to SharePoint, so bear with me.
I have 100+ users, all of whom have been given access to a SharePoint site called 'NetSuite BluDocs' through a group called 'NetSuite BluDocs Members' which has 'Edit' permissions. A third-party NetSuite app called 'bluDocs' (that I don't control) runs in NetSuite and will display folders and files for projects. Users have to authenticate with SharePoint the first time they open the bluDocs list in NetSuite. A 'refresh_token' returned by SharePoint is stored in NetSuite, which is then used for authentication whenever the NetSuite user wants to view folders and files. Every user can go directly to SharePoint and find any folder/file they want since they all belong to the 'NetSuite BluDocs Members' group.
However, there are 7 users for whom the bluDocs in NetSuite don't display. The reason is that the 'sites' API is not returning the 'NetSuite BluDocs' site info even though it's returning other sites the user has access to. I've had users reauthenticate bluDocs several times without success.
If I copy the refresh_token from a user who is working properly in NetSuite and paste it into the refresh_token for a user who can't see the bluDocs in NetSuite, the user can see the bluDocs, but anything they upload is shown as belonging to the user whose token I copied. I don't know how permissions are stored in SharePoint, but it looks like some user refresh_tokens aren't being linked to the 'NetSuite BluDocs' site – or the opposite; 'NetSuite BluDocs' isn't being linked to the refresh_token.
Given that all 7 affected users can go directly to SharePoint and see all folders and files, why isn't the 'sites' API returning 'NetSuite BluDocs' in the list of sites the user is assigned to?