Node-red-contrib-mssql-plus => value in database is empty

Hi, so a couple of things first.

  1. Please post code between backticks
    ```
    like this
    ```

  2. When copying values from the debug sidebar, use the "Copy Value" button that appears under your mouse cursor when you hover over the message
    BX00Cy7yHi


On you your issue...

The debug BEFORE SQL shows payload is an array but in your SQL, you try to access payload.ts_pos_wo_id - an array is accessed by [] square brackets.

To simplify things (and avoid mistakes) use the "Copy Path" button that appears under your mouse cursor when you hover over the item of interest & use that.


Lastly,

I strongly recommend you use the parameters instead of {{{mustache}}} - this will protect your database against SQL injection.