Update Action¶

Used to change the data in the row. If data in a column is left blank, it will not be changed.

Hello World

for only change Hello &data=Hi

for only change World &data=,Me

Base URL¶

https://script.google.com/.../exec?action=update

Required | The ID of the line to be updated.

Required | New data to be added.

https://script.google.com/.../exec?action=update&id=123456789&data=Hi

All parameters can be sent via POST.

There is also JSON support for named tables (read: Guide / Named Tabled).

{
  "id": "123456789",
  "data": "Hi"
}

{
   "id": "123456789",
   "data": {
      "name": "Hi"
   }
}

status : Boolean - True if it is successful.

data : Array - New data.

message: String - If status is false, it is added instead of data and contains an error message.

{
  "status": true,
  "data": ["Hello", "World"]
}

{
  "status": false,
  "message": "id parameter not found"
}

{
  "status": false,
  "message": "data parameter not found"
}

{
  "status": false,
  "message": "id not exists"
}