public static MTSpreadsheet GetSpreadsheet(string title, GoogleParams p)
{
SpreadsheetsService service = GetService(p);
SpreadsheetQuery query = new SpreadsheetQuery();
query.Title = title;
SpreadsheetFeed feed = service.Query(query);
SpreadsheetEntry spreadsheet = (SpreadsheetEntry)feed.Entries[0];
return(new MTSpreadsheet(spreadsheet, service));
}
private static SpreadsheetsService GetService(GoogleParams p)
{
OAuth2Parameters parameters = new OAuth2Parameters();
parameters.ClientId = p.clientId;
parameters.ClientSecret = p.clientSecret;
parameters.RedirectUri = p.redirectUri;
parameters.Scope = p.scope;
parameters.RefreshToken = p.refreshToken;
OAuthUtil.RefreshAccessToken(parameters);
GOAuth2RequestFactory requestFactory = new GOAuth2RequestFactory(null, "DocReader", parameters);
SpreadsheetsService service = new SpreadsheetsService("DocReader");
service.RequestFactory = requestFactory;
return(service);
}
public static void GetRefreshToken(GoogleParams p)
{
OAuth2Parameters parameters = new OAuth2Parameters();
parameters.ClientId = p.clientId;
parameters.ClientSecret = p.clientSecret;
parameters.RedirectUri = p.redirectUri;
parameters.Scope = p.scope;
string authorizationUrl = OAuthUtil.CreateOAuth2AuthorizationUrl(parameters);
Console.WriteLine(authorizationUrl);
Console.WriteLine("Please visit the URL above to authorize your OAuth "
+ "request token. Once that is complete, type in your access code to "
+ "continue...");
parameters.AccessCode = Console.ReadLine();
OAuthUtil.GetAccessToken(parameters);
Console.WriteLine("OAuth Refresh Token: \n" + parameters.RefreshToken);
}
