How to access all SharePoint documents for all the sites in the tenancy?

Question

How to access all SharePoint documents for all the sites in the tenancy?

GR 41

Hi,

We're creating token for a specific client's tenancy, and we want to be able to access all SharePoint documents for all the sites in the tenancy. Is there a way to access those using a generic SharePoint API and one access token?

There are two files store:

one in a personal OneDrivce folder in the tenancy
one in a SharePoint site folder, e.g. for a Yammer group

The url to the file in a personal OneDrivce folder starts with '<tenant-name>-my.', whereas the SharePoint site document url doesn't contain the '-my' suffix:

file in a personal OneDrivce folder: https://<tenant-name>-my.sharepoint.com/personal/example-customer-com/_layouts/15/Doc.aspx?sourcedoc=%7B1115F5DE-213E-465D-B9A3-893860C2CA11%7D&file=Document1.docx&action=default&mobileredirect=true&DefaultItemOpen=1
SharePoint site document: https://<tenant-name>.sharepoint.com/sites/<site-id/group>/_layouts/15/Doc.aspx?sourcedoc=%7B222EF3FA-25F4-4A0E-8A52-5B087985C44D%7D&file=Document2.docx&action=default&mobileredirect=true

We have been trying to create an access token with a https://microsoft.sharepoint-df.com/AllSites.Read scope, but it ends with incorrect audience issue. We hoped that since those are SharePoint documents in the same tenancy, we would be able to access them.
We have used two different access tokens with different scopes. We explicitly added https://<tenant-name>-my.sharepoint.com/... to the first scope, and the https://<tenant-name>.sharepoint.com to the second scope, to be able to download those files using GetFileById. This works, however we would prefer to use a single generic scope without providing every url and needed a separate tokens.

Additionally, we have tried using the Microsoft Graph API, but it seems we don't have enough details to use it, e.g. we don't know the drive and item ids and the file path.

Is there a way to access all SharePoint documents within a tenancy using a generic API with details from file's urls? The details we have are: <tenant-name>, <site-id>, sourcedoc, file name?

Thanks

Tong Zhang_MSFT 8,881 Reputation points

2022-08-19T01:36:56.907+00:00

Hi @GR ,

We are currently doing some research on this issue, will let you know as soon as possible.

Tong Zhang_MSFT 8,881 Reputation points

2022-08-19T01:36:56.907+00:00

Hi @GR ,

We are currently doing some research on this issue, will let you know as soon as possible.

Answer 1

Tong Zhang_MSFT 8,881

Hi @GR ,

According to my research and testing, you can use the following graph API to access SharePoint documents for the sites in the tenant .Note: You need to have Sites.Read.All permission to these sites.

https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-title}/items

Hope it can help you. Thanks for your understanding.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

GR 41 Reputation points

2022-08-19T08:36:38.233+00:00
Thank you for your answer, but unfortunately it doesn't seem to provide an option that we're looking for.

We don't have a list-title as per following url's. These url's only provide: hostname (with tenancy name), site-id (if it's specified), unique-id (sourcedoc) and the file.

Personal OneDrivce folder:
https://<tenant-name>-my.sharepoint.com/personal/example-customer-com/_layouts/15/Doc.aspx?sourcedoc=%7B1115F5DE-213E-465D-B9A3-893860C2CA11%7D&file=Document1.docx

SharePoint site document:
https://<tenant-name>.sharepoint.com/sites/<site-id/group>/_layouts/15/Doc.aspx?sourcedoc=%7B222EF3FA-25F4-4A0E-8A52-5B087985C44D%7D&file=Document2.docx

Do you know any other options?

Maybe there is a way to search for a file name within the tenancy? I've been trying the following search examples, but they don't seem to find anything either:
https://graph.microsoft.com/v1.0/sites/<tenant-name>-my.sharepoint.com/drive/root/search(q='1115F5DE-213E-465D-B9A3-893860C2CA11')
https://graph.microsoft.com/v1.0/sites/<tenant-name>.sharepoint.com/drive/root/search(q='222EF3FA-25F4-4A0E-8A52-5B087985C44D')
Tong Zhang_MSFT 8,881 Reputation points

2022-08-19T09:09:59.96+00:00
Hi @GR ,

According to my research and testing, please try to use Graph Search API, you can get file based on sourcedoc:

POST https://graph.microsoft.com/v1.0/search/query

{ "requests": [ { "entityTypes": [ "listItem" ], "query": { "queryString": "please enter sourcedoc" } } ] }

You also can refer to the Rest API: GET http:// _server_/_api/search/query?querytext='sharepoint'&sourceid='8413cd39-2156-4e00-b54d-11efd9abdb89'

More information for reference:
Graph API: https://learn.microsoft.com/en-us/graph/search-concept-files
Rest API: https://learn.microsoft.com/en-us/sharepoint/dev/general-development/sharepoint-search-rest-api-overview#sample-get-request-3
GR 41 Reputation points

2022-08-19T15:15:16.193+00:00

Thanks, but it hasn't solved our issue.

The _server_ is replaced with a SharePoint tenancy name. It means that I'm still unable to download a file without using a multiple access tokens: one for the SharePoint tenancy name, and one for Microsoft Graph API to download a file.

For example, I have updated the tenancy name search query using the sourcedoc in the querytext value: https://<tenancy-name>.sharepoint.com/_api/search/query?querytext='11D6C368-0F20-4C60-870F-D560FFDC7911'. It returns a key/value response with a number of useful details, e.g. Path (file path), UniqueId, SiteId, ListId, OriginalPath, but there is no drive id.

However, when trying to download a file using given details and the first Microsoft Graph API, https://graph.microsoft.com/v1.0/sites/<SiteId>/lists/<ListId>/items/<UniqueId>/content, it fails to download a file with Resource not found for the segment 'content'. error.

I'm wondering if is there another way to try to download a file based on given details and with just a single access token.
Tong Zhang_MSFT 8,881 Reputation points

2022-08-23T07:52:51.937+00:00

Hi @GR ,

Based on my research and testing, unfortunately ,currently there is no any other way to achieve it. Thanks for your understanding.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Tong Zhang_MSFT 8,881 Reputation points

2022-08-26T08:53:00.447+00:00

Hi @GR ,

Do you have any further questions about this thread? If you have any questions or progress, you can contact me in time.

How to access all SharePoint documents for all the sites in the tenancy?

1 answer

Activity