CODEWITHSUNDEEP
google-apigoogle-oauthgoogle-sheets-apigoogle-api-dotnet-clientgoogle-authentication
Tharunavignesh J
Tharunavignesh J

Reputation: 11

Reusing Google API credentials in GData API

I am trying to make a web application is ASP.NET MVC 5 with which I can authenticate a user with a Google Account and then read data from his/her spreadsheets stored in Google Drive/Google Sheets.

I am using Google API to authenticate a user. After a user is successfully authenticated, I get the credentials back from Google in an object which is of type Google.Apis.Auth.OAuth2.Web AuthResult.UserCredential

I can then successfully create a service to list files from Drive using code similar to

var driveService = new DriveService(new BaseClientService.Initializer { HttpClientInitializer = result.Credential, ApplicationName = "ASP.NET MVC Sample" });

Now, I want to use GData API to read content from spreadsheets in Drive. For this to work, I need to have a SpreadsheetsService object and then set it's RequestFactory parameter to an instance of GOAuth2RequestFactory and this in turn needs OAuth2 parameters to be specified in an instance of class OAuth2Parameters.

How can I reuse the credentials obtained using the Google Api in GData API?

Upvotes: 1

Views: 1248

Answers (2)

Tharunavignesh J
Tharunavignesh J

Reputation: 11

This is the code that finally worked for me 

public class AppFlowMetadata : FlowMetadata
        {
            private static readonly IAuthorizationCodeFlow flow =
                new GoogleAuthorizationCodeFlow(new GoogleAuthorizationCodeFlow.Initializer
                {
                    ClientSecrets = new ClientSecrets
                    {
                        ClientId = "randomstring.apps.googleusercontent.com",
                        ClientSecret = "shhhhhh!"
                    },
                    Scopes = new[] { DriveService.Scope.Drive, "https://spreadsheets.google.com/feeds", "https://docs.google.com/feeds", "https://www.googleapis.com/auth/userinfo.email", "https://www.googleapis.com/auth/userinfo.profile" },
                    DataStore = new FileDataStore("Drive.Api.Auth.Store")
                });

            public override string GetUserId(Controller controller)
            {

                var user = controller.Session["user"];
                if (user == null)
                {
                    user = Guid.NewGuid();
                    controller.Session["user"] = user;
                }
                return user.ToString();
            }

            public override IAuthorizationCodeFlow Flow { get { return flow; } }

        }

And then, in the controller, OAuth2 parameters were copied to GData

var result = await new AuthorizationCodeMvcApp(this, new AppFlowMetadata()).
                AuthorizeAsync(cancellationToken);
OAuth2Parameters parameters = new OAuth2Parameters();
                parameters.ClientId = "somestring.apps.googleusercontent.com";
                parameters.ClientSecret = "shhhhhh!";
                parameters.Scope = result.Credential.Token.Scope;
                parameters.AccessToken = result.Credential.Token.AccessToken;
                parameters.RefreshToken = result.Credential.Token.RefreshToken;

                GOAuth2RequestFactory requestFactory = new GOAuth2RequestFactory(null, "MySpreadsheetIntegration-v1", parameters);

                SpreadsheetsService service = new SpreadsheetsService("MySpreadsheetIntegration-v1");
                service.RequestFactory = requestFactory;

Upvotes: 0

eddyparkinson
eddyparkinson

Reputation: 3700

I am already doing the thing you want to do,

Code for how I passed the GData tokens Issue with OAuth2 authentication with google spreadsheet

i.e. I use a single OAuth2 access/refresh token set. Using the same tokens for both gdata calls & drive API calls.

Upvotes: 1

Related Questions