Hello Everyone,

A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate complex tasks and calculations.

We have a few pre-defined gallery functions that are ready to use. You can access the same using the steps available in this link.        

This week, I would like to highlight one of the Gallery custom functions - Approve / Reject Associated TimeLog Entries   

 

Use case:-

This function helps you to automatically approve/ reject the timelogs associated to the issues based on the value provided in the Argument. To automate this action, you can associate this custom function to Business Rules.

Todo:-

Create a connection for the Zoho Projects service with the scopes "ZohoProjects.timesheets.READ, ZohoProjects.timesheets.UPDATE" to replace 'xxxxx' with the connection name. Click this link below to learn how to create the connection. Refer the attached screenshot of the Arguments.

Custom function code:-

projectsDomain = "https://projectsapi.zoho.com";

// approveStatus = approved | rejected for rejected status note is mandatory.

getAssociatedTimelogEntriesAPI = projectsDomain + "/api/v3/portal/" + portalId + "/projects/" + bugProjectId + "/timesheet";

getAssociatedTimelogEntriesParam = Map();

getAssociatedTimelogEntriesParam.put("page",1);

getAssociatedTimelogEntriesParam.put("per_page",200);

getAssociatedTimelogEntriesParam.put("view_type","projectspan");

moduleJson = Map();

moduleJson.put("id",bugId);

moduleJson.put("type","issue");

getAssociatedTimelogEntriesParam.put("module",moduleJson);

info getAssociatedTimelogEntriesParam.toString();

info getAssociatedTimelogEntriesAPI;

getAssociatedTimelogEntriesResp = invokeurl

[

url :getAssociatedTimelogEntriesAPI

type :GET

parameters:getAssociatedTimelogEntriesParam

connection:"xxxxxxxxx"

];

info getAssociatedTimelogEntriesResp;

if(getAssociatedTimelogEntriesResp != null && getAssociatedTimelogEntriesResp.get("time_logs") != null)

{

updateLogHoursStatusAPI = projectsDomain + "/api/v3/portal/" + portalId + "/logs";

logEntriesList = List();

bugTimeLogEntries = getAssociatedTimelogEntriesResp.get("time_logs");

for each  timeLog in bugTimeLogEntries

{

logDetails = timeLog.get("log_details");

for each  logDet in logDetails

{

logId = logDet.get("id");

logMap = Map();

logMap.put("approval_status",approvalStatus);

logMap.put("id",logId);

logMap.put("module","issue");

logNote = Map();

logNote.put("notes",approvalNote);

logMap.put("extra_data",logNote);

logEntriesList.add(logMap);

}

}

payload = "[" + logEntriesList + "]";

updateLogStatusResp = invokeurl

[

url :updateLogHoursStatusAPI

type :PATCH

parameters:payload

connection:"xxxxxxxxx"

];

info updateLogStatusResp;

}