Database Insert Syntax

Question

What is the syntax for the Insert INTO command on a database destination node?  Example:

Insert into Table-Name

(Column1, Column2, Column3)

Values (message.getNode('1'),message.getNode('2'),message.getNode('3'))

What's the syntax to link the corresponding getNode to the  column Values?

Answer 1

The syntax for a CSV would be like the following

Insert into Table-Name
(Column1, Column2, Column3)
Values ({m:1},{m:2},{m:3})

The {m:1} tag points to the 1st column in the csv of the message. Please refer to the reference guide in the help menu for a full list of nodeTags.