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.
[API Help]
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 |
NO |
| 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
| Label |
DataType |
Length |
Raw |
Description |
| spreadsheetId |
DT_WSTR |
100 |
False |
|
Input Columns
| Label |
DataType |
Length |
Raw |
Description |
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |
