Webhook Google Sheet Error 400

  • Resolved linhna

    (@linhna)


    1 year, 4 months ago

    After I upgraded to version 4.0.0 I got the following error:

    – Webhook:
    https://script.google.com/macros/s/xxxxxxxxxxxxxx/exec?gid=0
    – Error: “Webhook returned a error code.”

    Response Code: 400

    Response Message: "Bad Request"

    Response Body:
    "<!DOCTYPE html>\n<html lang=en>\n  <meta
    charset=utf-8>\n  <meta name=viewport content=\"initial-scale=1,
    minimum-scale=1, width=device-width\">\n  <title>Error 400 (Bad
    Request)!!1<\/title>\n  <style>\n
    *{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}\n
    <\/style>\n  <a href=\/\/www.google.com\/><span id=logo
    aria-label=Google><\/span><\/a>\n  <p><b>400.<\/b> <ins>That\u2019s an
    error.<\/ins>\n  <p>Your client has issued a malformed or illegal
    request.  <ins>That\u2019s all we know.<\/ins>\n"

    Before version 3.0.6 was working fine.
    Please show me how to fix it in version 4.0.0
    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mário Valney

    (@mariovalney)

    1 year, 4 months ago

    It was pretty hard to debug this. I’ve created a script for myself but it only first works in POSTMAN (not in cURL for example).

    To make work in cURL I had to set “CURLOPT_FOLLOWLOCATION” to true.

    You can use this snippet:

    add_action( 'http_api_curl', 'google_scripts_http_api_curl', 10, 3 );
    function google_scripts_http_api_curl( $handle, $parsed_args, $url ) {
        if ( strpos( $url, 'script.google.com/macros' ) ) {
            curl_setopt( $handle, CURLOPT_FOLLOWLOCATION, true );
        }
    }

    Just for curiosity: are you sure it was working before? I’ve tested with a early version and the error was there (we just didn’t show to user the 400 status).

    Thread Starter linhna

    (@linhna)

    1 year, 4 months ago

    First of all I thank you very much for you support.

    It worked with the code you provided.

    Here is a video where I will show you how it works well with the previous version: https://www.youtube.com/watch?v=Kc6W6LkFfcc

    Wishing many good things to come to you.

    • This reply was modified 1 year, 4 months ago by linhna.
    Plugin Author Mário Valney

    (@mariovalney)

    1 year, 4 months ago

    I loved the video! Thanks!

    But even the form was submitted doesn’t means the data was received and well processed.

    The 3.X version was not validating any return so it was not guaranteed.

    Said that, I’m happy everything is working now. I’ll think about to add a setting to this fix if any other user create a topic about webhooks redirecting.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Webhook Google Sheet Error 400’ is closed to new replies.