How to insert an array into mssql?

General
21

bro by using this way

SET @val1= '{{{msg.payload[0]}}}';
SET @val2= '{{{msg.payload[1]}}}';

null data is adding into database.

22

you need to put debug nodes before and after like i've said several times now

23

also, it may be...

SET @val1= '{{{payload[0]}}}';
SET @val2= '{{{payload[1]}}}';

check the built in help on the MSSQL-PLUS node - it gives you examples.

24

I have a feeling msg part is not required when accessing msg properties in {{{mustache}}}

Only needed for {{{flow.xxx}}} and {{{global.xxx}}}