我想在ASP MVC项目中实现谷歌分析API v3。因为我从来没有这样做过,所以我做了一个示例控制台应用程序,我已经学会了如何使用这个API,下面是代码:
static void Main(string[] args)
{
var certByteArray = Properties.Resources.key;
var serviceAccountEmail = "IdOfMyAccount@developer.gserviceaccount.com";
var certificate = new X509Certificate2(certByteArray, "pswd", X509KeyStorageFlags.Exportable);
ServiceAccountCredential credential = new ServiceAccountCredential(
new ServiceAccountCredential.Initializer(serviceAccountEmail)
{
Scopes = new[] { AnalyticsService.Scope.Analytics }
}.FromCertificate(certificate));
var service = new AnalyticsService(new BaseClientService.Initializer()
{
HttpClientInitializer = credential,
});
var profileId = "ga:MyID";
var startDate = DateTime.Now.AddDays(-7).ToShortDateString();
var endDate = DateTime.Now.ToShortDateString();
var metrics = "ga:visits,ga:pageviews,ga:users,ga:sessionDuration,ga:bounceRate";
DataResource.GaResource.GetRequest request = service.Data.Ga.Get(profileId, startDate, endDate, metrics);
request.Dimensions = "ga:country";
GaData data = request.Execute();
foreach (var row in data.Rows)
{
int i = 0;
foreach (var h in data.ColumnHeaders)
{
Console.WriteLine(h.Name + " " + row[i].ToString());
// Here get the column name and its values
i++;
}
}
Console.ReadKey();
}
在这个应用程序中一切都很好,我得到的数据非常快。问题开始,当我试图在MVC应用程序中使用此代码。在调试模式下,一切都运行良好,直到我到达
GaData data = request.Execute();
当我按下F10键向前迈出时,似乎应用程序正在工作,浏览器正在等待完成操作,但这并没有发生。在这种情况下,根本不会调用Application_Error方法。在这两个应用程序中,我安装了相同的NuGet包。
有人知道为什么它不工作在ASP MVC吗?
经过几次尝试后,它开始在请求时调用ExecuteAsync方法。这是实际的代码,但我仍然不知道如何使它同步。
public async Task<GaData> GetAnalysisData()
{
var certByteArray = Properties.Resources.key;
var serviceAccountEmail = "MyId@developer.gserviceaccount.com";
var certificate = new X509Certificate2(certByteArray, "notasecret", X509KeyStorageFlags.Exportable);
ServiceAccountCredential credential = new ServiceAccountCredential(
new ServiceAccountCredential.Initializer(serviceAccountEmail)
{
Scopes = new[] { AnalyticsService.Scope.Analytics }
}.FromCertificate(certificate));
var service = new AnalyticsService(new BaseClientService.Initializer()
{
HttpClientInitializer = credential,
});
var profileId = "ga:********";
var startDate = DateTime.Now.AddDays(-7).ToShortDateString();
var endDate = DateTime.Now.ToShortDateString();
var metrics = "ga:visits,ga:pageviews,ga:users,ga:sessionDuration,ga:bounceRate";
DataResource.GaResource.GetRequest request = service.Data.Ga.Get(profileId, startDate, endDate, metrics);
request.Dimensions = "ga:country";
var data = await request.ExecuteAsync();
return data;
}