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
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.7 replies
Working with (CSV) file output and python in scripts/workflows
Hello, I am working with an API that returns a large JSON response (like ~2MB). I am doing some transformation in python but then I want my python script to return this as a CSV file object (for use in a workflow step - to email or put in S3 bucket etc) which is proving a bit challenging for me.
Is this achievable and if so, could anyone please share an example or pointer for how to have a python script return a (CSV) file? Thanks in advance!
4 replies