Hello,
We can't seem to get a script to run. We're returning the below error:
Exception: Call to GoogleAdsService.Search failed: Error in WHERE clause:
invalid value '.
at adsapp_compiled:18080:138 at adsapp_compiled:18091:9
at ra (adsapp_compiled:227:15) at Object.search (adsapp_compiled:235:20)
at dI.search (adsapp_compiled:18206:36) at NH.search
(adsapp_compiled:17783:19)
at OH.search (adsapp_compiled:17878:20) at VH.search
(adsapp_compiled:17970:19)
at ed (adsapp_compiled:1041:32) at ed.next (<anonymous>)
This error is returned when attempting to run the below (which has worked
well on multiple accounts already):
function main() {
var SPREAD = SpreadsheetApp.openByUrl("*Google Sheet URL*");
var SHEET = SPREAD.getSheetByName("*TabName*");
var dailyBudgetChanger = function(campaign, budget) {
var campaigns = AdsApp.campaigns().withCondition("Name = '" + campaign +
"'").get();
while (campaigns.hasNext()) {
var campaign = campaigns.next()
campaign.getBudget().setAmount(budget)
}
}
var lastRow = SHEET.getLastRow();
for (var i = 2; i <= lastRow; i++) {
var rowCampaign = SHEET.getRange(i, 1).getValue();
var rowBudget = SHEET.getRange(i, 2).getValue();
dailyBudgetChanger(rowCampaign, rowBudget);
}
}
Could anyone please assist?
Many thanks,
Jonny
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/33a16478-6e15-49be-b7df-ce97ddadd6f6n%40googlegroups.com.
