Data automation from google ads to google sheet

[Ramazan Aydemir]

Hi,

I'm reaching out to discuss an error i faced. When I was trying to call API query, i faced with the error 404. (The 404 error indicates that the URL being used is not recognized by the Google Ads API.) Can you help for this? 

function makeApiCall() {

var oauthService = getOAuthService();

if (oauthService.hasAccess()) {

var url = 'https://googleads.googleapis.com/v11/customers/{custemer_id}/googleAds:search';

var payload = JSON.stringify({

"query": "SELECT campaign.name, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.ctr, metrics.average_cpc FROM campaign"

});

var options = { ....

[GDZ]

"custemer_id" is misspelled?

[Ramazan Aydemir]

No, its correct

[Google Ads API Forum Advisor]

Hi,

Thank you for contacting the Google Ads API support team.

As per provided information, I understand that you are encountering 404 'Not found' error. I see that you are using the 'v11' of the Google Ads API which is already sunset. I would recommend migrating to the latest version v17, by following this guide upgrade to the latest version and try to execute the search query with v17 by passing the appropriate customer Id.

I hope this helps. Let us know how this goes on your end.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tJLXT:ref" (ADR-00241250)

Thanks,
 

Google Ads API Team

Register for the upcoming workshop: Performance Max and the Google Ads API!