1 ACCEPTED SOLUTION
better to use direct notification on table sys_import_set_run (Transform History).
You can call this notification from your flow using Send Notification action
something like this to show the status of inserts, updates, ignored, skipped etc
Email script:
(function runMailScript(current, template, email, email_action, event) {
template.print("Total:"+current.total+"<br/>");
template.print("Inserts:"+current.inserts+"<br/>");
template.print("Updates:"+current.updates+"<br/>");
template.print("Ignored:"+current.ignored+"<br/>");
template.print("Skipped:"+current.skipped+"<br/>");
template.print("Errors:"+current.errors+"<br/>");
//}
})(current, template, email, email_action, event);
