Re: CustomerSyncService Bug? CustomerSyncService not returning changed criteria when AdGroupCriteron are added to two or more adgroups in one operation
Hi,
This forum supports the AdWords API. You appear to have a App Script
that works with spreadsheets. Google Apps Scripts list their support
options here https://developers.google.com/apps-script/support. If you
are using AdWords Scripts, you can post questions related to that product
herehttps://groups.google.com/forum/?fromgroups=#!categories/adwords-scripts
.
That said, this error usually means that the range is invalid. You might
want to try sheet.getDataRange which returns a range encompassing all the
data on the sheet. You might also want to double-check the column/rows and
counts to make sure they match the data in the sheet - remember, the
column/rows are 1-indexed.
- Kevin Winter
AdWords API Team
On Thursday, August 9, 2012 7:21:01 AM UTC-4, dnrg26 wrote:
hi
will you please advise me where i got the mistake
my problem is //Error : The coordinates or dimensions of the range are
invalid. (line 6)Dismiss//
function Archivetimesheet(){
var
ss=SpreadsheetApp.openById(0AhioeCK_-aU4dGVWSDVlNXRxdzNseGJRNW);
//From Current Workbook
var sheet = ss.getSheetByName(Invoice);//From Current Sheet
var data = sheet.getRange(5,1,sheet.getLastRow()-5,74).getValues();
var archive=
SpreadsheetApp.openById(0AhioeCK_-aU4dENCVjViWVhhdkZrd.).getSheetByName(Sales);//To
Remote Workbook//
var searchOne =
archive.getRange(5,1,archive.getLastRow()-5,74).getValues();//To Remote
Sheet Line 6
var dest = [];
var filter =
SpreadsheetApp.openById(0AhioeCK_-aU4dENCVjViWVhhdkZrd...).getSheetByName(Sales).getRange(D2).getValue();
//Only Filter that row which is matching wiht D2
Logger.log(getDataRange().getValues() data is + data);
for (var i = 1; i data.length; i++ )
{
if (filter.test(data[i][3]) == filter )
dest.push([data[i][0],data[i][1],data[i][2],data[i][3],data[i][4],data[i][5],data[i][6],data[i][7],data[i][74]]);
}
//Logger.log(dest);
if( dest.length 0 ) {
archive.insertRowsBefore(5,dest.length);
archive.getRange(5,1,dest.length,dest[0].length).setValues(dest);
}
}
//Error : The coordinates or dimensions of the range are invalid. (line
6)Dismiss//
On Wednesday, August 8, 2012 7:46:51 PM UTC+3, David Torres wrote:
Hi Akil,
How far apart are your calls to mutate and then get the changes? Might
best guess is that sandbox (given it a has a limited set of resources
compared to production) is not updating the changes feed fast enough.
Best,
-David
On Wednesday, August 8, 2012 12:29:49 PM UTC-4, Akil Burgess wrote:
Hi David,
I just tried this in production and I was not able to reproduce the
issue.
Thanks,
Akil
On Tuesday, August 7, 2012 6:12:06 PM UTC+1, David Torres wrote:
Hi Akil,
Is this also reproduceable in production?
Best,
-David Torres - AdWords API Team
On Friday, August 3, 2012 6:25:23 AM UTC-4, Akil Burgess wrote:
Hi All,
I am seeing an issue where the CustomerSyncService is not showing the
correct change data when I follow these steps:
1. I perform an AdGroupCriterionService.mutate operation that adds
a keyword to two different adgroups (*
requestId 0004c65980b97b580aeddd445bee*)
2. Perform CustomerSyncService.get using a timerange that contains
that mutate operation (*requestId 0004c659815517480a96292176e2*
)
Expected: The CustomerChangeData should contain AdGroupChangeData with
changedCriteria
Actual: The CustomerChangeData contains no changes.
I've only tested for this bug in the API sandbox but this issue occurs
whether I submit the operations via the AdGroupCriterionService or the
MutateJobService.
For now I can work around the issue by only submitting operations on a
per adgroup basis but this definitely seems like a bug. Has anyone else
come across this issue? *API Team -* Can you please investigate this
issue?
Thanks in advance!
Akil
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
Re: CustomerSyncService Bug? CustomerSyncService not returning changed criteria when AdGroupCriteron are added to two or more adgroups in one operation
hi
will you please advise me where i got the mistake
my problem is //Error : The coordinates or dimensions of the range are
invalid. (line 6)Dismiss//
function Archivetimesheet(){
var
ss=SpreadsheetApp.openById(0AhioeCK_-aU4dGVWSDVlNXRxdzNseGJRNW);
//From Current Workbook
var sheet = ss.getSheetByName(Invoice);//From Current Sheet
var data = sheet.getRange(5,1,sheet.getLastRow()-5,74).getValues();
var archive=
SpreadsheetApp.openById(0AhioeCK_-aU4dENCVjViWVhhdkZrd.).getSheetByName(Sales);//To
Remote Workbook//
var searchOne =
archive.getRange(5,1,archive.getLastRow()-5,74).getValues();//To Remote
Sheet Line 6
var dest = [];
var filter =
SpreadsheetApp.openById(0AhioeCK_-aU4dENCVjViWVhhdkZrd...).getSheetByName(Sales).getRange(D2).getValue();
//Only Filter that row which is matching wiht D2
Logger.log(getDataRange().getValues() data is + data);
for (var i = 1; i data.length; i++ )
{
if (filter.test(data[i][3]) == filter )
dest.push([data[i][0],data[i][1],data[i][2],data[i][3],data[i][4],data[i][5],data[i][6],data[i][7],data[i][74]]);
}
//Logger.log(dest);
if( dest.length 0 ) {
archive.insertRowsBefore(5,dest.length);
archive.getRange(5,1,dest.length,dest[0].length).setValues(dest);
}
}
//Error : The coordinates or dimensions of the range are invalid. (line
6)Dismiss//
On Wednesday, August 8, 2012 7:46:51 PM UTC+3, David Torres wrote:
Hi Akil,
How far apart are your calls to mutate and then get the changes? Might
best guess is that sandbox (given it a has a limited set of resources
compared to production) is not updating the changes feed fast enough.
Best,
-David
On Wednesday, August 8, 2012 12:29:49 PM UTC-4, Akil Burgess wrote:
Hi David,
I just tried this in production and I was not able to reproduce the issue.
Thanks,
Akil
On Tuesday, August 7, 2012 6:12:06 PM UTC+1, David Torres wrote:
Hi Akil,
Is this also reproduceable in production?
Best,
-David Torres - AdWords API Team
On Friday, August 3, 2012 6:25:23 AM UTC-4, Akil Burgess wrote:
Hi All,
I am seeing an issue where the CustomerSyncService is not showing the
correct change data when I follow these steps:
1. I perform an AdGroupCriterionService.mutate operation that adds
a keyword to two different adgroups (*
requestId 0004c65980b97b580aeddd445bee*)
2. Perform CustomerSyncService.get using a timerange that contains
that mutate operation (*requestId 0004c659815517480a96292176e2*)
Expected: The CustomerChangeData should contain AdGroupChangeData with
changedCriteria
Actual: The CustomerChangeData contains no changes.
I've only tested for this bug in the API sandbox but this issue occurs
whether I submit the operations via the AdGroupCriterionService or the
MutateJobService.
For now I can work around the issue by only submitting operations on a
per adgroup basis but this definitely seems like a bug. Has anyone else
come across this issue? *API Team -* Can you please investigate this
issue?
Thanks in advance!
Akil
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
Re: CustomerSyncService Bug? CustomerSyncService not returning changed criteria when AdGroupCriteron are added to two or more adgroups in one operation
Hi David, I just tried this in production and I was not able to reproduce the issue. Thanks, Akil On Tuesday, August 7, 2012 6:12:06 PM UTC+1, David Torres wrote: Hi Akil, Is this also reproduceable in production? Best, -David Torres - AdWords API Team On Friday, August 3, 2012 6:25:23 AM UTC-4, Akil Burgess wrote: Hi All, I am seeing an issue where the CustomerSyncService is not showing the correct change data when I follow these steps: 1. I perform an AdGroupCriterionService.mutate operation that adds a keyword to two different adgroups (* requestId 0004c65980b97b580aeddd445bee*) 2. Perform CustomerSyncService.get using a timerange that contains that mutate operation (*requestId 0004c659815517480a96292176e2*) Expected: The CustomerChangeData should contain AdGroupChangeData with changedCriteria Actual: The CustomerChangeData contains no changes. I've only tested for this bug in the API sandbox but this issue occurs whether I submit the operations via the AdGroupCriterionService or the MutateJobService. For now I can work around the issue by only submitting operations on a per adgroup basis but this definitely seems like a bug. Has anyone else come across this issue? *API Team -* Can you please investigate this issue? Thanks in advance! Akil -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: CustomerSyncService Bug? CustomerSyncService not returning changed criteria when AdGroupCriteron are added to two or more adgroups in one operation
Hi Akil, How far apart are your calls to mutate and then get the changes? Might best guess is that sandbox (given it a has a limited set of resources compared to production) is not updating the changes feed fast enough. Best, -David On Wednesday, August 8, 2012 12:29:49 PM UTC-4, Akil Burgess wrote: Hi David, I just tried this in production and I was not able to reproduce the issue. Thanks, Akil On Tuesday, August 7, 2012 6:12:06 PM UTC+1, David Torres wrote: Hi Akil, Is this also reproduceable in production? Best, -David Torres - AdWords API Team On Friday, August 3, 2012 6:25:23 AM UTC-4, Akil Burgess wrote: Hi All, I am seeing an issue where the CustomerSyncService is not showing the correct change data when I follow these steps: 1. I perform an AdGroupCriterionService.mutate operation that adds a keyword to two different adgroups (* requestId 0004c65980b97b580aeddd445bee*) 2. Perform CustomerSyncService.get using a timerange that contains that mutate operation (*requestId 0004c659815517480a96292176e2*) Expected: The CustomerChangeData should contain AdGroupChangeData with changedCriteria Actual: The CustomerChangeData contains no changes. I've only tested for this bug in the API sandbox but this issue occurs whether I submit the operations via the AdGroupCriterionService or the MutateJobService. For now I can work around the issue by only submitting operations on a per adgroup basis but this definitely seems like a bug. Has anyone else come across this issue? *API Team -* Can you please investigate this issue? Thanks in advance! Akil -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: CustomerSyncService Bug? CustomerSyncService not returning changed criteria when AdGroupCriteron are added to two or more adgroups in one operation
Hi Akil, Is this also reproduceable in production? Best, -David Torres - AdWords API Team On Friday, August 3, 2012 6:25:23 AM UTC-4, Akil Burgess wrote: Hi All, I am seeing an issue where the CustomerSyncService is not showing the correct change data when I follow these steps: 1. I perform an AdGroupCriterionService.mutate operation that adds a keyword to two different adgroups (* requestId 0004c65980b97b580aeddd445bee*) 2. Perform CustomerSyncService.get using a timerange that contains that mutate operation (*requestId 0004c659815517480a96292176e2*) Expected: The CustomerChangeData should contain AdGroupChangeData with changedCriteria Actual: The CustomerChangeData contains no changes. I've only tested for this bug in the API sandbox but this issue occurs whether I submit the operations via the AdGroupCriterionService or the MutateJobService. For now I can work around the issue by only submitting operations on a per adgroup basis but this definitely seems like a bug. Has anyone else come across this issue? *API Team -* Can you please investigate this issue? Thanks in advance! Akil -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
CustomerSyncService Bug? CustomerSyncService not returning changed criteria when AdGroupCriteron are added to two or more adgroups in one operation
Hi All, I am seeing an issue where the CustomerSyncService is not showing the correct change data when I follow these steps: 1. I perform an AdGroupCriterionService.mutate operation that adds a keyword to two different adgroups (* requestId 0004c65980b97b580aeddd445bee*) 2. Perform CustomerSyncService.get using a timerange that contains that mutate operation (*requestId 0004c659815517480a96292176e2*) Expected: The CustomerChangeData should contain AdGroupChangeData with changedCriteria Actual: The CustomerChangeData contains no changes. I've only tested for this bug in the API sandbox but this issue occurs whether I submit the operations via the AdGroupCriterionService or the MutateJobService. For now I can work around the issue by only submitting operations on a per adgroup basis but this definitely seems like a bug. Has anyone else come across this issue? *API Team -* Can you please investigate this issue? Thanks in advance! Akil -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups AdWords API Forum group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
