代码之家  ›  专栏  ›  技术社区  ›  Saravana Kumar

使用javascript将数据插入Google Sheets API

  •  2
  • Saravana Kumar  · 技术社区  · 8 年前

    我正在尝试将我的数据插入google Sheet API Link

    在尝试之后,我没有错误 PUT 400() 在我的控制台中, 在我的 网络标头

        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,

    <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));
    
    
                };
    
        }]);
    
    1 回复  |  直到 8 年前
        1
  •  2
  •   Sam Berlin    8 年前

    你有 valueInputOption==USER_ENTERED valueInputOption=USER_ENTERED "Invalid value at 'value_input_option' (TYPE_ENUM), \"=USER_ENTERED\"" -- =USER_ENTERED 不是有效值,但 USER_ENTERED