MySQL Node doesn't pass payload?

#1

I’m writing a flow which processes an HTML form. In order to carry out the form processing I need to query a MySQL/mariadb database and act on the returned query. So far, so normal, I’ve got the queries working fine.

The problem I run into is that the submitted form data are being passed happily in the payload from node to node, until I get to the MySQL node and as far as I can see, it drops everything from the payload except the returned query.

Is there any way to make the MySQL node (or an alternate node) to pass the payload of the incoming message and add the database’s output? Is there a workaround? Or am I missing something?

0 Likes

#2

Copy the msg.payload to msg.somethingelse prior to the MySQL node ?

1 Like

#3

Yes, that works… Thanks…

I can’t believe I’ve been puzzling about this problem for hours and the answer is so obvious…

0 Likes