WindmillWWindmill
Powered by
stair_spiritS
Windmill•3y ago•
6 replies
stair_spirit

Loop over all items in previous result and write each as a (postgres) db in flow

Hi, can anyone please share any examples or hints for looping over a number of objects (like 5k+) in the previous result and writing each as a row in a db?

I can of course link the inputs in my inline postgresql flow action to each item like
results.b.reports[0].someValue
results.b.reports[0].someValue
but that will insert only the one row for reports[0].
I would like to repeat this and insert a row for as many objects as exist.
WindmillJoin
3,388Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?

Similar Threads

for loop unresponsive in a flow
BravoBBravo / help
16mo ago
How to add a while loop in a flow?
BurdBBurd / help
15mo ago
Execute a script for each flow run
DaanDDaan / help
16mo ago
Single script with long running loop vs flow loop feature
benBben / help
2mo ago
Recent Announcements
henri-c

We're live here https://discord.com/channels/930051556043276338/1278977038430240813

henri-c · 6d ago

rubenf

Infrastructure as code

rubenf · 4w ago

rubenf

As we're preparing for a new Windmill sandbox SDK, we took the opportunity **to open-source NSJAIL sandboxing** and make it available in CE and easier to set. In 1.634.0, just set nsjail to benefit from the tightest security and isolation per job. It's constraining so no need to use it unless you need but now you won't be restricted in security for CE if you need to.

rubenf · 4w ago