Upload & download an excel file from Onedrive using C# razor page

Question

Upload & download an excel file from Onedrive using C# razor page

Amit Patil 0

I am trying to upload & download an excel file to Onedrive using c# razor pages and have tried following code snippets,

// Install Microsoft.Graph SDK 
// Install Microsoft.Identity.Client (MSAL) SDK 
// Authentication 
var confidentialClientApplication = ConfidentialClientApplicationBuilder .
Create("{clientId}") .WithClientSecret("{clientSecret}") .
WithAuthority(new Uri("https://login.microsoftonline.com/{tenantId}")) .Build(); 
var authResult = await confidentialClientApplication.AcquireTokenForClient(new[] { "https://graph.microsoft.com/.default" }).ExecuteAsync(); 
// Access OneDrive API 
var graphServiceClient = new GraphServiceClient(new DelegateAuthenticationProvider((requestMessage) => { requestMessage.Headers.Authorization = new AuthenticationHeaderValue("Bearer", authResult.AccessToken); 
return Task.FromResult(0); })); 
// Upload File 
using (var stream = new FileStream("path_to_file", FileMode.Open)) 
{ await graphServiceClient.Me.Drive.Root.ItemWithPath("file_name.xlsx").Content.Request().PutAsync<DriveItem>(stream); } 
// Download File 
var downloadedFile = await graphServiceClient.Me.Drive.Root.ItemWithPath("file_name.xlsx").Content.Request().GetAsync();

I am using Visual Studio 2022 Professional with Dotnet Framework 8.0

But has encountered the errors like Root is not available under Drive

I have managed to get the authentication token using above code snippet, but unable to upload/download the file.

Please help.

Tiny Wang-MSFT 3,161 Microsoft External Staff

Hi @Amit Patil ， I think we should firstly make the graphServiceClient to be well authenticated so that we could call Graph API successfully first. Then test the OneDrive API. You are having "https://graph.microsoft.com/.default" as the scope, so that I'm afraid you are trying to use client credential flow which requires Application API permission. Please make sure you've added the correct API permissions and grant Admin consent if required.

User's image

Then we can use code below to authorize the GraphServiceClient and test whether it could worked well. My code below will list all the users inside the tenant.

using Microsoft.Graph;
using Azure.Identity;
var scopes = new[] { "https://graph.microsoft.com/.default" };
var tenantId = "tenant_name.onmicrosoft.com";
var clientId = "aad_app_id";
var clientSecret = "client_secret";
var clientSecretCredential = new ClientSecretCredential(
				tenantId, clientId, clientSecret);
var graphClient = new GraphServiceClient(clientSecretCredential, scopes);
var users = await graphClient.Users.GetAsync();

If the code above worked well, then let's try to test OneDrive API.

var graphClient = new GraphServiceClient(clientSecretCredential, scopes);
var userDriveId = await graphClient.Users["yourUserId"].Drive.GetAsync();
var driveItems = await graphClient.Drives["userDriveId"].Items["Root"].Children.GetAsync();
//download file: 
Stream content = await graphClient.Drives["{drive-id}"].Items["{driveItem-id}"].Content.GetAsync();

Amit Patil 0 Reputation points

2024-03-28T14:28:18.8933333+00:00

hi @Tiny Wang-MSFT I have made the graphServiceClient by creating new client id & secret , but the code snippets available are for old version which are deprecated long back and doesn't have any for newer version available. Thanks
Tiny Wang-MSFT 3,161 Reputation points Microsoft External Staff

2024-03-29T06:24:23.7633333+00:00

Hi Amit, could you please share the nuget packages along with the package version with me? My code snippet is based on the V5 Graph SDK which should be the latest version and it's not deprecated.
Amit Patil 0 Reputation points

2024-03-29T14:20:54.66+00:00
I have below versions installed.

and the error I am facing is

Error CS1061 'DriveRequestBuilder' does not contain a definition for 'Root' and no accessible extension method 'Root' accepting a first argument of type 'DriveRequestBuilder' could be found (are you missing a using directive or an assembly reference?)

the code snippet,

using (var stream = File.OpenRead("path-to-your-excel-file"))

{

// Create a new file on OneDrive var uploadResult = await graphServiceClient.Me.Drive.Root.ItemWithPath("your-file-name.xlsx").Content.Request().PutAsync<DriveItem>(stream); ``` } Do you have any other code snippet to upload the file?
Tiny Wang-MSFT 3,161 Reputation points Microsoft External Staff

2024-04-01T01:29:13.39+00:00
Hi Amit, pls try code like this, this is based on the migration guidance.

var driveItems = await graphClient.Drives["userDriveId"].Items["Root"].Children.GetAsync();

Your answer

Tiny Wang-MSFT 3,161 Reputation points Microsoft External Staff

2024-03-28T13:17:40.3766667+00:00

Hi @Amit Patil ， I think we should firstly make the graphServiceClient to be well authenticated so that we could call Graph API successfully first. Then test the OneDrive API. You are having "https://graph.microsoft.com/.default" as the scope, so that I'm afraid you are trying to use client credential flow which requires Application API permission. Please make sure you've added the correct API permissions and grant Admin consent if required.

Then we can use code below to authorize the GraphServiceClient and test whether it could worked well. My code below will list all the users inside the tenant.

using Microsoft.Graph; using Azure.Identity; var scopes = new[] { "https://graph.microsoft.com/.default" }; var tenantId = "tenant_name.onmicrosoft.com"; var clientId = "aad_app_id"; var clientSecret = "client_secret"; var clientSecretCredential = new ClientSecretCredential( tenantId, clientId, clientSecret); var graphClient = new GraphServiceClient(clientSecretCredential, scopes); var users = await graphClient.Users.GetAsync();

If the code above worked well, then let's try to test OneDrive API.

var graphClient = new GraphServiceClient(clientSecretCredential, scopes); var userDriveId = await graphClient.Users["yourUserId"].Drive.GetAsync(); var driveItems = await graphClient.Drives["userDriveId"].Items["Root"].Children.GetAsync(); //download file: Stream content = await graphClient.Drives["{drive-id}"].Items["{driveItem-id}"].Content.GetAsync();
Amit Patil 0 Reputation points

2024-03-28T14:28:18.8933333+00:00

hi @Tiny Wang-MSFT I have made the graphServiceClient by creating new client id & secret , but the code snippets available are for old version which are deprecated long back and doesn't have any for newer version available. Thanks
Tiny Wang-MSFT 3,161 Reputation points Microsoft External Staff

2024-03-29T06:24:23.7633333+00:00

Hi Amit, could you please share the nuget packages along with the package version with me? My code snippet is based on the V5 Graph SDK which should be the latest version and it's not deprecated.
Amit Patil 0 Reputation points

2024-03-29T14:20:54.66+00:00

I have below versions installed.

and the error I am facing is

Error CS1061 'DriveRequestBuilder' does not contain a definition for 'Root' and no accessible extension method 'Root' accepting a first argument of type 'DriveRequestBuilder' could be found (are you missing a using directive or an assembly reference?)

the code snippet,

using (var stream = File.OpenRead("path-to-your-excel-file"))

{

// Create a new file on OneDrive var uploadResult = await graphServiceClient.Me.Drive.Root.ItemWithPath("your-file-name.xlsx").Content.Request().PutAsync<DriveItem>(stream); ``` } Do you have any other code snippet to upload the file?
Tiny Wang-MSFT 3,161 Reputation points Microsoft External Staff

2024-04-01T01:29:13.39+00:00

Hi Amit, pls try code like this, this is based on the migration guidance.

var driveItems = await graphClient.Drives["userDriveId"].Items["Root"].Children.GetAsync();

Share via

Upload & download an excel file from Onedrive using C# razor page

Your answer