Getting "Missing report definition" while i'm calling Google AdWords API

[Ting Lan]

Hi there, 

I got the error in the oauth playground while i'm trying to pull report from Google Ads , see the details below, anyone could help?

POST /api/adwords/reportdownload/v201809 HTTP/1.1
Host: adwords.google.com
Clientcustomerid: xxxxxxxx
Developertoken: xxxxxxxxxxx
Content-type: application/json
Content-length: 157
Authorization: Bearer xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
  "query" : "SELECT campaign.name, campaign.status 
                    
            FROM campaign
            WHERE segments.date DURING LAST_30_DAYS"
}
HTTP/1.1 400 Bad Request
Content-length: 236
X-xss-protection: 1; mode=block
X-content-type-options: nosniff
Transfer-encoding: chunked
Expires: Fri, 13 Sep 2019 18:29:20 GMT
Server: GSE
-content-encoding: gzip
Cache-control: private, max-age=0
Date: Fri, 13 Sep 2019 18:29:20 GMT
X-frame-options: SAMEORIGIN
Alt-svc: quic=":443"; ma=2592000; v="46,43,39"
Content-type: text/xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><reportDownloadError><ApiError><type>ReportDownloadError.MISSING_PARAMETER</type><trigger>Missing report definition</trigger><fieldPath></fieldPath></ApiError></reportDownloadError>

[Google Ads API Forum Advisor Prod]

Hi Tang,

Apologies for the delay. Our team is looking into the issue and will get back to you as soon as we have an update on this. Let us know if you have any other concerns related to Adwords API/Google Ads API.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UHGlGZ:ref

[Google Ads API Forum Advisor Prod]

Hi Ting,

To make AdWords API requests against both test accounts and production accounts, you need to apply for basic access using this form. This allows the developers to execute up to 10,000 operations and download up to 1,000 reports per day. There are no charges for compliant API usage under either basic or standard access. Please refer to this guide for more information on the terms and conditions while signing up for Adwords API. Once you have submitted the application for basic access, the API Compliance Team will contact you within two business days of the date you submitted your application, at the email address you provided in API Center. This email should be monitored regularly. Let us know if you have any additional concerns.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UHGlGZ:ref

[Ting Lan]

Hi there,

 

Thank you for the information, I am using this via DOMO( a visualization tool) which would call Google Adwords API to download the report. By using the API reference online, I changed my code to query the data but however, I got a new error which seems like an access problem, since the account we are querying is using a Test account for its developer token. In this case, shall we apply for a basic account access for that to get the access? Does it charge us anything for getting this basic account ? FYI, I have applied for a basic account for my developer token on the behalf of my company, MediaNet. I submitted the application form yesterday so I hope that I could get that approved soon.

 

 

 

 

FYI, I put more details of the log below about the error. As you can see, I wrote some codes to call the API and queried the data. However, the error at the right bottom shows me that I have an invalid token , for your convenience, I print all the logs out too.

 

 

 

 

 

 

 

 

 

 

 

 

metadata.account.code: 4/rAFVAJjhxKZ3McV_dGWIJ-NbyI4yWDnxsd4QGdv4mh3mXVTOvOiJ6udZ1b_rFKmmKT4GrKOSqA12Px7p05J06IA

metadata.account.accesstoken: ya29.GlyGByyfxmX5aTlRlAbSHIevNmfokxQEedZrwVYQvHwnfCiaGbxdFuPVxHv9tqoX760U0Jr_eetNKm19AaddrwMaM9tdtSgegxLs6JqudwpADt2diUQh4U8EECMzug

res:ERROR: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><reportDownloadError><ApiError><type>QuotaCheckError.DEVELOPER_TOKEN_NOT_APPROVED</type><trigger>&lt;null&gt;</trigger><fieldPath></fieldPath></ApiError></reportDownloadError>

{"authtype":"basicauth","authSuccess":false,"errorMessage":null}

 

 

 

 

TING LAN
TRADING ANALYST

416 538 9300
BETTER DIGITAL RESULTS™

 

The information contained in this email together with any attachment(s) is private and the confidential property of MediaNet. If you are not the intended recipient(s) or have otherwise received this email unlawfully or in error, please delete it and inform the sender as soon as possible. This email may not be disclosed, stored, used, published or copied by anyone other than the intended recipient(s).