I have the E-mail in node working fine and can retrieve the sender's email address as msg.from (as proven with a debug node). It gets returned with quotation marks; for example: "purchasing@my_company.com" However, my next step is to pass that email address to a SQL query (shown below). Instead o…

Ps, I am pretty sure I know what the issue is but I want to see what msg.query shows I am certain you will see it too It's worth finding the problem as it will help you greatly in future problems (so don't read the spoiler just yet) ▶ spoiler

Steve-Mcl 29 July 2020 22:31 7

Put a debug before the SQL node set to show complete message.

Run the flow

Expand both debug messages fully and screenshot them.

Check the msg going in has the items you are trying to use in mustache.

Topic		Replies	Views
Using msg.payload in a SQL query General	7	8990	23 June 2020
Using mustache variables in MSSQL node General	2	1039	30 May 2020
Passing array with brackets to MSSQL General	5	247	9 June 2022
Syntax issues with SQL General	4	212	12 December 2022
MSSQL node msg reading General	3	177	7 June 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Using msg.from (received via E-mail in node) in a SQL query

Related topics