如何使用OAuth2授权Google anlaytics数据api

Question

我正在尝试使用C#连接到新的Google Analytics Data api以从新的Google Analytics GA4请求数据。我能找到的唯一示例是Quickstart客户端库. net这确实有效，但它使用服务号。云. net客户端库google-cloud d-dotnet只有使用服务号的示例。

当我试图传递使用Oauth的桌面应用程序凭据时，我得到

从JSON创建凭据时出错。无法识别的凭据类型。

using System;
using System.Threading;
using System.Threading.Tasks;
using Google.Analytics.Data.V1Beta;

namespace GoogleAnalyticsExamplesData
{
    class Program
    {
        private const string PropertyId = "250796939";
        private const string PathToCreds = @"C:\dev\ServiceAccountCred.json";

        static async Task Main(string[] args)
        {
            Console.WriteLine("Hello World!");

            // Check whether the environment variable exists.
            var environmentVariable = Environment.GetEnvironmentVariable("GOOGLE_APPLICATION_CREDENTIALS");
            // If necessary, create it.
            if (environmentVariable == null)
                Environment.SetEnvironmentVariable("GOOGLE_APPLICATION_CREDENTIALS", PathToCreds);

            await SampleRunReport(PropertyId);
        }
        
        static async Task SampleRunReport(string propertyId = "YOUR-GA4-PROPERTY-ID")
        {
            // Using a default constructor instructs the client to use the credentials
            // specified in GOOGLE_APPLICATION_CREDENTIALS environment variable.
            var client = await BetaAnalyticsDataClient.CreateAsync(CancellationToken.None);

            var request = new RunReportRequest
            {
                Property = "properties/" + PropertyId,
                Dimensions = {new Dimension {Name = "date"},},
                Metrics = {new Metric {Name = "totalUsers"}, new Metric {Name = "newUsers"}},
                DateRanges = {new DateRange {StartDate = "2021-04-01", EndDate = "today"},},
            };

            var response = await client.RunReportAsync(request);


            Console.WriteLine("Report result:");

            foreach (var row in response.Rows)
            {
                Console.WriteLine(
                    $"{row.DimensionValues[0].Value}, {row.MetricValues[0].Value}, {row.MetricValues[1].Value}");
            }
        }
    }
}

指向Google的链接。分析。数据。V1Beta Web客户端凭据、桌面凭据

Answer 1

经过几个小时的挖掘，我发现你可以使用ICredential的建造者。这适用于已安装应用程序的桌面应用程序凭据。

using System;
using System.IO;
using System.Threading;
using System.Threading.Tasks;
using Google.Analytics.Data.V1Beta;
using Google.Apis.Auth.OAuth2;

using Google.Apis.Util.Store;

namespace GoogleAnalyticsExamplesData
{
    class Program
    {
        private const string PropertyId = "250796939";
        private const string PathToCreds = @"C:\dev\credentials.json";

        static async Task Main(string[] args)
        {
            Console.WriteLine("Hello World!");   
          

            await SampleRunReport(PropertyId);
        }

        static async Task SampleRunReport(string propertyId = "YOUR-GA4-PROPERTY-ID")
        {
            // Using a default constructor instructs the client to use the credentials
            // specified in GOOGLE_APPLICATION_CREDENTIALS environment variable.
            //var client = await BetaAnalyticsDataClient.CreateAsync(CancellationToken.None);

            BetaAnalyticsDataClient client ;
            await using (var stream = new FileStream(PathToCreds, FileMode.Open, FileAccess.Read))
            {
                // Requesting Authentication or loading previously stored authentication for userName
                var credential = GoogleWebAuthorizationBroker.AuthorizeAsync(GoogleClientSecrets.Load(stream).Secrets,
                    new[] { "https://www.googleapis.com/auth/analytics.readonly"},
                    "userName",
                    CancellationToken.None,
                    new FileDataStore("credPath", true)).Result;
                
                client = await new BetaAnalyticsDataClientBuilder
                {
                    TokenAccessMethod = credential.GetAccessTokenForRequestAsync
                }.BuildAsync();
            }

            var request = new RunReportRequest
            {
                Property = "properties/" + PropertyId,
                Dimensions = {new Dimension {Name = "date"},},
                Metrics = {new Metric {Name = "totalUsers"}, new Metric {Name = "newUsers"}},
                DateRanges = {new DateRange {StartDate = "2021-04-01", EndDate = "today"},},
            };

            var response = await client.RunReportAsync(request);


            Console.WriteLine("Report result:");

            foreach (var row in response.Rows)
            {
                Console.WriteLine(
                    $"{row.DimensionValues[0].Value}, {row.MetricValues[0].Value}, {row.MetricValues[1].Value}");
            }
        }
    }
}