The CreatorCon Call for Content is officially open! Get started here.

Generate reports through flow designer

Sprankle
Tera Contributor

I have a requirement to generate reports on schedule basics using flow designer

7 REPLIES 7

Ankur Bawiskar
Tera Patron
Tera Patron

@Sprankle 

not possible directly.

You will have to use custom flow action and write script there to trigger scheduled report

var rec = new GlideRecord('sysauto_report');
if (rec.get('name', 'MyReport')) {
    gs.executeNow(rec);
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

(function execute(inputs, outputs) {

var jobClass = inputs.script_job.sys_class_name;
var trueLookup = new GlideRecord(jobClass);
if(trueLookup.get(inputs.script_job))
{
    outputs.passfail = 'pass';
    SncTriggerSynchronizer.executeNow(trueLookup);
}
else{
    outputs.passfail = 'fail';
}


})(inputs, outputs);tried this on action script

@Sprankle 

so what's your findings?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

I have tired as per your suggestion schedduled report is triggering but as a requirement i need to get the attached report should be send to receipents