Access to sharepoint folder?

English support forum

Moderators: white, Hacker, petermad, Stefan2

User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Access to sharepoint folder?

Post by *ghisler(Author) »

Access to Sharepoint works via "synchronization", as described here by Microsoft:
https://support.microsoft.com/en-us/office/add-and-sync-shared-folders-to-onedrive-for-home-8a63cd47-1526-4cd8-bd09-ee3f9bfc1504

This works with both Explorer and Total Commander
Author of Total Commander
https://www.ghisler.com
Semsoid
Junior Member
Junior Member
Posts: 5
Joined: 2022-09-27, 20:39 UTC

Re: Access to sharepoint folder?

Post by *Semsoid »

I added the Onedrive as OneDrive New (Business+Personal) using Cloud Plugin. However, neither <Shared> nor business shows the shortcut i added via Sharepoint to my Onedrive.

Am I missing something?
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Access to sharepoint folder?

Post by *ghisler(Author) »

Strange, other users have reported that it worked fine for them. Please retry the procedure, maybe you made a small mistake. Or Microsoft changed something and it no longer works? Does it appear in the OneDrive Web interface?
Author of Total Commander
https://www.ghisler.com
Semsoid
Junior Member
Junior Member
Posts: 5
Joined: 2022-09-27, 20:39 UTC

Re: Access to sharepoint folder?

Post by *Semsoid »

Yes, Onedrive web shows the shortcut fine. But Cloud plugin does not.

Tried with several installs, several accounts. Same results. It is very possible Microsoft changed something. I had some accounts not showing the business one, but rather it shows <shared>, documentLibrary and documentLibrary2 in list. The ones I tested the Sharepoint folder had the proper <shared> and business, but still had no luck. Just thought I'd share this, in case it rings a bell to someone.
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Access to sharepoint folder?

Post by *ghisler(Author) »

Unfortunately I do not have sharepoint and cannot test this myself. My guess is that it appears outside of the regular OneDrive in the web interface, and therefore has to be accessed via a separate url. Is this true, does it appear as a separate entry in the left column like "shared" and "recycle bin"?

Unfortunately I cannot find any information. The drives are listed via a call like this:
GET /v1.0/me/drives
Here is the documentation:
https://learn.microsoft.com/en-us/graph/api/drive-list?view=graph-rest-1.0&tabs=http
And the shared drives are listed with
GET /v1.0//me/drive/sharedWithMe
See:
https://learn.microsoft.com/en-us/graph/api/drive-sharedwithme?view=graph-rest-1.0&tabs=http

There seem to be URLs to get sharepoint activity and site usage:
https://learn.microsoft.com/en-us/graph/api/resources/sharepoint-activity-reports?view=graph-rest-1.0
https://learn.microsoft.com/en-us/graph/api/resources/sharepoint-site-usage-reports?view=graph-rest-1.0
But they don't seem to give access to the sharepoint files.

Any ideas?
Author of Total Commander
https://www.ghisler.com
Semsoid
Junior Member
Junior Member
Posts: 5
Joined: 2022-09-27, 20:39 UTC

Re: Access to sharepoint folder?

Post by *Semsoid »

https://paste.pics/IXMJR

Above is what I see. So when you add Sharepoint Document Library as a shortcut, it adds it to your list of files/folders. However, it is a separate link, in

the sense that if you switch over to Old Sharepoint interface (called Classic), it is not listed there. If you click the link, it goes straight through seamlessly, but URL changes from

https://mytenant-my.sharepoint.com/personal/myuser_mytenant_org/_layouts/15/onedrive.aspx

to:

https://mytenant-my.sharepoint.com/personal/myuser_mytenant_org/_layouts/15/onedrive.aspx?id=%2FShared%20Documents&listurl=https%3A%2F%2Fmytenant%2Esharepo ... m%22%7D%7D

I will check and see if Graph API would allow to see it.

Many apps I have seen can use document library url directly. Maybe you can add an option to go Document library in the Cloud Service Provider pull down and have an option to select Sharepoint and have the user provide the document library URL, like

https://mytenant.sharepoint.com/Shared%20Documents

or similar... It might be easier to implement this, then trying to figure out a link in Onedrive.

I can prep/share a Sharepoint folder with you, DM me if interested Christian.
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Access to sharepoint folder?

Post by *ghisler(Author) »

However, it is a separate link
That might be the problem. Could you please do the following:
1. Enable detailed logging in the connection options of the cloud plugin
2. Connect to your OneDrive and go to the base directory
3. In the other panel, go to the TEMP directory, e.g. via command line:
cd %TEMP%
4. There should be a file named CLO<something>.tmp. View it with F3.
5. Search for the name of the link, in your case: Documents - Communication site
If it is there, could you send me the entire record? Here a record starts with
{"name":"
and ends at the next such {"name": entry or the end of the file.
Many apps I have seen can use document library url directly.
Interesting, do you know whether this works with the regular Graph API?
Author of Total Commander
https://www.ghisler.com
Semsoid
Junior Member
Junior Member
Posts: 5
Joined: 2022-09-27, 20:39 UTC

Re: Access to sharepoint folder?

Post by *Semsoid »

It is not there. Neither under base or base\business

I have tried AirLiveDrive today and it has option for Sharepoint and Onedrive separately. If I select Sharepoint, it actually lists the Sharepoint site and Onedrive in the list. I ran Fiddler, with HTTPS decryption on and found requests were:

GET /v1.0/me HTTP/1.1
GET /v1.0/sites/root HTTP/1.1
GET /v1.0/sites?search=*&top=200 HTTP/1.1
GET /v1.0/me/drive HTTP/1.1
GET /v1.0/sites/mytenantshelby.sharepoint.com,edd3be-5d20-434a-a5fc-391049f052d1,1e5e8e66-da99-4cb1-9d56-2c26f082c258/drives HTTP/1.1
GET /v1.0/drives/b!obfuscated-obfuscated2/items/root/?expand=children HTTP/1.1
GET /v1.0/drives/b!obfuscated-obfuscated2/items/01VM77PON6Y2GOVW7725BZO354PWSELRRZ/children?expand=thumbnails HTTP/1.1
GET /v1.0/sites/mytenantshelby.sharepoint.com,920ba8ce-19e7-4166-aad2-a7f998f1d245,421ba503-f63c-46be-9b2c-2191b966559a/drives HTTP/1.1

Getting the sites, returns the sharepoint URL and information. I can DM or email you the Fiddler logs.
User avatar
ghisler(Author)
Site Admin
Site Admin
Posts: 48021
Joined: 2003-02-04, 09:46 UTC
Location: Switzerland
Contact:

Re: Access to sharepoint folder?

Post by *ghisler(Author) »

This looks promising. I found documentation for the sites parameter here:
https://learn.microsoft.com/en-us/graph/api/site-list?view=graph-rest-1.0
The "id" field in that sample reply looks like the field used in your calls containing "mytenantshelby.sharepoint.com".
Did you need to use a special login to access these drives?
Author of Total Commander
https://www.ghisler.com
Semsoid
Junior Member
Junior Member
Posts: 5
Joined: 2022-09-27, 20:39 UTC

Re: Access to sharepoint folder?

Post by *Semsoid »

I have just used the end user login. For example when you create a user with proper license (Microsoft 365 Business Basic in my case) under the tenant, the user automatically gets permissions to the default sharepoint site under.

So, tenant would have https://tenantname.sharepoint.com . User's Onedrive is hosted under tenantname-my.sharepoint.com and user has access to both. Default sharepoint permissions has "Team Members" in it, and any new user added to the tenant is automatically added to the group.
Post Reply