I've been writing the SQL code in the function node and it's been a PITA then I found this node.
Well, what am I doing wrong? Doesn't seem to want to read the payload. Can't find much documentation on this.
SQL is just getting the text in the ' ', not the actual payload values. Erased the ' ' around the msg. but it gives formatting errors so not sure what format it needs to be in.