Hello. 

I use action “Execute SQL” in integration. It take label_name and number_coppies from internal database based on variables from incoming Json and save record set to variable %sql%. Next “for each database record” action is executed and label is printed.

Now I need to have 2nd SQL. I tried to make additional “execute sql” but then variable %sql% is replaced by the second “execute sql”.

I tried to use %sql1% variable in the 1st sql and %sql2% variable in the 2nd sql and next merge them in the “set variable” action but it doesn't work.

I also tried single “execute sql” with UNION ALL but then no records are returned.

Please suggest how to manage it.

Thanks