Hello, i would like to read a value from a SQL database and use the value in my flow. its my first attempt to do that and i have a Problem, Maybe based on msg structure misunterdstanding. Here is a Picture of the part of the Flow: [flow] Here the part of the flow: [{"id":"17fd4fda.6273f","type"…

The payload is an array with an object, you can retrieve it like: msg.payload[0].Getriebe_Betriebsstunden

Hi, on of my attempts was msg.payload.Zeitausgabe = msg.payload.0.Getriebe_Betriebsstunden; but didnt work :slight_smile: sadly msg.payload.Zeitausgabe = msg.payload[0].Getriebe_Betriebsstunden; doesnt give me the value :frowning:

It does give you the value. [Screenshot 2020-08-20 at 10.13.22] What does your output look like ?

if i use : msg.payload.Zeitausgabe = msg.payload[0].Getriebe_Betriebsstunden; i get : [payload Weitergabe output2] so Nothing changed… My hope was for: Zeitausgabe = 00:01 :slight_smile:

Can you post you full flow with some dummy input ? (ie. dont use the mysql nodes as we cannot replicate). ah no you cannot set it to: msg.payload.Zeitausgabe because msg.payload is already an array. If you set it to msg.Zeitausgabe or remove msg.payload first.

sorry but its to big to post, so i have to post that part. what i can give is a bigger overview: [überblick]

See previous response: You cannot set it to msg.payload.Zeitausgabe because msg.payload is already an array. Set it msg.Zeitausgabe or remove msg.payload first.

You should be able to use msg.payload = {Zeitausgabe: msg.payload[0].Getriebe_Betriebsstunden}

So, i used : msg.topic = "ATESTEO/Wolfsburg/W03"; var Buffer; Buffer = msg.payload[0].Getriebe_Betriebsstunden; delete msg.payload msg.Zeitausgabe = Buffer; return msg; so i get rid of the Array too.. Thank you both for your help!!!

I advise against using a variable called Buffer, buffer is a keyword in javascript. In this case what you have will work ok, but it may cause confusion in the future. Also the convention in javascript is not to start variables with a capital letter, again it will not stop it working but the code w…

ok i will Change that. i think i stumbled in an other problem but i will think about that first :slight_smile:

Problem getting Value from SQL SELECT

Dashboard

Chorum 20 August 2020 13:12 18

Update: After the join node, now i get 2 Messages with the same structure and order. the only difference is the payload. the single value is in one message and the original value pack is in the other.

i dont understand why i dont get a single message….

Topic		Replies	Views
Getting Value from Payload Dashboard	8	976	7 December 2020
How to read specific value from Array General	11	7115	30 August 2022
Extracting a value from an MS-SQL database General database	9	968	2 May 2022
Msg split, choose option and MySQL select General	45	2149	23 April 2020
Read SQL value and convert to Domoticz MQTT Topic - payload issue General	24	2230	23 August 2019

Problem getting Value from SQL SELECT

Related topics