Post to Google Sheets API got "The requested URL ... was not found on this server."

1,626 views

Skip to first unread message

mikuari...@gmail.com

unread,

Jul 12, 2016, 1:34:46 PM7/12/16

to REST assured

I'm trying to post some data to my Google Sheets through the Google Sheets API as below:

given()
        .log().all()
        .auth().oauth2(this.token)
        .pathParam("spreadsheetId", "1bJsN2ji2kZKmOMVqn4eaoxve-qqJVP65nQqX6GIg2i4")
        .body(body)
.when()
        .post("https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate")
.then()
        .log().all()
        .assertThat()
        .statusCode(200);

but it always failed with below info returned:

<html lang="en">
  <head>
    <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}* &gt; 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>
  </head>
  <body>
    <a shape="rect" href="//www.google.com/">
      <span id="logo" aria-label="Google"/>
    </a>
    <p>
      <b>404.</b>
      <ins>That’s an error.</ins>
    </p>
    <p>
The requested URL       <code>/v4/spreadsheets/1bJsN2ji2kZKmOMVqn4eaoxve-qqJVP65nQqX6GIg2i4%3AbatchUpdate</code>
 was not found on this server.        <ins>That’s all we know.</ins>
    </p>
  </body>
</html>

The same request sending with Postman and Google APIs Explorer works fine, only when doing with Rest Assured, I got failure.

This is very strange to me, I'm not sure whether I should question this with Rest Assured or Google, hope I can got some help from someone here.

BR.

Miku

Johan Haleby

unread,

Jul 12, 2016, 1:36:26 PM7/12/16

to rest-a...@googlegroups.com

Don't know but perhaps you don't want to url-encode ":"? Try disabling url encoding: given().urlEncoding(false)...

--
You received this message because you are subscribed to the Google Groups "REST assured" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rest-assured...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all

Reply to author

Forward

0 new messages