Hello Everyone,

A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow / Business Rules (be it Tasks / Project) and associate the custom function to it.

Requirement:-

To automate this, we need to trigger the custom function when the status of the bug is updated as Re-open. 

Custom function code:-

projectIdColumnName = "ProjectId";

fieldNameColumnName = "FieldName";

oldStatusColumnName = "OldStatus";

newStatusColumnName = "NewStatus";

updatedByColumnName = "UpdatedBy";

workspaceName = "Workspace1";

workspaceResponse = invokeurl

[

url :"https://analyticsapi.zoho.com/restapi/v2/workspaces"

type :GET

connection:"XXXXXXX"

];

workspaceDetails = workspaceResponse.get("data").get("ownedWorkspaces");

for each  workspaceDetail in workspaceDetails

{

if(workspaceDetail.get("workspaceName").containsIgnoreCase(workspaceName))

{

workspaceId = workspaceDetail.get("workspaceId");

analyticsOrgId = workspaceDetail.get("orgId");

break;

}

}

if(workspaceId == null)

{

workspaceDetails = workspaceResponse.get("data").get("sharedWorkspaces");

for each  workspaceDetail in workspaceDetails

{

if(workspaceDetail.get("workspaceName").containsIgnoreCase(workspaceName))

{

workspaceId = workspaceDetail.get("workspaceId");

analyticsOrgId = workspaceDetail.get("orgId");

break;
}

}

}

headersMap = Map();

headersMap.put("ZANALYTICS-ORGID",analyticsOrgId);

viewName = "table1";

viewResponse = invokeurl

[

url :"https://analyticsapi.zoho.com/restapi/v2/workspaces/" + workspaceId + "/views"

type :GET

headers:headersMap

connection:"XXXXXXX"

];

viewDetails = viewResponse.get("data").get("views");

for each  viewDetail in viewDetails

{

if(viewDetail.get("viewName").containsIgnoreCase(viewName))

{

viewId = viewDetail.get("viewId");

break;

}

}

statusTimelineMap = Map();

statusTimelineMap.put(projectIdColumnName,projectId);

statusTimelineMap.put(fieldNameColumnName,projectName);

statusTimelineMap.put(oldStatusColumnName,issueId);

statusTimelineMap.put(newStatusColumnName,issueName);

statusTimelineMap.put(updatedByColumnName,UpdatedBy);

columns = Map();

columns.put("columns",statusTimelineMap);

paramsMap = Map();

paramsMap.put("CONFIG",columns.toString());

analyticsResponse = invokeurl

[

Make sure to update the column name, workspace name and table name in the above code and replace XXXXXXX with the Zoho Analytics connection link name which has the scopes: ZohoAnalytics.data.create, ZohoAnalytics.metadata.read. 

Check this link to learn how to create the connection. A screenshot of the list of parameters to be mapped is also attached for reference. 

We hope you found this post useful. If you have any questions, feel free to share them in the comments below.