Hi there, I've go through different posts here, but wasn't able to find a proper solution. It's my first go with Node-Red and my objective is the following: I have sensors variables from S7 PLC from which I have to get value to populate a Mysql db. I've mounted the Mysql db node with no problems …

Hi found out the error @Colin ! You were right! My msg.payload.metri wasn't there. I wrongly assumed that the "variable" name you give to a node was to be consider as its "name", when it wasn't. Now I'm properly writing on the MySQL db the meters. Time to a new adventure! Thanks! Michele

Pass S7 variable to Mysql query

General

Eimerich 23 February 2021 14:09 3

Hi Colin,
thanks a lot for your reply.
I'll surely have a look into the suggested Essentials.
In the meantime this is the debug from the S7 Node

23/2/2021, 15:04:51node: 3f5809af.a2d146
metri : msg.payload : number
7654

I'm passing the wrong value to the function?
In the meantime I'm going to "EssentialsMe"...

Thanks!
Michele

Topic		Replies	Views
Read values from S7 component to mysql query General	14	2069	28 October 2019
How to pass payload data from node red to mysql General database	7	3093	13 January 2022
S7-1200 to MariaDB Industrial	2	241	27 June 2023
Send data from s7 to mysql General node-red-dashboard	12	1484	24 November 2021
How to pass payload data from user "form" to function General	16	1949	18 September 2020

Pass S7 variable to Mysql query

Related topics