public static void CredentialSheetServiceByToken() { if (DriveService == null) { UserCredential credential; using (var stream = new FileStream(credentialPath, FileMode.Open, FileAccess.Read)) { string credPath = "token.json"; credential = GoogleWebAuthorizationBroker.AuthorizeAsync( GoogleClientSecrets.Load(stream).Secrets, new string[] { SheetsService.Scope.Spreadsheets }, "user", CancellationToken.None, new FileDataStore(credPath, true)).Result; Console.WriteLine("Credential file saved to: " + credPath); } // Create Drive API service. var service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); SheetService = service; SheetManager.Init(service); } }
public LiveSpreadsheetsDb(Google.Apis.Sheets.v4.SheetsService apisSheetsService, Google.Apis.Drive.v3.DriveService apisDriveService, string spreadsheetId) { // Assign DBIndex spreadsheet id. this.SpreadsheetsDbSpreadsheetId = spreadsheetId; // Assign provided google apis sheets service this._apisSheetsService = apisSheetsService; // Assign provided google apis sheets service this._apisDriveService = apisDriveService; // Obtains database spreadsheets index. this.ObtainDBSpreadsheetsIndex(); }