Creator Help

Update Row

Update a Row in Zoho Reports

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'"}

Example

Sample script to update a row in Zoho Reports from Zoho Creator.

r = zoho.reports.updatedata("test", "contact", { "Name" : "test" }, "Name='My test'");

where,

r is the variable which holds the response returned by Zoho Reports.

Response Format:

{"updatedColumns":"[Name]"}

Related Links

http://www.zoho.com/reports/help/api/updating-data.html

Top