tGoogleSheetOutput exceeds grid limits

bglaplante — Sat, 16 Nov 2024 05:30:58 GMT

I'm trying to add rows to an existing Google Sheet (by specifying start writing at row 4900).

The component errors with the following. Am I really stuck at a max of 1000 rows in my Google sheet with this component?

WARN: Got error:400 Bad Request
{
  "code" : 400,
  "errors" : [ {
    "domain" : "global",
    "message" : "Range (Sheet1!A4919) exceeds grid limits. Max rows: 1000, max columns: 26",
    "reason" : "badRequest"
  } ],
  "message" : "Range (Sheet1!A4919) exceeds grid limits. Max rows: 1000, max columns: 26",
  "status" : "INVALID_ARGUMENT"
}
ERROR: Stop processing because of the error does not allow a retry.
Exception in component tGoogleSheetOutput_2 (CBC_ACH_Rejects_2_GSheet)
com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
{
  "code" : 400,
  "errors" : [ {
    "domain" : "global",
    "message" : "Range (Sheet1!A4919) exceeds grid limits. Max rows: 1000, max columns: 26",
    "reason" : "badRequest"
  } ],
  "message" : "Range (Sheet1!A4919) exceeds grid limits. Max rows: 1000, max columns: 26",
  "status" : "INVALID_ARGUMENT"
}
	at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146)

Re: tGoogleSheetOutput exceeds grid limits

Anonymous — Tue, 25 Jun 2019 10:20:42 GMT

Hello,

tGoogleSheetOutput is a custom component written by talend community user and shared on talend exchange portal. We don't have the source code of these components. It is the ownership of the person who built it.

Feel free to contact the author directly.

Best regards

Sabrina

topic tGoogleSheetOutput exceeds grid limits in Talend Studio

tGoogleSheetOutput exceeds grid limits

Re: tGoogleSheetOutput exceeds grid limits