Hi Everyone,
I’m working on an inbound email action to automate CyberArk datatable updates.
The process is:
User sends an email with an Excel template
My inbound email script creates an import set
Attachments from sys_email should be copied into the import set
A transform map processes the data
Inbound Email Action is NOT triggering
Even when sending an email with the correct subject, the inbound action is not firing.
I have already checked:
Action is Active
Condition uses the correct Subject Contains value
User sending the email exists in the system
Instance can receive emails (inbound working)
But the script is not running at all (no logs in system log).
However, the attachments are not getting copied.
I suspect the issue is related to how the script fetches attachments using table_sys_id of the email record (sys_id vs uid).
Here is the script I am currently using:
(function runAction(current, event, email, logger, classifier) {
// Create import set
var imp = new GlideRecord('sys_import_set');
imp.initialize();
imp.data_source = '407fdb7987f0d210654653973cbb359c';
imp.table_name = 'u_cyberark_data';
var impSysID = imp.insert();
gs.info("Import Set: " + impSysID);
// Copy email attachments into import set
var sa = new GlideSysAttachment();
var att = new GlideRecord('sys_attachment');
att.addQuery('table_name', 'sys_email');
// Using sys_id + uid of the email
var qc = att.addQuery('table_sys_id', email.getRecord().getValue('sys_id'));
qc.addOrCondition('table_sys_id', email.getRecord().getValue('uid'));
att.query();
gs.info("Email sys_id: " + email.getRecord().sys_id);
while (att.next()) {
sa.copy(att.table_name, att.sys_id, 'sys_import_set', impSysID);
gs.info("Copied attachment: " + att.sys_id);
}
// Trigger transform
var tm = new GlideRecord("sys_transform_map");
tm.addQuery("name", "Cyberark Data Table Map");
tm.query();
if (tm.next()) {
var transformer = new GlideImportSetTransformer();
transformer.transformAllMaps(impSysID, tm.sys_id);
}
})(current, event, email, logger, classifier);
