# Getting Value from Payload

**URL:** <https://discourse.nodered.org/t/getting-value-from-payload/36380>\
**Category:** Dashboard\
**Created:** [23 November 2020 08:40 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380 "2020-11-23T08:40:12Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chorum](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/chorum/32/47644_2.png) [@Chorum](https://discourse.nodered.org/u/Chorum)\
**Post date:** [23 November 2020 08:40 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/1 "2020-11-23T08:40:12Z")

</div>

Hello,

i dont like to ask that question but i really cant see a solution.

I get a payload like this:

![sqlpayload](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/a/faf65060a3b167d4ea08e9006dd2c4a2727e4589.png)

i used to get the values with:

msg.payload[0].Getriebe\_Betriebsstunden  
msg.payload[0].Zaehlerstand

but i dont get the values anymore.

May be someone can see what i am doing wrong ?

---

<div class="post-metadata">

**Author:** ![ArneR](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/arner/32/95658_2.png) [@ArneR](https://discourse.nodered.org/u/ArneR)\
**Post date:** [23 November 2020 08:54 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/2 "2020-11-23T08:54:11Z")

</div>

Hey

Not sure.. But what about "msg.payload.Getriebe\_Betriebsstunden"?  
You can copy the path in the debug mode. But I don't think that's the problem.

---

<div class="post-metadata">

**Author:** ![Chorum](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/chorum/32/47644_2.png) [@Chorum](https://discourse.nodered.org/u/Chorum)\
**Post date:** [23 November 2020 08:58 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/3 "2020-11-23T08:58:47Z")

</div>

mhmm i even dont get:

msg.payload.test = "test";

in the payload.

thats strange

---

<div class="post-metadata">

**Author:** ![ArneR](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/arner/32/95658_2.png) [@ArneR](https://discourse.nodered.org/u/ArneR)\
**Post date:** [23 November 2020 09:02 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/4 "2020-11-23T09:02:17Z")

</div>

Can you paste your flow? So I can look at it.

---

<div class="post-metadata">

**Author:** ![Chorum](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/chorum/32/47644_2.png) [@Chorum](https://discourse.nodered.org/u/Chorum)\
**Post date:** [23 November 2020 09:10 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/5 "2020-11-23T09:10:07Z")

</div>

the message comes from an SQL Node and passes a funcion node.

so the easiest thing should be adding a payload to that message.

i think i am doing something stupid that that dont work...

Part of the Flow after SQL Node:

![global16](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/0/90825dc9160de474e75e74a3d815ac71c758ff20.png)

```auto
[{"id":"8141661b.7eec98","type":"function","z":"eb7b6cd.dbec29","name":"Read Globalisierung W16","func":"msg.payload.test = 1;\n//global.set('W16Bhreaded', msg.payload[0].Getriebe_Betriebsstunden);\nglobal.set(msg._topic+'Bhreaded', msg.payload[0].Getriebe_Betriebsstunden); //Pst Betriebsstunden\nglobal.set(msg._topic+'Zaehlerstand', msg.payload[0].Zaehlerstand); //Zähler allgemeine Betriebstunden Pst\n//global.set(msg._topic+'Getriebe_Betriebsstunden',global.get(msg._topic+'Bhreaded')); //Umleitung für die Tabellenanzeige\nmsg.payload.W12Bhreaded = global.get('W12Bhreaded');\n//msg.payload.W12Zaehlerstand = global.get('Zaehlerstand');\nmsg.payload.W12Zaehlerstand = msg.payload.Zaehlerstand;\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":2630,"y":1020,"wires":[[]]},{"id":"bdf56dc4.6b204","type":"switch","z":"eb7b6cd.dbec29","name":"Read Out Splitter","property":"_topic","propertyType":"msg","rules":[{"t":"eq","v":"W01","vt":"str"},{"t":"eq","v":"W01.2","vt":"str"},{"t":"eq","v":"W02","vt":"str"},{"t":"eq","v":"W03","vt":"str"},{"t":"eq","v":"W03.2","vt":"str"},{"t":"eq","v":"W04","vt":"str"},{"t":"eq","v":"W05","vt":"str"},{"t":"eq","v":"W06","vt":"str"},{"t":"eq","v":"W07","vt":"str"},{"t":"eq","v":"W08","vt":"str"},{"t":"eq","v":"W09","vt":"str"},{"t":"eq","v":"W10","vt":"str"},{"t":"eq","v":"W11","vt":"str"},{"t":"eq","v":"W12","vt":"str"},{"t":"eq","v":"W13","vt":"str"},{"t":"eq","v":"W14","vt":"str"},{"t":"eq","v":"W15","vt":"str"},{"t":"eq","v":"W16","vt":"str"},{"t":"eq","v":"W17","vt":"str"}],"checkall":"true","repair":false,"outputs":19,"x":2350,"y":920,"wires":[[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],[],["8141661b.7eec98"],[]]},{"id":"93fb8f5f.0b3a5","type":"comment","z":"eb7b6cd.dbec29","name":"Here is the SQL Node","info":"","x":2160,"y":920,"wires":[]}]  

```

---

<div class="post-metadata">

**Author:** ![Chorum](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/chorum/32/47644_2.png) [@Chorum](https://discourse.nodered.org/u/Chorum)\
**Post date:** [23 November 2020 09:35 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/6 "2020-11-23T09:35:50Z")

</div>

with:  
msg.payload[0].abc = "abc";

i get:  
 ![globaloutput1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/c/1c43e98e4135c69de3ce9d7f5faeca32e49dbdbc.png)

so i am not able to add normal payload variables, may be its the same with setting global variables.

---

<div class="post-metadata">

**Author:** ![Chorum](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/chorum/32/47644_2.png) [@Chorum](https://discourse.nodered.org/u/Chorum)\
**Post date:** [23 November 2020 09:45 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/7 "2020-11-23T09:45:28Z")

</div>

Ok, here is the solution:

i could read the Values, but wasnt able to show them as msg.payload.value i had to use msg.payload[0].value because of the structure of the mesage.

Thank you!

---

<div class="post-metadata">

**Author:** ![ArneR](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/arner/32/95658_2.png) [@ArneR](https://discourse.nodered.org/u/ArneR)\
**Post date:** [23 November 2020 09:53 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/8 "2020-11-23T09:53:28Z")

</div>

Ooh, oké! Goodluck 🙂

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [7 December 2020 09:53 UTC](https://discourse.nodered.org/t/getting-value-from-payload/36380/9 "2020-12-07T09:53:37Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.