Anyone here who has had the same "Exceeds grid limits" error? This should
not happen as already mentioned in the previous message.
On Friday, November 11, 2016 at 3:40:06 PM UTC-5, Adwords Webmarketing
wrote:
>
> Hi Eric,
>
> Thanks for the reply. We are doing a batchUpdate request:
>
> BatchUpdateValuesRequest request = new BatchUpdateValuesRequest();
> request.setValueInputOption("RAW");
> request.setData(data);
>
> mSheetsService
> .spreadsheets()
> .values()
> .batchUpdate(currentReportSpreadsheet.getSpreadsheetId(),
> request)
> .execute();
>
> I don't see why our current method would not work as the "grid limits"
> that Google mentions in its error message vary depending of the number of
> objects in the request. Sometimes it is Max rows: 10000, others it is Max
> rows: 400.
>
> Also a few times before we managed to add tens of thousands of cells using
> a batch Update request using a similar procedure and we didn't have a
> problem but now we are getting this error.
>
> Thanks,
>
> Marc.
>
> On Wednesday, November 9, 2016 at 2:23:11 PM UTC-5, Eric Koleda wrote:
>>
>> Hi Marc,
>>
>> Exactly what type of request (operation) are you making? The error
>> indicates you are specifying a range that is larger that the sheet (grid)
>> currently is. If you use the AppendCellsRequest it should expand the size
>> of the sheet automatically as you append.
>>
>> - Eric
>>
>> On Sunday, November 6, 2016 at 3:33:20 PM UTC-5, Adwords Webmarketing
>> wrote:
>>>
>>> Hi Google Sheets API Support team,
>>>
>>> We are automating our Adwords reporting by using the Adwords API and the
>>> Google Sheets API to display the extracted data.
>>>
>>> We are running into an error message when making a BatchUpdate to a
>>> dynamically created spreadsheet.
>>>
>>> The error message we are getting is:
>>>
>>> com.google.api.client.googleapis.json.GoogleJsonResponseException: 400
>>> Bad Request
>>> {
>>> "code" : 400,
>>> "errors" : [ {
>>> "domain" : "global",
>>> "message" : "Invalid data[0]: Range (Sheet1!10001:20000) exceeds
>>> grid limits. Max rows: 10000, max columns: 26",
>>> "reason" : "badRequest"
>>> } ],
>>> "message" : "Invalid data[0]: Range (Sheet1!10001:20000) exceeds grid
>>> limits. Max rows: 10000, max columns: 26",
>>> "status" : "INVALID_ARGUMENT"
>>> }
>>>
>>> What we are doing is populating the spreadsheet in 10,000 rows of data
>>> each time. The first report data block goes well (Range: Sheet1!1:10000)
>>> however, when we get to the 2nd data block, this error is displayed.
>>>
>>> If we try to update the data in other quantities (for example 2000 or
>>> 5000 rows per insertion), we get the same error message, however it says
>>> "Max rows: 2000, max columns: 26" and "Max rows: 5000, max columns: 26"
>>> respectively. If we try to update 20000 rows at once, another error message
>>> says that we are trying to update row 10001 when the limit is 10000
>>> (obiously because the Value Range data now contains more rows than the
>>> predefined range).
>>>
>>> There is no documentation anywhere regarding this error message and it
>>> is not really clear what it means. The range Sheet1!10001:20000 contains
>>> clearly less than 10000 rows (20000-10001 = 9999 rows) so there is not a
>>> clear reason as to why this message is displaying. If the problem is with
>>> the number of columns, then we'd like to know what exactly the problem
>>> would be as we have also tried to reduce the number of columns targeted (in
>>> A1 notation) and we still get the same error message.
>>>
>>> Thanks,
>>>
>>> Marc.
>>>
>>>
>>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
