how do I turn a json into a string? json: [ { "id": 123123123 , "birth_date": 4947372010 , "cohort": "default" , "created_at": 1566858506 , "email": "ferreira1@hotmail.com" , "first_name": "Alberto" , "last_name": "Saulo ferreira20" , "phone": 5548988087118 , "source": "app" , "unsubscr…

Thank you for pointing this out. You can use the Split in Batches node, create a batch of one, and connect the Output of the Microsoft SQL node to the Split In Batches node. Let me know if you need more help :slight_smile:

n8n

Parse json to string

Questions

leosantosx May 31, 2021, 3:37pm 7

Microsoft SQL and multiple items Questions

Ah yes you are sadly correct. It looks like it got implemented wrongly and it executes only once. We have to fix that in a future version of the node (changing it now could break the workflows of people). So what you would have to do for now is to use the SplitInBatches node set to 1 and then iterate with it over the items.

show post in topic

Home
Categories
FAQ/Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled