You can use updatedata() task to update a row in Zoho Reports from Zoho Creator. This task will return map containing the updated column names.
Syntax
<return value as map> = zoho.reports.updatedata(<DATABASE NAME>,<TABLE NAME>, <Data as map>,<Criteria>);
where,
<return value> is the map object containing response returned by Zoho Reports.
<Database Name> is the name of the database in Zoho Reports, where the <table name> exists
<Table Name> is the name of the table in Zoho Reports, from where the row will be updated
<Data as map> is the data to be updated , for example, { "Name" : "test"}
<Criteria> must be in the following format: {<colName> <operator> <colValue>}, for example, {"Name='test'"}
Sample script to update a row in Zoho Reports from Zoho Creator.
r = zoho.reports.updatedata("test", "contact", { "Name" : "test" }, "Name='My test'");
r is the variable which holds the response returned by Zoho Reports.
Response Format:
{"updatedColumns":"[Name]"}
