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 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.5 Replies
Hi have you tried using the forloop of the flows ?
Ah, sorry, I think I just realised I can use a for loop block...
Is that the most efficient way? I intend to write thousands of rows
The most efficient would be to do a forloop inside your script
Thanks - so you mean like have another python script, import the a postgres library, etc?
Yes