# Getting value from MQTT message

**URL:** https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320
**Category:** General
**Created:** [20 October 2022 09:56 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320 "2022-10-20T09:56:59Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![dforster](https://avatars.discourse-cdn.com/v4/letter/d/59ef9b/32.png) [@dforster](https://discourse.nodered.org/u/dforster)
#### Post date: [20 October 2022 09:57 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/1 "2022-10-20T09:57:00Z")

</div>

Hello,

I am trying to retrieve the value for "accumEnergyTotal" in the image below so I can output this in the message payload. I have tried and tried and as yet not succeeded. Could someone help me please? Cheers Daniel

 ![Screenshot 2022-10-20 at 10.44.01](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/c/ac7c9630f8d5ce36c962f6c8b26a52014350ac2a.png)

---

<div class="post-metadata">

### Author: ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)
#### Post date: [20 October 2022 10:02 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/2 "2022-10-20T10:02:17Z")

</div>

looks like msg.payload.states[2].accumEnergyTotal.value

There are buttons at the right hand side of the debug pane that let you copy an object's path. Very useful

---

<div class="post-metadata">

### Author: ![dforster](https://avatars.discourse-cdn.com/v4/letter/d/59ef9b/32.png) [@dforster](https://discourse.nodered.org/u/dforster)
#### Post date: [20 October 2022 10:12 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/3 "2022-10-20T10:12:58Z")

</div>

J,

I tried this (see image below) but it still comes up with the full message.

Cheers - Daniel

 ![changeMPNR](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/3/c303ec03b74c18a9d8803abb58275037473bcccb.png)

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [20 October 2022 10:18 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/4 "2022-10-20T10:18:52Z")

</div>

Have you deployed the change?

Where is the debug connected in your flow (before/after the `change` node)?

---

<div class="post-metadata">

### Author: ![dforster](https://avatars.discourse-cdn.com/v4/letter/d/59ef9b/32.png) [@dforster](https://discourse.nodered.org/u/dforster)
#### Post date: [20 October 2022 10:27 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/5 "2022-10-20T10:27:47Z")

</div>

Steve,

Thanks for coming back. Yes, all deployed. See images below. Dan

 ![FullWithPopout](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/e/9e1756ca7db8224bc53ac554eeca20a4b6e03428.png)  
 ![FullA](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/8/e810260555ac464cbcb6c8919b073ab5340770cd.jpeg)

---

<div class="post-metadata">

### Author: ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)
#### Post date: [20 October 2022 10:36 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/6 "2022-10-20T10:36:58Z")

</div>

That shouldn't happen!

Can you see what you get if you change the debug node to show the complete message?

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [20 October 2022 10:37 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/7 "2022-10-20T10:37:42Z")

</div>

Did you use the `copy path` button - that path looks incorrect.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/4/b4a0ffbec9b6f6564a4f760937b4c3dd5768f139.png)

---

<div class="post-metadata">

### Author: ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)
#### Post date: [20 October 2022 10:41 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/8 "2022-10-20T10:41:45Z")

</div>

oops my mistake, well spotted!

It doesn't explain why the whole payload is still there though.  
If you set msg.payload to something that doesn't exist, it should become Undefined?

---

<div class="post-metadata">

### Author: ![dforster](https://avatars.discourse-cdn.com/v4/letter/d/59ef9b/32.png) [@dforster](https://discourse.nodered.org/u/dforster)
#### Post date: [20 October 2022 10:47 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/9 "2022-10-20T10:47:38Z")

</div>

So if I use copy path beside the value I get this. payload.states[2].value

and if I use the copy path beside accumEnergyTotal I get this payload.states[2].name

---

<div class="post-metadata">

### Author: ![dforster](https://avatars.discourse-cdn.com/v4/letter/d/59ef9b/32.png) [@dforster](https://discourse.nodered.org/u/dforster)
#### Post date: [20 October 2022 11:01 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/10 "2022-10-20T11:01:47Z")

</div>

Fixed it 🙂 changed it to this 'msg.payload.states[2].value'

Many thanks to both you and J (in previous reply). Happy man now I can see how the utility is going to rip me off for power I buy... (40p + per kWh) - Dan

---

<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: [19 December 2022 11:01 UTC](https://discourse.nodered.org/t/getting-value-from-mqtt-message/69320/11 "2022-12-19T11:01:51Z")

</div>

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