[Scriptrunner] How to automate "Export to Excel" function for a specific Structure

[Gonzalo Perez Alonso]

Our team wants to send an email with a structure's report. We need to use "Export to Excel" native functionality (see screenshot 1) as we need to retrieve data from auto-calculated columns (custom)

We are planning to send it via Scriptrunner job but we are not able to find a way to select this functionality (we could do it with BetterExcel templates but not with the native function)

PS: We already have tested this groovy but we couldn't apply it to our case. It gives an error on line 12 (see screenshot 2)

Thanks in advance!

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Gonzalo Perez Alonso 

It's unclear why the script is returning an error, we would need to look into your setup in more detail, including your Structure & Scriptrunner versions. Please reach out to us directly at our support portal and we'll go from there.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Gonzalo Perez Alonso]

Sure! My colleague will open a ticket!

Thanks a lot for your quick response.