Contrib.social

Invalid requests[0].appendCells: Attempting to write column: 27, beyond the last requested column of: 26

Open on Drupal.org →
Created on 28 November 2024, 4 months ago

Problem/Motivation

The following error is logged after creating a new submission on a Webform configured to append to a new, empty Google Sheet:

{ "error": { "code": 400, "message": "Invalid requests[0].appendCells: Attempting to write column: 27, beyond the last requested column of: 26", "errors": [ { "message": "Invalid requests[0].appendCells: Attempting to write column: 27, beyond the last requested column of: 26", "domain": "global", "reason": "badRequest" } ], "status": "INVALID_ARGUMENT" } } error occurred while appending submission to Google Sheets.

Proposed resolution

This error message means that there aren't enough columns in the sheet. Before trying to append the row, let's check the amount of columns and add more if necessary.

🐛 Bug report
Status

Active

Version

2.0

Component

Code

Created by

🇧🇪Belgium dieterholvoet Brussels

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024