googleSheetUpdateRow

Update an exisitng row in a Google worksheet. Note that this only works with worksheets containing column headers.

Required Parameters

new:*	The column values to be updated.

Optional Parameters

authtoken	The authentication token retrieved from a previous authentication. If left empty, email and password are required.
email	The email address used to authenticate with Google. The email is required unless an authtoken is used.
password	The password used to authenticate with Google. The password is required unless an authtoken is used.
timeout	Timeout, in seconds, for the operation to complete. Zero (0) means no timeout.
proxy_server	IP Address or host name of the proxy server used for the request.
proxy_auto	Whether or not Proxy should be detected from Windows system settings. This takes precedence over other proxy settings and is not available in Java. The allowed values are: TRUE, FALSE.
proxy_port	Port number of the proxy server.
proxy_user	User ID used to authenticate with the proxy server.
proxy_password	Password used to authenticate with the proxy server.
proxy_authscheme	The proxy server The allowed values are: BASIC, DIGEST, PROPRIETARY, NONE, NTLM.
proxy_authtoken	The proxy authentication token.
proxy_ssltype	The proxy server The allowed values are: AUTO, ALWAYS, NEVER, TUNNEL.
firewall_server	IP Address or host name of the firewall.
firewall_port	Port number of the firewall.
firewall_user	User ID used to authenticate with the firewall.
firewall_password	Password used to authenticate with the firewall.
firewall_type	The type of the firewall. The allowed values are: TUNNEL, SOCKS4, SOCKS5.
logfile	The connector will log the exchange/transferred data to this file.
rowlink	The link for the row to be updated. If you know the rowlink, enter it to avoid extra requests to the server. This can be obtained by a call to googleSheetsQuery. If left empty, the spreadsheet, worksheet and row are required.
name	The spreadsheet name.
sheetname	The worksheet name.
id	The ID of the worksheet that you are updating. This can be obtained from the googleSheetListWorksheets operation. Not needed if specifying 'id' or 'rowlink'. Otherwise, if you know the ID, enter it to avoid the extra requests to the server. If left empty, the 'name' and 'sheetname' are required.
row	The row # of data to be updated. The column headers cannot be deleted so the first row of data is row 1.
etag	The ETag value for the row to be deleted. If provided, this will ensure that the row has not been subsequently updated. This can be obtained from the googleSheetQuery operation.
shareauthtoken	Whether or not to use the shared authentication token from a previous request, if one exists that matches the user name and password.

Output Attributes

ggl:rowlink	The link for the updated row. This can be used for updating/deleting the row.
ggl:success	Indicates the success of the operation.