good day ,i need to delete records from mysql database before inserting new records.
what is correct workflow here? obviously i cannot insert Delete node before Insert node as i loose data.
i can manually choose function as input for Insert node, but in execution mode it fails
in my case i dont need update but delete/insert sequence. also i need to be sure there are new records so i need to execute delete after Function (so i know there are new records). So insert node gets data from Function node. I can manually get data from previous nodes, but it does not work for Mysql node
Why can’t you delete and then insert? Like you had it before?
Just make sure to also push the rows to some kind of log so you never lose data if something goes wrong.
You are completely right, forgot that was an option.
You can of course also reference the fucntion node to get your data from there, but it would have been more work. As you need to set all seperate fields then.