Transform into Excel and attach document to next task

#1

Hello,

I was wondering if it is possible to set an SQL query as a process variable that performs the query on a specific Database and transforms the output into an Excel file. If this is possible (which i believe its is but correct me if I am wrong) is there a way to automatically attach this Excel file to the next task in Flowable (which would be the verification of the completeness of the Excel file)
Thanks a lot in advance.

#2

That’s technically possible, but:

  • do take into account SQL injection and security when doing so (e.g. not letting users fill things in)
  • Flowable doesn’t have a task that transforms something into an Excel file, but you can use a solution such as e.g. Apache POI