HI, How do I download a csv file from Sharepoint site using MS Graph API ?

Question

HI, I am trying to download a file from a SharePoint Site, but cant find the item-id as listed in the REST API.

Answer 1

Hello @Akhil Ravindran , this request is available to you : GET /sites/{siteId}/drive/items/{item-id}/content and you can use this link as a reference: https://learn.microsoft.com/en-us/graph/api/driveitem-get-content?view=graph-rest-1.0&tabs=http

---

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.

Answer 2

Hello @Akhil Ravindran ,

As I see from the question are you referring to SharePoint REST API(working-with-lists-and-list-items-with-rest)!
SharePoint REST API item-id is different and Microsoft Graph API drive item-id is different.

Use driveitem-list-children API to get drive-items item-id, for my example I am simply getting the children from root folder.

GET /sites/{id}/drive/root/children  

From the above response, take the id of .CSV file which needs to be downloaded.
Use the driveitem-get-content by making use of the id from above response.

GET /sites/{id}/drive/items/{id}/content  

As I am using postman for this test, I can use Save Response to a file which will download the .CSV file.
Hope this helps.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".