java - Hello Analytics API:Java快速入门错误

Question

我正在尝试使用Java从Google Analytics(分析)报告API中访问数据。

我正在遵循“Hello Analytics API: Java quickstart for installed applications”教程，并且做了所有告诉您的事情，并且遇到了以下问题:

com.google.api.client.util.store.FileDataStoreFactory setPermissionsToOwnerOnly
WARNING: unable to change permissions for everybody: C:\Users\<user>\.store\hello_analytics
com.google.api.client.util.store.FileDataStoreFactory setPermissionsToOwnerOnly
WARNING: unable to change permissions for owner: C:\Users\timst\.store\hello_analytics
java.lang.NullPointerException
          at java.io.Reader.<init>(Reader.java:78)
          at java.io.InputStreamReader.<init>(InputStreamReader.java:72)
          at com.example.demo.HelloAnalytics.initializeAnalytics(HelloAnalytics.java:60)
          at com.example.demo.HelloAnalytics.main(HelloAnalytics.java:44)

我尝试使用 client_secret.json的完整路径。
尝试使用我在网上找到的其他方法，但似乎没有任何效果。

在对这个错误感到沮丧之后，我尝试了“ Hello Analytics API: Java quickstart for service accounts”教程。

但是在这里我有一个问题，我无法将用户添加到帐户，媒体资源或无法查看我可以访问的帐户。
我可以访问其他人的分析帐户，并且只能从帐户中删除自己。

我正在使用的所有代码均来自教程，使用 Intellij和 gradle。

tl;dr; All I want to do is access the analytics data for all my accounts, using the reporting API so i can put all this data in my own database and use this database for my other projects. the Tutorials google provides doesn't work for me. (the data is mostly Google Adwords data.)

Answer 1

因此，警告不是问题，这是已知问题，因为它无法在Windows上正常工作。
java.lang.NullPointerException是因为我调用的配置文件没有给定指标的数据行。由于没有行值，因此调用的返回值没有.getRows()方法。

您应该先检查该行的内容，

GaData results;
 if (null != results) {
     if(results.get("rows") != null){
          if (!results.getRows().isEmpty()){
               //do something with the rows exp.
               for (List<String> row : results.getRows()) {
                    for (int i=0; i<results.getColumnHeaders().size();i++) {
                        List<GaData.ColumnHeaders> headers = results.getColumnHeaders();
                        System.out.println( headers.get(i).getName()+": " + row.get(i));
                    }
                }
          }
     }
}

在该示例中，我还使用了ColumnHeaders，但也应首先检查。

检查我可以访问的每个帐户，每个webProperty和Profile也很容易，而不仅仅是检查每个帐户的第一个值。

另外， query explorer真的很有用。您应该使用它来检查可以使用的指标和尺寸。

这是我完整的 HelloAnalytics类，我只打印可能对控制台有用的所有内容，我还使用 getResults方法中的多个指标和Google AdWords的维度:

import com.google.api.client.auth.oauth2.Credential;
import com.google.api.client.extensions.java6.auth.oauth2.AuthorizationCodeInstalledApp;
import com.google.api.client.extensions.jetty.auth.oauth2.LocalServerReceiver;
import com.google.api.client.googleapis.auth.oauth2.GoogleAuthorizationCodeFlow;
import com.google.api.client.googleapis.auth.oauth2.GoogleClientSecrets;
import com.google.api.client.googleapis.javanet.GoogleNetHttpTransport;
import com.google.api.client.http.javanet.NetHttpTransport;
import com.google.api.client.json.JsonFactory;
import com.google.api.client.json.gson.GsonFactory;
import com.google.api.client.util.store.FileDataStoreFactory;
import com.google.api.services.analytics.Analytics;
import com.google.api.services.analytics.AnalyticsScopes;
import com.google.api.services.analytics.model.*;

import java.io.*;
import java.util.ArrayList;
import java.util.List;


/**
 * A simple example of how to access the Google Analytics API.
 */
public class HelloAnalytics {
    // Path to client_secrets.json file downloaded from the Developer's Console.
    // The path is relative to HelloAnalytics.java.
    private static final String CLIENT_SECRET_JSON_RESOURCE = "/client_secret.json";
    // The directory where the user's credentials will be stored.
    private static final File DATA_STORE_DIR = new File("out/DataStore/hello_analytics");
    private static final File OUTPUT_FILE = new File("out/DataStore/output.text");

    private static final String APPLICATION_NAME = "Online Marketing Buddy";
    private static final JsonFactory JSON_FACTORY = GsonFactory.getDefaultInstance();
    private static NetHttpTransport httpTransport;
    private static FileDataStoreFactory dataStoreFactory;

    public static void main(String[] args) {
        try {

            Analytics analytics = initializeAnalytics();
            getProfileIds(analytics);

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private static Analytics initializeAnalytics() throws Exception {

        httpTransport = GoogleNetHttpTransport.newTrustedTransport();
        dataStoreFactory = new FileDataStoreFactory(DATA_STORE_DIR);

        // Load client secrets.
        InputStream in =
                HelloAnalytics.class.getResourceAsStream(CLIENT_SECRET_JSON_RESOURCE);
        GoogleClientSecrets clientSecrets =
                GoogleClientSecrets.load(JSON_FACTORY, new InputStreamReader(in));

        // Set up authorization code flow for all auth scopes.
        GoogleAuthorizationCodeFlow flow = new GoogleAuthorizationCodeFlow
                .Builder(httpTransport, JSON_FACTORY, clientSecrets,AnalyticsScopes.all())
                .setDataStoreFactory(dataStoreFactory)
                .build();

        // Authorize.
        Credential credential = new AuthorizationCodeInstalledApp(flow, new LocalServerReceiver())
                .authorize("user");

        // Construct the Analytics service object.
        Analytics response = new Analytics
                .Builder(httpTransport, JSON_FACTORY, credential)
                .setApplicationName(APPLICATION_NAME).build();

        return response;
    }

    private static void getProfileIds(Analytics analytics) throws IOException {
        // Get the all view (profile) IDs for the authorized user.
        List<String> profileIds = new ArrayList<>();

        // Query for the list of all accounts associated with the service account.
        Accounts accounts = analytics.management().accounts().list().execute();

        if (accounts.getItems().isEmpty()) {
            System.err.println("No accounts found");
        } else {
            for (Account account : accounts.getItems()) {
                System.out.println("account: " + account.getName());
                String accountId = account.getId();

                // Query for the list of properties associated with the each account.
                Webproperties properties = analytics.management().webproperties()
                        .list(accountId).execute();

                if (properties.getItems().isEmpty()) {
                    System.err.println("No properties found for accountId: " + accountId);
                } else {
                    for (Webproperty webproperty : properties.getItems()) {
                        System.out.println("\nwebproperty: " + webproperty.getName());
                        String webpropertyId = webproperty.getId();

                        // Query for the list views (profiles) associated with the property.
                        Profiles profiles = analytics.management().profiles()
                                .list(accountId, webpropertyId).execute();

                        if (profiles.getItems().isEmpty()) {
                            System.err.println("No views (profiles) found for accoundId: " + accountId + "and webpropertyId: " + webpropertyId);
                        } else {
                            // Return the first (view) profile associated with the property.
                            for (Profile profile : profiles.getItems()) {
                                System.out.println("\nprofileId added for profile: " + profile.getName());
                                profileIds.add(profile.getId());
                                printResults(getResults(analytics,profile.getId()), profile.getId());
                            }
                        }
                        System.out.println("---------- ---------- end webproperty: " + webproperty.getName() + "---------- ----------");
                    }
                }
                System.out.println("---------- ---------- end account: " + account.getName() + "---------- ----------");
            }
        }
    }

    private static GaData getResults(Analytics analytics, String profileId) throws IOException {
        // Query the Core Reporting API for the number of sessions
        // in the past 30 days.
        GaData data = analytics.data().ga()
                .get("ga:" + profileId, "30daysAgo", "yesterday", "ga:adClicks, ga:adCost, ga:transactions, ga:transactionRevenue, ga:users, ga:sessions")
                .setDimensions("ga:adwordsCampaignID")
                .execute();
        return data;
    }

    private static void printResults(GaData results, String profile) {
        // Parse the response from the Core Reporting API for
        // the profile name and number of sessions.
        if (null != results) {
            System.out.println("View (Profile: " + profile + ") Name: "
                    + results.getProfileInfo().getProfileName() + "\n");
            if (results.get("rows") != null && results.get("columnHeaders") != null) {
                if (!results.getRows().isEmpty() && !results.getColumnHeaders().isEmpty()) {
                    for (List<String> row : results.getRows()) {
                        for (int i=0; i<results.getColumnHeaders().size();i++) {
                            List<GaData.ColumnHeaders> headers = results.getColumnHeaders();
                            System.out.println( headers.get(i).getName()+": " + row.get(i) + "\n");
                        }
                        System.out.println("---------- ---------- ----------\n");
                    }
                } else {
                    System.out.println("No rows or columHeaders empty\n");
                }
            } else {
                System.out.println("No rows or columHeaders\n");
            }
        }
    }
}