public async Task RefreshesOidcToken() { // A little bit after the tokens returned from OidcTokenFakes were issued. var clock = new MockClock(new DateTime(2020, 5, 13, 15, 0, 0, 0, DateTimeKind.Utc)); var messageHandler = new OidcTokenResponseSuccessMessageHandler(); var initializer = new ServiceAccountCredential.Initializer("MyId", "http://will.be.ignored") { Clock = clock, ProjectId = "a_project_id", HttpClientFactory = new MockHttpClientFactory(messageHandler) }; var credential = new ServiceAccountCredential(initializer.FromPrivateKey(PrivateKey)); var oidcToken = await credential.GetOidcTokenAsync(OidcTokenOptions.FromTargetAudience("audience")); var signedToken = SignedToken <Header, Payload> .FromSignedToken(await oidcToken.GetAccessTokenAsync()); Assert.Equal("https://first_call.test", signedToken.Payload.Audience); // Move the clock so that the token expires. clock.UtcNow = clock.UtcNow.AddHours(2); signedToken = SignedToken <Header, Payload> .FromSignedToken(await oidcToken.GetAccessTokenAsync()); Assert.Equal("https://subsequent_calls.test", signedToken.Payload.Audience); // Two calls, because the second time we tried to get the token, the first one had expired. Assert.Equal(2, messageHandler.Calls); }
public BaseClientService.Initializer GetInitializer(string accountName = null, params string[] scopes) { var credPath = _google.CredentiaPath; if (string.IsNullOrWhiteSpace(accountName)) { accountName = _google.DefaultAccountName; } var originCredential = (ServiceAccountCredential)GoogleCredential.FromFile(credPath) .UnderlyingCredential; var initializer = new ServiceAccountCredential.Initializer(originCredential.Id) { User = accountName, Key = originCredential.Key, Scopes = scopes }; var credential = new ServiceAccountCredential(initializer); return(new BaseClientService.Initializer { ApplicationName = "MyPortal", HttpClientInitializer = credential }); }
private GmailService GetService(string user, TimeSpan timeout) { lock (this.cache) { if (!this.cache.Contains(user)) { ServiceAccountCredential.Initializer initializerInstance = new ServiceAccountCredential.Initializer(this.serviceAccountID) { User = user, Scopes = this.scopes }.FromCertificate(this.x509Certificate); GmailService x = new GmailService(new BaseClientService.Initializer() { HttpClientInitializer = new ServiceAccountCredential(initializerInstance), ApplicationName = "LithnetGoogleAppsLibrary", GZipEnabled = !Settings.DisableGzip, Serializer = new GoogleJsonSerializer(), DefaultExponentialBackOffPolicy = ExponentialBackOffPolicy.None, }); x.HttpClient.Timeout = timeout; this.cache.Add(user, x); if (this.cache.Count > CacheSize) { this.cache.RemoveAt(0); } } return((GmailService)this.cache[user]); } }
private ServiceAccountCredential GetAccountCredential(byte[] p12key, string password, string serviceAccountEmail) { var certificate = new X509Certificate2(p12key, password, X509KeyStorageFlags.Exportable); var serviceAccountCredentialInitializer = new ServiceAccountCredential.Initializer(serviceAccountEmail) { Scopes = new[] { "https://spreadsheets.google.com/feeds", DriveService.Scope.Drive } }.FromCertificate(certificate); var credential = new ServiceAccountCredential(serviceAccountCredentialInitializer); Wait.UntilNoException(() => { if (!credential.RequestAccessTokenAsync(System.Threading.CancellationToken.None).Result) { throw new InvalidOperationException("Access token request failed."); } }, 60 * 1000); return(credential); }
public BaseClientService.Initializer GetInitializer(string accountName = null) { var credPath = _config.GetValue <string>("GSuiteIntegration:CredentialPath"); if (string.IsNullOrWhiteSpace(accountName)) { accountName = _config.GetValue <string>("GSuiteIntegration:DefaultAccountName"); } var originCredential = (ServiceAccountCredential)GoogleCredential.FromFile(credPath) .UnderlyingCredential; var initializer = new ServiceAccountCredential.Initializer(originCredential.Id) { User = accountName, Key = originCredential.Key, Scopes = _scopes }; var credential = new ServiceAccountCredential(initializer); return(new BaseClientService.Initializer { ApplicationName = "MyPortal", HttpClientInitializer = credential }); }
private static SheetsService UserCredential() { try { ServiceAccountCredential credential1; string[] Scopes = { SheetsService.Scope.Spreadsheets }; string serviceAccountEmail = "*****@*****.**"; string jsonfile = "trackingNewData.json"; using (Stream stream = new FileStream(@jsonfile, FileMode.Open, FileAccess.Read, FileShare.Read)) { credential1 = (ServiceAccountCredential) GoogleCredential.FromStream(stream).UnderlyingCredential; var initializer = new ServiceAccountCredential.Initializer(credential1.Id) { User = serviceAccountEmail, Key = credential1.Key, Scopes = Scopes }; credential1 = new ServiceAccountCredential(initializer); } var service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential1, ApplicationName = "", }); return(service); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }
public async Task FetchesOidcToken() { // A little bit after the tokens returned from OidcTokenFakes were issued. var clock = new MockClock(new DateTime(2020, 5, 13, 15, 0, 0, 0, DateTimeKind.Utc)); var messageHandler = new OidcTokenResponseSuccessMessageHandler(); var initializer = new ServiceAccountCredential.Initializer("MyId", "http://will.be.ignored") { Clock = clock, ProjectId = "a_project_id", HttpClientFactory = new MockHttpClientFactory(messageHandler) }; var credential = new ServiceAccountCredential(initializer.FromPrivateKey(PrivateKey)); // The fake Oidc server returns valid tokens (expired in the real world for safety) // but with a set audience that lets us know if the token was refreshed or not. var oidcToken = await credential.GetOidcTokenAsync(OidcTokenOptions.FromTargetAudience("will.be.ignored")); var signedToken = SignedToken <Header, Payload> .FromSignedToken(await oidcToken.GetAccessTokenAsync()); Assert.Equal("https://first_call.test", signedToken.Payload.Audience); // Move the clock some but not enough that the token expires. clock.UtcNow = clock.UtcNow.AddMinutes(20); signedToken = SignedToken <Header, Payload> .FromSignedToken(await oidcToken.GetAccessTokenAsync()); Assert.Equal("https://first_call.test", signedToken.Payload.Audience); // Only the first call should have resulted in a request. The second time the token hadn't expired. Assert.Equal(1, messageHandler.Calls); }
public async Task JwtCache_Size() { var clock = new MockClock { UtcNow = new DateTime(2016, 1, 1, 0, 0, 0, DateTimeKind.Utc) }; var initializer = new ServiceAccountCredential.Initializer("some-id") { Clock = clock }.FromPrivateKey(PrivateKey); var cred = new ServiceAccountCredential(initializer); Assert.False(cred.HasScopes); // Must be false for the remainder of this test to be valid. // Check JWTs removed from cache once cache fills up. var jwt0 = await cred.GetAccessTokenForRequestAsync("uri0"); for (int i = 0; i < ServiceAccountCredential.JwtCacheMaxSize; i++) { await cred.GetAccessTokenForRequestAsync($"uri{i}"); // Check jwt is retrieved from cache. var jwt0Cached = await cred.GetAccessTokenForRequestAsync("uri0"); Assert.Same(jwt0, jwt0Cached); } // Add one more JWT to cache that should remove jwt0 from the cache. await cred.GetAccessTokenForRequestAsync("uri_too_much"); var jwt0Uncached = await cred.GetAccessTokenForRequestAsync("uri0"); Assert.NotSame(jwt0, jwt0Uncached); }
private ServiceAccountCredential getServiceAccountCredential(String pathToJsonFile, String emailToImpersonate) { // Load and deserialize credential parameters from the specified JSON file. JsonCredentialParameters parameters; using (Stream json = new FileStream(pathToJsonFile, FileMode.Open, FileAccess.Read)) { parameters = NewtonsoftJsonSerializer.Instance.Deserialize <JsonCredentialParameters>(json); } // Create a credential initializer with the correct scopes. ServiceAccountCredential.Initializer initializer = new ServiceAccountCredential.Initializer(parameters.ClientEmail) { Scopes = OAuthScopes }; // Configure impersonation (if applicable). if (!String.IsNullOrEmpty(emailToImpersonate)) { initializer.User = emailToImpersonate; } // Create a service account credential object using the deserialized private key. ServiceAccountCredential credential = new ServiceAccountCredential(initializer.FromPrivateKey(parameters.PrivateKey)); return(credential); }
private ServiceAccountCredential CreateServiceAccountCredential(IHttpClientFactory httpClientFactory, IFcmClientSettings settings) { var serviceAccountCredential = GoogleCredential.FromJson(settings.Credentials) // We need the Messaging Scope: .CreateScoped("https://www.googleapis.com/auth/firebase.messaging") // Cast to the ServiceAccountCredential: .UnderlyingCredential as ServiceAccountCredential; if (serviceAccountCredential == null) { throw new Exception($"Error creating ServiceAccountCredential from JSON File {settings.Credentials}"); } var initializer = new ServiceAccountCredential.Initializer(serviceAccountCredential.Id, serviceAccountCredential.TokenServerUrl) { User = serviceAccountCredential.User, AccessMethod = serviceAccountCredential.AccessMethod, Clock = serviceAccountCredential.Clock, Key = serviceAccountCredential.Key, Scopes = serviceAccountCredential.Scopes, HttpClientFactory = httpClientFactory }; return(new ServiceAccountCredential(initializer)); }
public void Foo5() { //GoogleCredential credential; var keyFilePath = "../../Test/SgxProject-c88a95424dbd.p12"; const string user = "******"; var certificate = new X509Certificate2(keyFilePath, "notasecret", X509KeyStorageFlags.Exportable); var serviceAccountCredentialInitializer = new ServiceAccountCredential.Initializer(user) { //Scopes = new[] { SheetsService.Scope.Drive, SheetsService.Scope.Spreadsheets, DriveService.Scope.Drive, "https://docs.google.com/feeds", "https://spreadsheets.google.com/feeds" } Scopes = new[] { SheetsService.Scope.Drive, SheetsService.Scope.Spreadsheets, "https://docs.google.com/feeds", "https://spreadsheets.google.com/feeds" } }.FromCertificate(certificate); var credential = new ServiceAccountCredential(serviceAccountCredentialInitializer); if (!credential.RequestAccessTokenAsync(System.Threading.CancellationToken.None).Result) { throw new InvalidOperationException("Access token request failed."); } // Create Google Sheets API service. var service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); // Define request parameters. String spreadsheetId = "1u3wBMRwj09MvRaXd817p2zcqwTmRgjeYKYNsUKMwsnc";//Demo2 //String range = "Sheet1!D5"; // single cell D5 String range = "Sheet1!A5"; //String myNewCellValue = "Tom"; ValueRange valueRange = new ValueRange(); //valueRange.Range = "Sheet1!A5"; valueRange.Values = new List <IList <object> > { new List <object> { "A", "B" } }; //{ new List<object>{ 1, 2, 3 } , new List<object> { 4, 5, 6 } }; //IList<IList<object>> xx = new List<IList<object>>(); //xx.Add(new List<object> { "test" }); //valueRange.Values = xx; var request = service.Spreadsheets.Values.Update(valueRange, spreadsheetId, range); request.ValueInputOption = SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.RAW; //var request = service.Spreadsheets.Values.Get(spreadsheetId, range); // Prints the names and majors of students in a sample spreadsheet: // https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit var response = request.Execute(); //IList<IList<Object>> values = response..Values; //Console.WriteLine(values); }
public void Pkcs8Decoding_FromPrivateKey() { // This is a service credential, as downloaded from the Cloud Console on 2016-12-08 string dummyServiceAccountCredentialFileContents = @" { ""type"": ""service_account"", ""private_key_id"": ""71bb487f3414f923196c5c433cf20a8c0f689562"", ""private_key"": ""-----BEGIN PRIVATE KEY----- MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDQvitimRPWE2YM tOADu3jb89UQmqZz8ao6NFoAjYiYDdg/6UBUTscQwGb6rIvllMtcT6BdS4rMKUwv kSQFbO14gi7FiZBj4eJKveObVnt9RPxqT1txBieEPFtgJalh0GpyCo5GUmadgqe+ 89ZF+VQBFE2hMoZhBny/FDba2/qDIk1GmksdXjC67ZI0EYRCGI71eXjOpQX/wOJs tosMQRSTHjPKhZKvZTtjksMRWm8SlQoyORZKXsV6OGKztOieIvncKoX3lrkSupax J+v0yYQJIF2uTFDbbCDL86bgUJ7TyZJ9X1AvrnHGNWp+QzQBDbTCMpZCuY81ARdu BHeacqR3AgMBAAECggEAK7Cx+fgaO8Nhp6UwAff6KudVIB2OW1QokfglIlp9TX4Q VggnC75VUf9DTpJQ0aOcEN0lroFCMssuBAK37F7JMWDmEzhgvVco+wXVnsyyGh0X S9UCSZzFJptPcMdRNYTe0rG856EVk0AmhgQZRBoUaAls2iFuGN63u3KqrJJAU7O4 MPofQizwNcMmiDqRV0rnU6HgmIRQ64hMMh1bnnw4I35esOXjO1O2PiwyyK0jHuVz eBNeD0wEXNLIP4CqDsQ0DKyBPKXZW4bmFnluq4s+VvgPMczUli7Ph0bM7G1oR0LF nZk8tSO9cZ4lLcZpY5mHg7lHzSE6oPAxrkPYoa+6IQKBgQD6I7KaUcmkQj+vOQ18 sZCA28tXqjW2cGB4ThqG2uYeHK8khhjh/Pj07TFr8Xjpz1gNr1NNBJhR9Qs/dO9N WCXS6s0fsVz/gm8N36w7kcBe+Uo43UIt3U6xvZVG4eJYWe2B5+0sZeXzMfzGhwug VkinOJ0CoVpGFTByPrn17O9T8QKBgQDVoi5AO7jvL3nxLQyfXy6XhkHvmnrRU5hV eHrgO2+0TsjAHNRhGGrKTMDqCrMvJqxXbXAwNIKxPdzGCXjam4QzaXgp8+bJWHNe UNRfbWUxVo/Mzfp4owN6oCOVN2cTrnz/doFhuT1LjDj2KK5+hY6qtleH+h00XjCi 0xrTGCpG5wKBgDy0pya+jKI5lb0Pqo9FhJ1ROkM3QrvZAACSa+uoekp6iaLijG1j +INwgRsCSmbr9CG2GBBL+i+Buc4Xse/iYaOTal6zq68y14LVcrYuRDKIa5PrVqFM 4UlPikfekBEDGhn50FyDClCAJCmGIrMx3YX/vlMiF4eEovJG+NiPPPHxAoGBANQq qKJ0bbtmPEYQxot1HTGxTcSneDhyPEUOTYJqpQq+f9OEDkyL0msthR4rGD/Iubpu XtARJobeeGdZuuPpNYdVxNhteZQXuyQ9RF2tqKUyYcg1/P5YbzkW15/3EPDUByIz UFV8geqIzX1zc7EF9WWHiDDsbpq2vLjIzcg+JKabAoGAI7kuoGBdvIHne3Y3tucQ JzcnYI3bppbhyn1dmm8jsaaWrtBvFqCb1y1MjaoL4lNi+brdd6bpV5u447GBQfG8 o3L1luXTksRPmwh5NbhXWl/ieiWc6WQL6sr8Q+vSYDKAo95zdhWJvWs+/v7NfWoF lK1DcBvq+IFLucBdi0/9hXE= -----END PRIVATE KEY-----"", ""client_email"": ""CLIENT_EMAIL"", ""client_id"": ""112326926692598796719"" }"; var credentialParameters = NewtonsoftJsonSerializer.Instance.Deserialize <JsonCredentialParameters>(dummyServiceAccountCredentialFileContents); var initializer = new ServiceAccountCredential.Initializer(credentialParameters.ClientEmail) { Clock = new MockClock { UtcNow = new DateTime(2016, 1, 1, 0, 0, 0, DateTimeKind.Utc) } }; initializer.FromPrivateKey(credentialParameters.PrivateKey); var ps = initializer.Key.ExportParameters(true); Assert.Equal("D0BE2B629913D613660CB4E003BB78DBF3D5109AA673F1AA3A345A008D88980DD83FE940544EC710C066FAAC8BE594CB5C4FA05D4B8ACC294C2F9124056CED78822EC5899063E1E24ABDE39B567B7D44FC6A4F5B710627843C5B6025A961D06A720A8E4652669D82A7BEF3D645F95401144DA1328661067CBF1436DADBFA83224D469A4B1D5E30BAED9234118442188EF57978CEA505FFC0E26CB68B0C4114931E33CA8592AF653B6392C3115A6F12950A3239164A5EC57A3862B3B4E89E22F9DC2A85F796B912BA96B127EBF4C98409205DAE4C50DB6C20CBF3A6E0509ED3C9927D5F502FAE71C6356A7E4334010DB4C2329642B98F3501176E04779A72A477", ToHex(ps.Modulus)); Assert.Equal("010001", ToHex(ps.Exponent)); Assert.Equal("2BB0B1F9F81A3BC361A7A53001F7FA2AE755201D8E5B542891F825225A7D4D7E105608270BBE5551FF434E9250D1A39C10DD25AE814232CB2E0402B7EC5EC93160E6133860BD5728FB05D59ECCB21A1D174BD502499CC5269B4F70C7513584DED2B1BCE7A115934026860419441A1468096CDA216E18DEB7BB72AAAC924053B3B830FA1F422CF035C326883A91574AE753A1E0988450EB884C321D5B9E7C38237E5EB0E5E33B53B63E2C32C8AD231EE57378135E0F4C045CD2C83F80AA0EC4340CAC813CA5D95B86E616796EAB8B3E56F80F31CCD4962ECF8746CCEC6D684742C59D993CB523BD719E252DC66963998783B947CD213AA0F031AE43D8A1AFBA21", ToHex(ps.D)); Assert.Equal("FA23B29A51C9A4423FAF390D7CB19080DBCB57AA35B67060784E1A86DAE61E1CAF248618E1FCF8F4ED316BF178E9CF580DAF534D049851F50B3F74EF4D5825D2EACD1FB15CFF826F0DDFAC3B91C05EF94A38DD422DDD4EB1BD9546E1E25859ED81E7ED2C65E5F331FCC6870BA05648A7389D02A15A461530723EB9F5ECEF53F1", ToHex(ps.P)); Assert.Equal("D5A22E403BB8EF2F79F12D0C9F5F2E978641EF9A7AD1539855787AE03B6FB44EC8C01CD461186ACA4CC0EA0AB32F26AC576D70303482B13DDCC60978DA9B8433697829F3E6C958735E50D45F6D6531568FCCCDFA78A3037AA02395376713AE7CFF768161B93D4B8C38F628AE7E858EAAB65787FA1D345E30A2D31AD3182A46E7", ToHex(ps.Q)); Assert.Equal("3CB4A726BE8CA23995BD0FAA8F45849D513A433742BBD90000926BEBA87A4A7A89A2E28C6D63F88370811B024A66EBF421B618104BFA2F81B9CE17B1EFE261A3936A5EB3ABAF32D782D572B62E4432886B93EB56A14CE1494F8A47DE9011031A19F9D05C830A508024298622B331DD85FFBE5322178784A2F246F8D88F3CF1F1", ToHex(ps.DP)); Assert.Equal("D42AA8A2746DBB663C4610C68B751D31B14DC4A77838723C450E4D826AA50ABE7FD3840E4C8BD26B2D851E2B183FC8B9BA6E5ED0112686DE786759BAE3E9358755C4D86D799417BB243D445DADA8A53261C835FCFE586F3916D79FF710F0D407223350557C81EA88CD7D7373B105F565878830EC6E9AB6BCB8C8CDC83E24A69B", ToHex(ps.DQ)); Assert.Equal("23B92EA0605DBC81E77B7637B6E710273727608DDBA696E1CA7D5D9A6F23B1A696AED06F16A09BD72D4C8DAA0BE25362F9BADD77A6E9579BB8E3B18141F1BCA372F596E5D392C44F9B087935B8575A5FE27A259CE9640BEACAFC43EBD2603280A3DE73761589BD6B3EFEFECD7D6A0594AD43701BEAF8814BB9C05D8B4FFD8571", ToHex(ps.InverseQ)); }
public static ServiceAccountCredential FromServiceAccountDataWithScopesTokenServerUrl(Stream credentialData, IEnumerable <string> scopes, string tokenServerUrl) { var parameters = NewtonsoftJsonSerializer.Instance.Deserialize <JsonCredentialParameters>(credentialData); var initializer = new ServiceAccountCredential.Initializer(parameters.ClientEmail, tokenServerUrl).FromPrivateKey(parameters.PrivateKey); initializer.Scopes = scopes; return(new ServiceAccountCredential(initializer)); }
public static void Execute(IList <IList <object> > list) { //UserCredential credential; string assembly = Utils.AssemblyDirectory; string file = "dynamosheets.json"; //string file = "credentials.json"; string path = Path.GetFullPath(Path.Combine(assembly, @"..\", file)); string credPath = Path.GetFullPath(Path.Combine(assembly, @"..\", "token.json")); //var certificate = new X509Certificate2(@"key.p12", "notasecret", X509KeyStorageFlags.Exportable); ServiceAccountCredential credential; string[] Scopes = { SheetsService.Scope.Spreadsheets }; string serviceAccountEmail = "*****@*****.**"; using (Stream stream = new FileStream(path, FileMode.Open, FileAccess.Read, FileShare.Read)) { credential = (ServiceAccountCredential) GoogleCredential.FromStream(stream).UnderlyingCredential; var initializer = new ServiceAccountCredential.Initializer(credential.Id) { User = serviceAccountEmail, Key = credential.Key, Scopes = Scopes }; credential = new ServiceAccountCredential(initializer); } // Create Google Sheets API service. var service = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); // Define request parameters. // @todo Fetch these from a config.json file or environment variables? String spreadsheetId = "1A7W8jXxCBpdluOqoOSpVATHcVtDlozI8WicGN1siYRc"; String spreadsheetTab = "Sheet1"; // Define the sheet range var rng = string.Format("{0}!A1:A{1}", spreadsheetTab, list.Count); var vRange = new ValueRange { Range = rng, Values = list, MajorDimension = "ROWS" }; // Send the request to the Google Sheets API var rqst = service.Spreadsheets.Values.Append(vRange, spreadsheetId, rng); rqst.ValueInputOption = SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum.USERENTERED; rqst.Execute(); // @todo We need to check the request was actually sent successfully and gracefully deal with cases where the API is unavailable or a 403 forbidden occurs }
public static List <SpotifyInfo> GetAllSongsFromStaticSheetVN() { try { ServiceAccountCredential credential1; string[] Scopes = { SheetsService.Scope.Spreadsheets }; string serviceAccountEmail = "*****@*****.**"; string jsonfile = "trackingNewData.json"; string spreadsheetID = "1k0G4J_HXLzOvaOvoUPHt8m7S-ogMxaeF53SE6ZfgXfo"; string range = "Danh sách nhạc tổng!A2:K"; using (Stream stream = new FileStream(@jsonfile, FileMode.Open, FileAccess.Read, FileShare.Read)) { credential1 = (ServiceAccountCredential) GoogleCredential.FromStream(stream).UnderlyingCredential; var initializer = new ServiceAccountCredential.Initializer(credential1.Id) { User = serviceAccountEmail, Key = credential1.Key, Scopes = Scopes }; credential1 = new ServiceAccountCredential(initializer); } var serices = new SheetsService(new BaseClientService.Initializer() { HttpClientInitializer = credential1, ApplicationName = ApplicationName, }); SpreadsheetsResource.ValuesResource.GetRequest.ValueRenderOptionEnum valueRenderOption = (SpreadsheetsResource.ValuesResource.GetRequest.ValueRenderOptionEnum) 0; SpreadsheetsResource.ValuesResource.GetRequest.DateTimeRenderOptionEnum dateTimeRenderOption = (SpreadsheetsResource.ValuesResource.GetRequest.DateTimeRenderOptionEnum) 0; SpreadsheetsResource.ValuesResource.GetRequest request = serices.Spreadsheets.Values.Get(spreadsheetID, range); request.ValueRenderOption = valueRenderOption; request.DateTimeRenderOption = dateTimeRenderOption; // To execute asynchronously in an async method, replace `request.Execute()` as shown: Data.ValueRange response = request.Execute(); IList <IList <Object> > values = response.Values; List <SpotifyInfo> listSongs = new List <SpotifyInfo>(); foreach (var item in values) { if (item.Count >= 6) { SpotifyInfo song = new SpotifyInfo(); song.TrackTitle = item[4].ToString(); song.Artists = item[5].ToString(); song.Range = "I" + (values.IndexOf(item) + 2).ToString() + ":" + "J" + (values.IndexOf(item) + 2).ToString(); listSongs.Add(song); } } return(listSongs); } catch (Exception ex) { return(null); } }
private ServiceAccountCredential GetServiceAccount() { var initializer = new ServiceAccountCredential.Initializer(_options.ClientEmail) { ProjectId = _options.ProjectId }; return(new ServiceAccountCredential(initializer.FromPrivateKey(_options.PrivateKey))); }
private IConfigurableHttpClientInitializer ServiceAccountInitializer() { var svcInit = new ServiceAccountCredential.Initializer(_config.CredentialParameters.ClientEmail) { Scopes = new[] { DriveService.Scope.Drive } }; return(new ServiceAccountCredential(svcInit.FromPrivateKey(_config.CredentialParameters.PrivateKey))); }
private ServiceAccountCredential GetCredentials() { var initializer = new ServiceAccountCredential.Initializer(configuration.GoogleClientEmail); initializer.Scopes = Scopes; var result = new ServiceAccountCredential(initializer.FromPrivateKey(configuration.GoogleClientPrivateKey)); return(result); }
public override GoogleCredential CreateScoped(IEnumerable <string> scopes) { var serviceAccountCredential = credential as ServiceAccountCredential; var initializer = new ServiceAccountCredential.Initializer(serviceAccountCredential) { Scopes = scopes }; return(new ServiceAccountGoogleCredential(new ServiceAccountCredential(initializer))); }
public override GoogleCredential CreateWithUser(string user) { var serviceAccountCredential = credential as ServiceAccountCredential; var initializer = new ServiceAccountCredential.Initializer(serviceAccountCredential) { User = user }; return(new ServiceAccountGoogleCredential(new ServiceAccountCredential(initializer))); }
public string GetCoverUrl(string userId, int bookId, string coverName) { var coverPath = $"{_baseBookPath}{userId}/{bookId}/{coverName}"; var initializer = new ServiceAccountCredential.Initializer(_googleCloudStorageSettings.Id); UrlSigner urlSgSigner = UrlSigner.FromServiceAccountCredential( new ServiceAccountCredential(initializer.FromPrivateKey(_googleCloudStorageSettings.PrivateKey))); string url = urlSgSigner.Sign(_googleCloudStorageSettings.BucketName, coverPath, TimeSpan.FromDays(5)); return(url); }
public string GetDownloadUrl(string userId, int bookId, string bookFileName) { var bookPath = $"{_baseBookPath}{userId}/{bookId}/{bookFileName}"; var initializer = new ServiceAccountCredential.Initializer(_googleCloudStorageSettings.Id); UrlSigner urlSgSigner = UrlSigner.FromServiceAccountCredential( new ServiceAccountCredential(initializer.FromPrivateKey(_googleCloudStorageSettings.PrivateKey))); string url = urlSgSigner.Sign(_googleCloudStorageSettings.BucketName, bookPath, TimeSpan.FromMinutes(10), HttpMethod.Get); return(url); }
static void Main() { var certificate = new X509Certificate2(Key, "notasecret", X509KeyStorageFlags.Exportable); var initializer = new ServiceAccountCredential.Initializer(ServiceAccountEmail) { Scopes = new[] { DriveService.Scope.Drive }, User = ImpersonatedAccountEmail }; var credential = new ServiceAccountCredential(initializer.FromCertificate(certificate)); var driveService = new DriveService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName }); // Show all files var list = driveService.Files.List().Execute(); if (list.Items != null) { foreach (var fileItem in list.Items) { Console.WriteLine(fileItem.Title + " - " + fileItem.Description); } } Console.WriteLine("Press Enter to continue."); Console.ReadLine(); // Upload a new file File body = new File(); body.Title = "whakingly.txt"; body.Description = "A whakingly (that a new word I created just there) file thats uploaded with impersonation"; body.MimeType = "text/plain"; byte[] byteArray = System.IO.File.ReadAllBytes(FileToUpload); var stream = new System.IO.MemoryStream(byteArray); FilesResource.InsertMediaUpload request = driveService.Files.Insert(body, stream, "text/plain"); request.Upload(); File file = request.ResponseBody; Console.WriteLine("Press Enter to continue."); Console.ReadLine(); // Show all files var list2 = driveService.Files.List().Execute(); if (list2.Items != null) { foreach (var fileItem in list2.Items) { Console.WriteLine(fileItem.Title + " - " + fileItem.Description); } } Console.WriteLine("Press Enter to continue."); Console.ReadLine(); }
private static ServiceAccountCredential.Initializer InitializeAccount(String clientEmail) { var accountInitializer = new ServiceAccountCredential.Initializer(clientEmail) { Scopes = new List <string> { "https://www.googleapis.com/auth/cloudprint" } }; return(accountInitializer); }
private static string CreateSignature(string data, ServiceAccountCredential.Initializer initializer) { // TODO: This is taken from ServiceAccountCredential. Expose this somehow so we don't need to duplicate logic. using (var hashAlg = SHA256.Create()) { byte[] assertionHash = hashAlg.ComputeHash(Encoding.UTF8.GetBytes(data)); #if NETSTANDARD1_3 var sigBytes = initializer.Key.SignHash(assertionHash, HashAlgorithmName.SHA256, RSASignaturePadding.Pkcs1); #else const string Sha256Oig = "2.16.840.1.101.3.4.2.1"; var sigBytes = initializer.Key.SignHash(assertionHash, Sha256Oig); #endif return(WebUtility.UrlEncode(Convert.ToBase64String(sigBytes))); } }
public ServiceAccountCredential GetCredential() { var serviceAccountEmail = ConfigurationHelper.GetAppSettingsValue(_serviceAccountEmailPropertyName); var certificatePath = ConfigurationHelper.GetAppSettingsValue(_certificatePathPropertyName); var certificatePassphrase = ConfigurationHelper.GetAppSettingsValue(_certificatePassphrasePropertyName); var certificate = new X509Certificate2(certificatePath, certificatePassphrase, X509KeyStorageFlags.Exportable); var credentialInitializer = new ServiceAccountCredential.Initializer(serviceAccountEmail) { Scopes = new[] { ShoppingContentService.Scope.Content } }.FromCertificate(certificate); return(new ServiceAccountCredential(credentialInitializer)); }
public GoogleDriveManager() { var initializer = new ServiceAccountCredential.Initializer(ConfigurationManager.AppSettings["GoogleDriveServiceAccountEmail"].ToString()) { Scopes = new string[] { DriveService.Scope.Drive } }; var credential = new ServiceAccountCredential(initializer.FromPrivateKey(ConfigurationManager.AppSettings["GoogleDrivePrivateKey"].ToString())); service = new DriveService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ConfigurationManager.AppSettings["GoogleDriveApplicationName"].ToString(), }); service.HttpClient.Timeout = TimeSpan.FromMinutes(100); }
private ServiceAccountCredential GetServiceAccountCredential() { using (Stream stream = new FileStream("configs/service_account_secret.json", FileMode.Open, FileAccess.Read, FileShare.Read)) { var credential = (ServiceAccountCredential) GoogleCredential.FromStream(stream).UnderlyingCredential; var initializer = new ServiceAccountCredential.Initializer(credential.Id) { User = serviceAccount, Key = credential.Key, Scopes = scopes }; return(new ServiceAccountCredential(initializer)); } }
private static void Main(string[] args) { // See the README.md for details of these fields. // Retrieved from https://console.developers.google.com var ServiceKeyFilePath = "PATH TO JSON KEY FILE HERE"; // Name of the buyer resource for which the API call is being made. var buyerName = "INSERT_BUYER_RESOURCE_NAME_HERE"; // Retrieve credential parameters from the key JSON file. var credentialParameters = NewtonsoftJsonSerializer.Instance .Deserialize <JsonCredentialParameters>( System.IO.File.ReadAllText(ServiceKeyFilePath)); // Create the credentials. var credentialInitializer = new ServiceAccountCredential.Initializer( credentialParameters.ClientEmail) { Scopes = new[] { RealTimeBiddingService.Scope.RealtimeBidding } }.FromPrivateKey(credentialParameters.PrivateKey); var oAuth2Credentials = new ServiceAccountCredential(credentialInitializer); // Use the credentials to create a client for the API service. var serviceInitializer = new BaseClientService.Initializer { HttpClientInitializer = oAuth2Credentials, ApplicationName = "FirstAPICall" }; var realtimebidding = new RealTimeBiddingService(serviceInitializer); // Call the buyers.creatives.list method to list creatives for the given buyer. BuyersResource.CreativesResource.ListRequest request = realtimebidding.Buyers.Creatives.List(buyerName); request.View = BuyersResource.CreativesResource.ListRequest.ViewEnum.FULL; IList <Creative> creatives = request.Execute().Creatives; foreach (Creative creative in creatives) { Console.WriteLine("* Creative name: {0}", creative.Name); } Console.ReadLine(); }
public async Task ValidLocallySignedAccessToken_FromPrivateKey() { const string dummyServiceAccountCredentialFileContents = @"{ ""private_key_id"": ""PRIVATE_KEY_ID"", ""private_key"": ""-----BEGIN PRIVATE KEY----- MIICdgIBADANBgkqhkiG9w0BAQEFAASCAmAwggJcAgEAAoGBAJJM6HT4s6btOsfe 2x4zrzrwSUtmtR37XTTi0sPARTDF8uzmXy8UnE5RcVJzEH5T2Ssz/ylX4Sl/CI4L no1l8j9GiHJb49LSRjWe4Yx936q0Xj9H0R1HTxvjUPqwAsTwy2fKBTog+q1frqc9 o8s2r6LYivUGDVbhuUzCaMJsf+x3AgMBAAECgYEAi0FTXsu/zRswAUGaViQiHjrL uU65BSHXNVjV/2fLNEKnGWGqpli68z1IXY+S2nwbUak7rnGsq9/0F6jtsW+hZbLk KXUOuuExpeC5Kd6ngWX/f2jqmhlUabiQijU9cVk7pMq8EHkRtvlosnMTUAEzempu QUPwn1PZHhmJkBvZ4lECQQDCErrxl+e3BwUDcS0yVEEmCNSG6xdXs2878b8rzbe7 3Mmi6SuuOLi3PU92J+j+f/MOdtYrk13mEDdYmd5dhrt5AkEAwPvDEsDT/W4y4h5n gv1awGBA5aLFE1JNWM/Gwn4D1cGpEDHKFREaBtxMDCASpHJuw8r7zUywpKhmBZcf GS37bwJANdSAKfbafLfjuhqwUJ9yGpykZm/a36aTmerp/bpn1iHdg+RtCzwMcDb/ TWSwibbvsflgWmHbz657y4WSWhq+8QJAWrpCNN/ZCk2zuGDo80lfUBAwkoVat8G6 wWU1oZyS+vzIGef+hLb8kHsjeZPej9eIwZ39kcBbT54oELrCkRjwGwJAQ8V2A7lT ZUp8AsbVqF6rbLiiUfJMo2btGclQu4DEVyS+ymFA65tXDLUuR9EDqJYdqHNZJ5B8 4Z5p2prkjWTLcA== -----END PRIVATE KEY-----"", ""client_email"": ""CLIENT_EMAIL"", ""client_id"": ""CLIENT_ID"", ""type"": ""service_account""}"; var credentialParameters = NewtonsoftJsonSerializer.Instance.Deserialize <JsonCredentialParameters>(dummyServiceAccountCredentialFileContents); var initializer = new ServiceAccountCredential.Initializer(credentialParameters.ClientEmail) { Clock = new MockClock { UtcNow = new DateTime(2016, 1, 1, 0, 0, 0, DateTimeKind.Utc) } }; var cred = new ServiceAccountCredential(initializer.FromPrivateKey(credentialParameters.PrivateKey)); Assert.False(cred.Scopes?.Any()); // HasScopes must be false for the type of access token we want to test. string accessToken = await cred.GetAccessTokenForRequestAsync("http://authurl/"); string expectedToken = "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJDTElFTlRfRU1BSUwiLCJz" + "dWIiOiJDTElFTlRfRU1BSUwiLCJhdWQiOiJodHRwOi8vYXV0aHVybC8iLCJleHAiOjE0N" + "TE2MTAwMDAsImlhdCI6MTQ1MTYwNjQwMH0.WLljSaAqxMVZnAxFA2SvpA3n2WRlQW71Nb" + "CUkbN-ZI-EWoL-HhgiV_3ISrXMvbDHYhBR0vvtXE0PcRcsMEf51Y0jV4DXZ8hf-QJFq7O" + "Hrepwe93dnDE6uNVnbj41_0phuy1WKwae29Qp2aPI2Y8E8Z2tXQlF87E_MdgjXVeTF8k"; Assert.Equal(expectedToken, accessToken); }