Contrib.social

The requested URL /v4/spreadsheets/:batchUpdate was not found on this server.

Open on Drupal.org →
Created on 4 July 2023, over 1 year ago
Updated 5 July 2023, over 1 year ago

Problem/Motivation

When a submission is done, the Google sheets not get filled. At the log's we see the following error.

<!DOCTYPE html> <html lang=en> <meta charset=utf-8> <meta name=viewport content="initial-scale=1, minimum-scale=1, width=device-width"> <title>Error 404 (Not Found)!!1</title> <style> *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px} </style> <a href=//www.google.com/><span id=logo aria-label=Google></span></a> <p><b>404.</b> <ins>That’s an error.</ins> <p>The requested URL <code>/v4/spreadsheets/:batchUpdate was not found on this server. That’s all we know. error occurred while appending submission to Google Sheets.

Steps to reproduce

  1. At the first step we created a project and enabled apis and services for of Google Sheets API.
  2. From the dashboard we've clicked on OAuth consent screen, the publishing status is setup Testing, the User type with the setting External is on Make internal
  3. We've added multiple test users
  4. In the tab of Credentials, we clicked on Create credentials. We used OAuth 2.0 Client, with setting of Web application and authorized the following url: https://xx.xx.xx/google_api_client/callback
  5. We'va checked the Status report screen and we have Google Api PHP Client Installed 2.12.6
  6. Then we visited the settings of Google API Client and we clicked Scan library
  7. At the Google API Client page we added an account, see screenshot.
  8. After this we clicked on Authenticate, Is authenticated has the value of Yes
  1. At the webform we've added a Google sheet handler with the following settings, see screenshot. We're using the same structure of url as described: https://docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx...
  2. We notice that at the overview we don't see any values. See screenshot.
🐛 Bug report
Status

Closed: works as designed

Version

2.0

Component

Code

Created by

🇧🇪Belgium SteveG.

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

Comments & Activities

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024