Adwords API throwing DetailedReportDownloadResponseException with 400 Response code.

[ni...@zapr.in]

I am trying to run awql query using adwords api. 

Query:- SELECT CampaignId, Date, Clicks, Impressions, VideoQuartile25Rate, VideoQuartile50Rate, VideoQuartile75Rate, VideoQuartile100Rate, VideoViews FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignId = <campaign_id> DURING 20171107, 20171109

When I am running this query api is, sometimes responding with 400 response and sometimes running normally. I am not able to debug this weird behaviour. I have basic access token which allows for 10000 api calls and 1000 report downloads.

This is the stack trace:

com.google.api.ads.adwords.lib.utils.v201710.DetailedReportDownloadResponseException: 400

at com.google.api.ads.adwords.lib.utils.v201710.DetailedReportDownloadResponseException$Builder.build(DetailedReportDownloadResponseException.java:35)

at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.handleResponse(AdHocReportDownloadHelperImpl.java:117)

at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.downloadReport(AdHocReportDownloadHelperImpl.java:60)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.google.api.ads.common.lib.utils.AdsUtilityInvocationHandler.handleInvocation(AdsUtilityInvocationHandler.java:46)

at com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:84)

at com.sun.proxy.$Proxy38.downloadReport(Unknown Source)

at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelper.downloadReport(AdHocReportDownloadHelper.java:46)

at com.google.api.ads.adwords.lib.utils.v201710.ReportDownloader.downloadReport(ReportDownloader.java:73)

[Vincent Racaza (AdWords API Team)]

Hi,

Based on your query alone, I could not see anything wrong. With this, could you please enable logging and provide your clientCustomerId, report definition and any logs generated on your end so I can further check? Please use the Reply privately to author option when replying.

Thanks,

Vincent

AdWords API Team

[Vincent Racaza (AdWords API Team)]

Hi,

A gentle follow up on this. If you are still encountering this issue, then kindly provide the information that I asked on my previous reply via Reply privately to author option.