I am attempting to generate a CSV from a list of data that is hundreds of lines long.
Each row requires multiple searches of the same database that is separate to the list that’s being actioned. I cannot find an efficient way to do this because I can’t pass the row being processed into a filter function. This limitation means it’s not practical to run in the front end.
How do you get the created CSV out of the backend once the process has completed? Ideally I would like it to trigger a download, as it does if run in the front end.
Hey @QIRO , this is possible, but note that even calling from the backend will have a similar UX as the user is waiting to download the file anyway - so on the Front-end would be ok if Privacy isn’t an issue.
A workaround for allowing the user to other things while the file is prepped would be an email notification or saving this file to a data type for the user to download later.
You can create fairly complex csv’s from multiple data sources using JSON and the :format as text operator on the front end. This is reasonably performant into the low 1000s of items.
Have a quick look through the forums but let me know if you’d like a further breakdown.
