{"id":805,"date":"2024-06-19T13:38:47","date_gmt":"2024-06-19T12:38:47","guid":{"rendered":"https:\/\/france.magicsoftware.com\/blog\/?p=805"},"modified":"2026-03-26T10:57:55","modified_gmt":"2026-03-26T09:57:55","slug":"sharepoint-online-magic-xpi-how-to-get-the-content-list-of-a-sharepoint-folder-download-files-locally-and-upload-files-using-rest-microsoft-graph-api","status":"publish","type":"post","link":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/sharepoint-online-magic-xpi-how-to-get-the-content-list-of-a-sharepoint-folder-download-files-locally-and-upload-files-using-rest-microsoft-graph-api\/","title":{"rendered":"SharePoint Online Graph API \u2013 Magic xpi: How to Get the Content list of a SharePoint folder ,download files locally , upload Files and Retrieve Data from List using REST Microsoft Graph API"},"content":{"rendered":"\n

Describe the different steps for connecting Magic xpi with SharepointOnline using REST Microsoft Graph API<\/p>\n\n\n\n

1\/ Define in Azure Portal An app registration and add permission for Sharepoint through Microsoft Graph<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

2\/ Check that you can have access via Postman<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

3\/ Define a REST Client Resource in Magic xpi Studio<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

4\/ Define 2 Paths \/{list} and \/{urladdition}<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

5\/ To Get the Sharepoint ID Site that you want, Drag and Drop REST Client connector and configure the connector like below and click OK<\/p>\n\n\n\n

(*) In my example sharepoint web site is : https:\/\/magicsw365.sharepoint.com\/sites\/MSEFRANCE<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

6\/ Parse the JSON response with the mapper to retrieve the ID<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

6\/ To List the content of the website, use a GET<\/strong> with this type of URL ‘\/sites\/{IDSite}\/lists<\/strong>‘<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

7\/ Parse the JSON response to retrieve the ID List that you want (set the condition that you want (for example : Src.JSON\u00a0\u00bbS1\/Root Schema\/value\/A Schema\/webUrl\u00a0\u00bb =’https:\/\/magicsw365.sharepoint.com\/sites\/MSEFRANCE\/FRANCE’)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

8\/ To list the items, make a GET<\/strong> with this kind of URL : ‘\/sites\/{IDSite}\/lists\/{IDList}\/items<\/strong>‘<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

9\/ If you want to retrieve only the SubFolders list, parse the JSON Response like below<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

10\/ If you want to download files from sharepoint Site you can bypass steps 6,7,8 and 9<\/strong>, make a GET<\/strong> with this type of URL first : ‘\/sites\/{IDSite}\/drives<\/strong>‘ to retrieve the driveID<\/p>\n\n\n\n

(*) To get the IDSite, you can make a GET on : https:\/\/graph.microsoft.com\/v1.0\/sites<\/strong> (if you have the right to do it according to your token)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Parse the JSON response and make a filter on your desired site (webURL) to retrieve only 1 driveID<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

11\/ To List the content, <\/p>\n\n\n\n

You have several options :<\/p>\n\n\n\n