EndPoint Execute Command(s)
Name
batch_update_request
Description
Perform various operations available in online editor such as copy, paste, format, merge. Add multiple JSON command by adding comma after first command (e.g. requests : [ {..cmd1..} , {..cmd2..}, {..cmd3..} ] ) Refer to example requests on help link.
[Read more]
Parameters
Parameter |
Label |
Required |
Options |
Description |
Body |
Request Body |
YES |
|
|
TabId |
TabId |
YES |
|
Numeric ID of SpreadSheet Tab for which you like to delete rows/columns. For first tab its 0. You can find this ID from Sheet URL in browser. Get Number after edit#gid= (thats your Tab ID)
|
SpreadSheetId |
SpreadSheetId |
YES |
Option |
Value |
Enter Your Sheet Id |
|
Example Sheet Id |
1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
|
Enter unique spreadsheet Id. To obtain sheet Id. Open spreadsheet in browser and check URL. You will example value like 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms that is your sheet id.
|
Output Columns
Name |
DataType |
Length |
Raw |
Description |
spreadsheetId |
DT_WSTR |
100 |
False |
|
Input Columns
Name |
DataType |
Length |
Raw |
Description |
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |