tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

FPellissier1625558358 — Fri, 15 Nov 2024 23:58:44 GMT

Hello,

I download the last version of this component and follow all the instructions from the google help pages to create a service account ( link : https://developers.google.com/google-ads/api/docs/oauth/service-accounts# setting_up_service_account_access )

But I still cannot configure it correctly, I have the following error, that I use the json file or the p12 key to configure the component :

java.lang.IllegalArgumentException

at com.google.api.client.repackaged.com.google.common.base.Preconditions.checkArgument(Preconditions.java:111)

at com.google.api.client.util.Preconditions.checkArgument(Preconditions.java:37)

at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.<init>(GoogleCredential.java:323)

at com.google.api.client.googleapis.auth.oauth2.GoogleCredential$Builder.build(GoogleCredential.java:539)

at de.jlo.talendcomp.google.adwords.AdWordsReport.authorizeWithServiceAccount(AdWordsReport.java:166)

at de.jlo.talendcomp.google.adwords.AdWordsReport.initializeAdWordsSession(AdWordsReport.java:265)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.tGoogleAdWordsReport_1Process(FPE_GoogleAds.java:522)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.runJobInTOS(FPE_GoogleAds.java:1196)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.main(FPE_GoogleAds.java:996)

Exception in component tGoogleAdWordsReport_1 (FPE_GoogleAds)

java.lang.NullPointerException

at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:304)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.tGoogleAdWordsReport_1Process(FPE_GoogleAds.java:543)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.runJobInTOS(FPE_GoogleAds.java:1196)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.main(FPE_GoogleAds.java:996)

[FATAL]: haiku.fpe_googleads_0_1.FPE_GoogleAds - tGoogleAdWordsReport_1 null

java.lang.NullPointerException

at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:304)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.tGoogleAdWordsReport_1Process(FPE_GoogleAds.java:543)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.runJobInTOS(FPE_GoogleAds.java:1196)

at haiku.fpe_googleads_0_1.FPE_GoogleAds.main(FPE_GoogleAds.java:996)

Did someone knows that I can do to make it works ?

Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

gjeremy1617088143 — Wed, 07 Jul 2021 06:58:37 GMT

Hi, could you send a screen of the advanced settings of the component and a screen of your job ?

Send me Love and Kudos

Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

FPellissier1625558358 — Wed, 07 Jul 2021 08:53:37 GMT

Here are the two screens. The used schema is the 2 columns of the AWQL query

Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

gjeremy1617088143 — Wed, 07 Jul 2021 09:03:15 GMT

Hi, it's seems an argument is missing or wrong

Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

gjeremy1617088143 — Wed, 07 Jul 2021 09:07:12 GMT

hope the documentation could help you :

https://jan-lolling.de/talend/components/help/tGoogleAdWordsReport.pdf

one other thing i saw is in your query :

you don't have a space before FROM and between REPORT AND during so it can be the issue

topic Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ... in Talend Studio

tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...

Re: tGoogleAdWordsReport : IllegalArgumentException, NullPointerException, ...