Still getting to know Retool but loving it so far.
As I've gotten into Workflows for ETL management, I've run into an issue where, when updating databases, the loop cache is too big for memory.
Ideally, I would like to get a list of values (variables) from my Retool Database, then fetch, transform, and save data related to a single value. In other words, one full workflow operation for one item from a static list, then continue to the next, and the next, etc. The goal is to avoid creating a gigantic cache in the loop step.
Is there a way to construct a workflow that will loop through a list, then create resulting REST calls, but do so individually and not create a massive cache in the middle of the workflow?
Thank you for your advice!