Hello everyone. Assuming I have the following SQL table (ignore the fact that the picture is from excel)- [Screenshot_3] And I receive the value 'Jerry' in the payload, how can I extract his phone number from the MS-SQL table? Much thanks,

[image] milner236: I cant seem to be able to call this object out with msg.payload.token No, because as the debug output states, msg.payload is an array. The result of a SQL query is ALWAYS an array - because it has to represent a set of database rows - where each array element is a database…

Steve-Mcl 14 April 2022 09:17 6

Please be aware that this can be susceptible to SQL Injection.

For safety, it is always better to use Stored Procedures or Parameters

Using node-red-contrib-mssql-plus...

1 Like

Importing data from MSSQL into a table in dashboard

Topic		Replies	Views
How to read specific value from Array General	11	6623	30 August 2022
How to access msg.payload array in mssql? General	10	2342	10 June 2020
Value to Array conversion General	6	480	6 March 2021
Newbie - msg.payload into SQL General	7	2196	13 December 2019
MSSQL-Plus - Appending the Query output to incoming payload.msg General	3	343	23 October 2021

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.

Extracting a value from an MS-SQL database

Using node-red-contrib-mssql-plus...

Related Topics