How to cell.content.set when the content is a mailto: hyperlink?
Here's my code to set a cell value with plain text.
- resource_id = response.get("data").get("id");
- // Put some data in the sheet
- params = Map();
- params.put("method","cell.content.set");
- params.put("worksheet_name","Order_by_Athlete");
- params.put("row",1);
- params.put("column",2);
- params.put("content", :"some data"));
- response = invokeurl
- [
- url :"https://sheet.zoho.com/api/v2/" + resource_id
- type :POST
- parameters:params
- headers:headersMap
- connection:"sheet_data_all"
- ];
Here's the Deluge output from cell.content.get. How do I parameterize that to use in a cell.content.set?
{
"method": "cell.content.get",
"row_index": 6,
"column_index": 8,
"content": "Email ACME",
"status": "success"
}