使用javascript将数据插入Google表格API [英] Inserting Data's Into Google Sheets API Using javascript

问题描述

我试图将我的数据插入google Sheet API。所以我按照链接

Am trying to Insert My data's Into google Sheet API . So i followed this Link

在我的控制台中尝试获取 PUT 400（）后，我的网络标题

After trying that am Getting no Error as PUT 400() in my console, in my Network Header

    Request URL:https://sheets.googleapis.com/v4/spreadsheets/1sd4HEFMsK3WJyHgcs1crX-30LqkBum30kxdH0qCwL5Y/values/Sheet1!A1:B1?valueInputOption==USER_ENTERED
Request Method:PUT
Status Code:400 
Remote Address:74.125.68.95:443

我的网络响应是

   {
  "error": {
    "code": 400,
    "message": "Invalid value at 'value_input_option' (TYPE_ENUM), \"=USER_ENTERED\"",
    "status": "INVALID_ARGUMENT",
    "details": [
      {
        "@type": "type.googleapis.com/google.rpc.BadRequest",
        "fieldViolations": [
          {
            "field": "value_input_option",
            "description": "Invalid value at 'value_input_option' (TYPE_ENUM), \"=USER_ENTERED\""
          }
        ]
      }
    ]
  }
}

。我在这里做错了，还是我必须在我的代码中添加东西？ 。有人可以帮助/澄清我。这是我的HTML，

. What i did wrong here , Or still i have to add stuffs into my code ? . Can someone Help/Clarify me . Here is my HTML ,

<div ng-controller="BasicExampleCtrl">

<header data-ng-include="'app/views/header.html'"></header>
<div class="header" data-ng-include="'app/views/menu.html'"></div>
<h2>Welcome Google SpreadSheet Page</h2>

   <button class="btn btn-primary"
   data-ng-click="read()" style="position: absolute;width: 199px;height: 35px;left: 0px;top: 190px;">View In GoogleSheets</button>
</div>

<iframe id='ifr' src='https://docs.google.com/spreadsheets/d/1sd4HEFMsK3WJyHgcs1crX-30LqkBum30kxdH0qCwL5Y/edit#gid=0'
style="position: absolute;width: 100%;height: 100%;left: 0px;top: 250px;" >
 </iframe>

 <iframe id='ifr' src='https://docs.google.com/spreadsheets/d/1sd4HEFMsK3WJyHgcs1crX-30LqkBum30kxdH0qCwL5Y/edit#gid=0'style="position: absolute;width: 100%;height: 100%;left: 0px;top: 250px;" >
 </iframe>

这是我的Js代码，

$scope.read = function () {

    var params = {
               "range":"Sheet1!A1:B1",
               "majorDimension": "ROWS",
               "values": [
               ["Hello","World"]
              ],
         }  

     var xhr = new XMLHttpRequest();
     xhr.open('PUT', 'https://sheets.googleapis.com/v4/spreadsheets/1sd4HEFMsK3WJyHgcs1crX-30LqkBum30kxdH0qCwL5Y/values/Sheet1!A1:B1?valueInputOption==USER_ENTERED;headers=false');

     xhr.setRequestHeader('Authorization', 'Bearer ' + access_token);
      xhr.send(JSON.stringify(params));


            };

    }]);

推荐答案

您有 valueInputOption == USER_ENTERED 而不是 valueInputOption = USER_ENTERED 。两个等号而不是一个。错误消息告诉您相同的内容：'value_input_option'（TYPE_ENUM）的值无效，\= USER_ENTERED \ - = USER_ENTERED 不是有效值，但 USER_ENTERED 是。

You have valueInputOption==USER_ENTERED instead of valueInputOption=USER_ENTERED. Two equal signs instead of one. The error message is telling you the same: "Invalid value at 'value_input_option' (TYPE_ENUM), \"=USER_ENTERED\"" -- =USER_ENTERED isn't a valid value, but USER_ENTERED is.

这篇关于使用javascript将数据插入Google表格API的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！