Hi everyone! I'm having trouble with email approval for my ServiceNow registration. I have one Email Script record and one Inbound Email Action record:
Email Script:
(function runMailScript(current, template, email, email_action, event) {
var toAddress = gs.getProperty('glide.email.username'); // ou coloque fixo
var styleApprove = "background:#278ef3;color:#fff;text-decoration:none;padding:12px 25px;border-radius:4px;font-weight:bold;";
var styleReject = "background:#e14332;color:#fff;text-decoration:none;padding:12px 25px;border-radius:4px;font-weight:bold;";
// Pega o sys_id do registro de aprovação
var approvalSysId = "";
if (current.getTableName() === "sysapproval_approver") {
approvalSysId = current.sys_id.toString();
} else {
var gr = new GlideRecord("sysapproval_approver");
gr.addQuery("sysapproval", current.sys_id);
gr.query();
if (gr.next()) {
approvalSysId = gr.sys_id.toString();
}
}
// Inclui sys_id no assunto e no corpo
var subject = encodeURIComponent("Aprovação – Eliminação de Carta de Risco [" + approvalSysId + "]");
var bodyApprove = encodeURIComponent("ACTION:APPROVE\nSYS_ID:" + approvalSysId);
var bodyReject = encodeURIComponent("ACTION:REJECT\nSYS_ID:" + approvalSysId);
var approveHref = "mailto:" + toAddress + "?subject=" + subject + "&body=" + bodyApprove;
var rejectHref = "mailto:" + toAddress + "?subject=" + subject + "&body=" + bodyReject;
template.print(
'<table style="margin:20px 0;"><tr>' +
'<td style="padding-right:20px;">' +
'<a href="' + approveHref + '" style="' + styleApprove + '">Aprovar</a>' +
'</td>' +
'<td>' +
'<a href="' + rejectHref + '" style="' + styleReject + '">Rejeitar</a>' +
'</td>' +
'</tr></table>'
);
})(current, template, email, email_action, event);
Inbound Email Action:
(function runInboundAction(email, action, event, logger) {
var body = (email.body_text || "").toUpperCase();
var sysIdMatch = body.match(/SYS_ID:([0-9A-F]+)/);
if (!sysIdMatch) {
logger.log("Nenhum SYS_ID encontrado no corpo do e-mail.");
return;
}
var sysId = sysIdMatch[1];
var gr = new GlideRecord("sysapproval_approver");
if (gr.get(sysId)) {
if (body.indexOf("ACTION:APPROVE") > -1) {
gr.state = 2; // Approved
gr.comments = "Aprovado via e-mail";
} else if (body.indexOf("ACTION:REJECT") > -1) {
gr.state = 3; // Rejected
gr.comments = "Rejeitado via e-mail";
}
gr.update();
logger.log("Ação executada para sys_id: " + sysId + " | Novo estado: " + gr.state);
} else {
logger.log("Registro não encontrado para sys_id: " + sysId);
}
})(email, action, event, logger);
I've tried several methods in ServiceNow, sending out emails that meet the requirements, but the registry isn't updating. Can anyone help me?
