I have a workflow, if a entry in a databse not exist, we create. because its not possible in one line i split out the workflows. 2 node entries on one node exit (before) one of the flows create the database entry the other ask for ID but crateing not done now. so I put a wait node in this line. but the wait node stop also the flow in a line, the node is not connected. how can i solve this ?
What if you check for existence of the record and split the execution where if it doesn’t exist the flow creates the record, and then merge the flows with a merge node before doing other things with the record?
Something like
Exactly this, i have before. But the merge after a SQL node not work. The SQL node give out json success.
After this the merge node executed success but without output. Really nothing not a empty json.
Sorry I have troubles understanding the issue, let me try to ask questions.
I understand you have a similar approach to splitting the flow and checking if the record exists. The issue is with merge node after the SQL Insert node and the issue is that the merge node doesn’t have an output. Did I get this right?
If I understood your issue correctly:
- What output do you expect? The ID of the inserted record?
- If so, do you have the SQL outputting the ID of the inserted record?
I think you are describing a very similar challenge to what you face using a REST API to conditionally create things before continuing the workflow.
This post might give you some ideas about how to carry everything forward through the found vs. create branches.
ok, sorry for delay. the problems, because i do this with a delay was multible things. last because german language and not escaped by mysql. i go back to jabbson solution (i start with) and after success escaping it runs well ..
sorry, the error was beween keyboard and chair 