Hi Experts,
I have a requirement where users submit a Catalog Item and upload a file using an Attachment Variable on the RITM.
I also have a Scheduled Report that generates and emails an Excel file.
What I would like to achieve is:
Read the attachment uploaded through the RITM attachment variable.
Generate the scheduled Excel report.
Include the user-uploaded attachment along with the generated Excel file in the email (or attach it to the generated report record/process).
My questions are:
1. Is there an out-of-the-box way to include an attachment from an RITM attachment variable in a Scheduled Report email?
2. If not, what is the recommended approach?
3. Has anyone implemented this using a Scheduled Script, Notification Email Script, Flow Designer, or GlideSysAttachment?
4. If the attachment variable stores only a reference, how can I retrieve the corresponding sys_attachment record and attach it to the outgoing email/report?
Any sample code or best practices would be greatly appreciated.
Thanks in advance!
