# Extracting json data

**URL:** <https://discourse.nodered.org/t/extracting-json-data/20435>\
**Category:** General\
**Created:** [16 January 2020 09:02 UTC](https://discourse.nodered.org/t/extracting-json-data/20435 "2020-01-16T09:02:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ian](https://avatars.discourse-cdn.com/v4/letter/i/bb73d2/32.png) [@Ian](https://discourse.nodered.org/u/Ian)\
**Post date:** [16 January 2020 09:02 UTC](https://discourse.nodered.org/t/extracting-json-data/20435/1 "2020-01-16T09:02:03Z")

</div>

Hi

I am receiving json mqtt data in the following format.  
I have to decipher what the registers mean.  
I think the 2 I am interested in are the registers in **bold**  
How can I extract those registers into 2 payloads?

{"elecMtr":{"0702":{"03":{"01":"00000001","04":"00","02":"000003E8","07":" **2200015007642**","03":"FB","08":"","00":"00","06":"00"},"00":{"07":"00000000","01":"000000000002","00":"00000017AB42","14":"02","02":"000000000000"},"04":{"01":"000845","03":"027E91","00":"00000112","02":"00810E"},"02":{"00":"00"}},"0708":{"01":{"01":"????? Energy"}}},"gasMtr":{"0702":{"03":{"01":"00000001","12":"00","02":"000003E8","07":" **3920369105**","03":"2B","08":"","00":"01","06":"80"},"00":{"00":"00000010B378","14":"02"},"0C":{"01":"00BBA6","40":"1A6DD1","30":"064052"},"02":{"00":"00"}},"0708":{"01":{"01":""}}},"ts":"2020-01-16 08:55:16","hversion":"-SMETS2","time":"5E2024F4","zbSoftVer":"1.2.4","gmtime":1579164916,"pan":{"rssi":"B1","status":"joined","nPAN":"00","join":"0","lqi":"54"},"smetsVer":"SMETS2","ets":"2000-01-01 00:00:00","gid":"70B3D521E000891F"}

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [16 January 2020 09:07 UTC](https://discourse.nodered.org/t/extracting-json-data/20435/2 "2020-01-16T09:07:15Z")

</div>

Hi @Ian

this page in the docs explains how you can understand the structure of a message and find the path to any of its elements using the Debug sidebar: [https://nodered.org/docs/user-guide/messages](https://nodered.org/docs/user-guide/messages)