DFA报告:无法使用服务帐户获取配置文件

Question

我正在开发一段代码，可以使用谷歌DFA报告API创建和下载报告。

我可以使用客户端Id和客户端秘密做同样的事情，这是使用Install-App(本机应用程序)帐户生成的，但是使用这种类型的帐户，它总是第一次打开浏览器，然后只有它验证未来的请求。

进一步阅读，我发现了服务帐户。然后我创建了一个新的服务帐户并下载了p12密钥。我现在能够在p12和电子邮件帐户(*******[e-mail])的帮助下构建凭据对象。我可以确认这一点，因为在调用凭据. refreshtoken()之后，我在凭据对象中看到了访问令牌。

然后使用上述凭据创建DFA Reporting对象并尝试获取配置文件列表，但我得到以下错误:

java.lang.IllegalArgumentException: No profiles found
    at com.google.api.client.repackaged.com.google.common.base.Preconditions.checkArgument(Preconditions.java:92)
    at com.google.api.client.util.Preconditions.checkArgument(Preconditions.java:49)
    at com.google.api.services.samples.dfareporting.cmdline.GetAllUserProfiles.list(GetAllUserProfiles.java:52)
    at com.google.api.services.samples.dfareporting.cmdline.DfaReportingSample.main(DfaReportingSample.java:171)

请查看下面我的代码，让我知道我错在哪里:

private static Credential authorize() throws Exception {
    // load client secrets
    List<String> SCOPES = ImmutableList
            .of("https://www.googleapis.com/auth/dfareporting");
    String SERVICE_ACCOUNT_EMAIL = "*************************@developer.gserviceaccount.com";
    String Path = DfaReportingSample.class.getResource(
            "/TestDFA-5d985ff38b34.p12").getPath();
    java.io.File file = new java.io.File(Path);
    HttpTransport httpTransport = new NetHttpTransport();
    JacksonFactory jsonFactory = new JacksonFactory();
    Credential credentials =  new GoogleCredential.Builder()
            .setTransport(httpTransport)
            .setJsonFactory(jsonFactory)
            .setServiceAccountId(SERVICE_ACCOUNT_EMAIL)
            .setServiceAccountScopes(SCOPES)
            .setServiceAccountPrivateKeyFromP12File(file).build();
    credentials.refreshToken();
    return credentials;
}
private static Dfareporting initializeDfareporting() throws Exception {
    Credential credential = authorize();
    // Create DFA Reporting client.
    return new Dfareporting(httpTransport, JSON_FACTORY, credential);
}

public static void main(String[] args) {
    try {
        httpTransport = GoogleNetHttpTransport.newTrustedTransport();
        Dfareporting reporting = initializeDfareporting();
        UserProfiles up = reporting.userProfiles();
        List l = up.list();
        UserProfileList profiles = l.execute();
        // {"etag":""bM2H6qONz9kIDiByk_eTdC6Ehcc/vyGp6PvFo4RvsFtPoIWeCReyIC8"","items":[],"kind":"dfareporting#userProfileList"}
        Preconditions.checkArgument(
            profiles.getItems() != null && !profiles.getItems().isEmpty(), "No profiles found");
        for (UserProfile userProfile : profiles.getItems()) {
          System.out.printf("User profile with ID "%s" and name "%s" was found.%n",
              userProfile.getProfileId(), userProfile.getUserName());
        }
....................................

PS:我能够获取所有的配置文件，如果我使用访问令牌，这是使用本地应用程序(安装的应用程序)帐户提供的客户端id和客户端秘密生成的。

谢谢,侯赛因Bohra

Answer 1

在尝试了很多服务帐户(&p12密钥)，我们无法使它与谷歌DFA报告一起工作。因此，我们现在使用以下类进行身份验证:

com.google.api.ads.common.lib.auth.OfflineCredentials
input = new FileInputStream(Utils.getProperty(Constants.HOME_PATH)
        + Utils.getProperty(Constants.CLIENT_SECRETS_DIRECTORY)
        + Constants.PATH_SEPARATOR + userPropertyFile);
userProperty.load(input);
credential = new OfflineCredentials.Builder()
        .forApi(OfflineCredentials.Api.DFA)
        .withHttpTransport(
                GoogleNetHttpTransport.newTrustedTransport())
        .withClientSecrets(userProperty.getProperty("client_id"),
                userProperty.getProperty("client_secret"))
        .withRefreshToken(userProperty.getProperty("refresh_token"))
        .build().generateCredential();

上面代码中使用的刷新令牌是为每个帐户手动生成的(一次性过程)。使用这个凭证对象，我们现在能够在DFA报告中执行以下所有活动:-列表配置文件—验证和创建报表-下载报表数据

获取刷新令牌的代码(涉及在浏览器中单击Accept的手动步骤)

java.io.File DATA_STORE_DIR = new java.io.File(
        "d:/dfa-reporting/.store/dfareporting_sample");
FileDataStoreFactory dataStoreFactory;
dataStoreFactory = new FileDataStoreFactory(DATA_STORE_DIR);
GoogleClientSecrets clientSecrets = GoogleClientSecrets.load(
        JSON_FACTORY,
        new InputStreamReader(DfaReportingSample.class
                .getResourceAsStream("/client_secret_galtieri.json")));
// set up authorization code flow
GoogleAuthorizationCodeFlow flow = new GoogleAuthorizationCodeFlow.Builder(
        httpTransport, JSON_FACTORY, clientSecrets, SCOPES)
        .setDataStoreFactory(dataStoreFactory).build();
// authorize
String refreshToken = new AuthorizationCodeInstalledApp(flow,
        new PromptReceiver()).authorize("hbohra").getRefreshToken();

谢谢,侯赛因Bohra