Hello team, I want to build an integration with Sharepoint platform and use the API you provide. The goal is to fetch the content of every document in a site Therefore I created an app in order to use it for OAuth2 The application has the following permissions: AllSites.Read AllSites.Write Steps i did so far: I am trying to fetch all sites using the following url Url: https://graph.microsoft.com/v1.0/sites?search= * After I fetch the site id I wanted to fetch the drives so I used Url: https://graph.microsoft.com/v1.0/sites/xxxxx.sharepoint.com/drives/ And then I use the drive id to fetch all the items in the drive: Url: https://graph.microsoft.com/v1.0/sites/xxxxx.sharepoint.com/drives/{drive-id}/items/root/children But this endpoint provides a url that downloads the file I only need to read the content. I also did this: During the implementation I also tried to fetch the content of each document in the list of the xxxxx.sharepoint.com site. (list id and item id in the following url are valid) Url https://graph.microsoft.com/v1.0/sites/xxxxx.sharepoint.com/lists/{list-id}/items/{item-id}/driveItem/content The above returns a binary response and I cannot read the actual content of the document. I tried to decode the content using iso-8859-1 and utf-8 , but I did not manage to read the content of the file. Is there any endpoint I can use in order to read the content of a file? Thanks in advance

Hi @ George Xydias , If you want to connect sharepoint with rest api, I would recommend you to use SharePoint app only . You could refer to following steps in the article https://billyperalta.com/Accessing%20SharePoint%20REST%20API%20using%20Postman/ 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.

Read the content of a Sharepoint file using the API

George Xydias 5

Hello team,

I want to build an integration with Sharepoint platform and use the API you provide.

The goal is to fetch the content of every document in a site

Therefore I created an app in order to use it for OAuth2

The application has the following permissions:

AllSites.Read
AllSites.Write

Steps i did so far:

I am trying to fetch all sites using the following url

Url: https://graph.microsoft.com/v1.0/sites?search=*

After I fetch the site id I wanted to fetch the drives so I used

Url: https://graph.microsoft.com/v1.0/sites/xxxxx.sharepoint.com/drives/

And then I use the drive id to fetch all the items in the drive:

Url: https://graph.microsoft.com/v1.0/sites/xxxxx.sharepoint.com/drives/{drive-id}/items/root/children
But this endpoint provides a url that downloads the file I only need to read the content.

I also did this:

During the implementation I also tried to fetch the content of each document in the list of the xxxxx.sharepoint.com site.

(list id and item id in the following url are valid)

Url https://graph.microsoft.com/v1.0/sites/xxxxx.sharepoint.com/lists/{list-id}/items/{item-id}/driveItem/content

The above returns a binary response and I cannot read the actual content of the document.

I tried to decode the content using iso-8859-1 and utf-8, but I did not manage to read the content of the file.

Is there any endpoint I can use in order to read the content of a file?

Thanks in advance

George Xydias 5 Reputation points

2024-04-09T08:32:06.4733333+00:00
During the implementation I also tried to use the /_api/web or /_api/site API as it is described in docs:

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service?tabs=http#sharepoint-rest-endpoint-examples

The url was like this

https://xxxxx.sharepoint.com/_api/site/lists

https://xxxxxx.sharepoint.com/_api/web/lists

I used the above url with the headers described here

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service?tabs=http#how-the-sharepoint-rest-service-works

But I as getting 401 Unauthorized with message

{"error_description":"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."}

1 answer

RaytheonXie_MSFT 31,376 Reputation points Microsoft Vendor

2024-04-10T06:57:45.82+00:00

Hi @George Xydias,

If you want to connect sharepoint with rest api, I would recommend you to use SharePoint app only. You could refer to following steps in the article

https://billyperalta.com/Accessing%20SharePoint%20REST%20API%20using%20Postman/

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.
Please sign in to rate this answer.
George Xydias 5 Reputation points

2024-04-11T11:15:03.2866667+00:00

Thank you for the quick response,

I follow the steps on
https://billyperalta.com/Accessing%20SharePoint%20REST%20API%20using%20Postman/
I manage to produce an access token but when I am trying to perform a requests I am getting back this (401) error

{"error":"invalid_request","error_description":"Token type is not allowed."}

e.g.
url:
https://xxxxxx.sharepoint.com/_api/lists/getbytitle('<list-name>')/items
headers:
{

"Authorization": "Bearer <access_token>"

"Accept": "application/json;odata=verbose"

"Content-Type": "application/json;odata=verbose"

}

I also tried to fetch all the lists and I was getting back the 401 I mentioned above
url:

https://xxxxxx.sharepoint.com/_api/lists/

heades are the same as above.

How can I fetch the content of every item in a specified list?
Is there any endpoint I can use to read the content of an item?
Can I read the content of every item, even if the item is not part of the root list?

My goal is to find out an endpoint that I can read the content of a requested file.
How can I achieve this?

RaytheonXie_MSFT 31,376 Reputation points Microsoft Vendor

2024-04-15T02:29:54.0533333+00:00

Hi @George Xydias,

What's the format of the files you want to read? Are they .txt or .xlsx files

George Xydias 5 Reputation points

2024-04-15T07:16:01.2133333+00:00

Hi @RaytheonXie_MSFT ,
thank you for your response.

I would like to read any file containing text, regardless of its format.
durring the implementation, I try to read a .docx file.

RaytheonXie_MSFT 31,376 Reputation points Microsoft Vendor

2024-04-16T01:54:59.99+00:00

To get the content of your word file, locate that file in sharepoint using this endpoint.

GET /sites/{siteId}/drive/items/{item-id}/content

Note: Response for this API GET /sites/{siteId}/drive/items/{item-id}/content does not come in Graph Explorer due to CORS policy. Please use Postman(API client) to execute this request.

You can refer to this documentation for more details

George Xydias 5 Reputation points

2024-04-16T08:24:01.7133333+00:00

I try to use the suggested endpoint:
GET /sites/{siteId}/drive/items/{item-id}/content

Url I used:
https://graph.microsoft.com/v1.0/sites/xxxxx.sharepoint.com/drive/items/{item-id}/content

Response:

{ "error": { "code": "itemNotFound", "message": "Item not found" } }

I used the the item-id from this response:

Url I used to fetch the items:

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

Response:

{ "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('xxxxx.sharepoint.com')/lists('{list-id}')/items", "value": [ { "@odata.etag": "\"{etag}\"", "createdDateTime": "2024-04-03T12:33:06Z", "eTag": "\"{etag}\"", "id": "1", "lastModifiedDateTime": "2024-04-03T12:33:29Z", "webUrl": "https://xxxxx.sharepoint.com/Shared%20Documents/test.docx", "createdBy": { "user": { "email": "email", "id": "user-id", "displayName": "George Xydias" } }, "lastModifiedBy": { "user": { "email": "email", "id": "user-id", "displayName": "George Xydias" } }, "parentReference": { "id": "id", "siteId": "xxxxx.sharepoint.com,id,id" }, "contentType": { "id": "id", "name": "Document" } } ] }

Note: I am using postman for my requests

As you said in your note:
Response for this API ``GET /sites/{siteId}/drive/items/{item-id}/content`` does not come in Graph Explorer due to CORS policy

If I am not using the url in a proper way please let me know what is the correct way.

Do I use the proper endpoint in order to fetch the items ?

Do I use the proper endpoint to fetch content of the item ?
Sign in to comment