Inserting Data's Into Google Sheets API Using javascript

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

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

    Request URL:!A1:B1?valueInputOption==USER_ENTERED
Request Method:PUT
Status Code:400 
Remote Address:

and my Network Response is

  "error": {
    "code": 400,
    "message": "Invalid value at 'value_input_option' (TYPE_ENUM), \"=USER_ENTERED\"",
    "status": "INVALID_ARGUMENT",
    "details": [
        "@type": "",
        "fieldViolations": [
            "field": "value_input_option",
            "description": "Invalid value at 'value_input_option' (TYPE_ENUM), \"=USER_ENTERED\""

. 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>

<iframe id='ifr' src=''
style="position: absolute;width: 100%;height: 100%;left: 0px;top: 250px;" >

 <iframe id='ifr' src=''style="position: absolute;width: 100%;height: 100%;left: 0px;top: 250px;" >

Here is My Js Code ,

$ = function () {

    var params = {
               "majorDimension": "ROWS",
               "values": [

     var xhr = new XMLHttpRequest();'PUT', '!A1:B1?valueInputOption==USER_ENTERED;headers=false');

     xhr.setRequestHeader('Authorization', 'Bearer ' + access_token);





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.


Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us Javascript

©2020 All rights reserved.