# Json "nesting" - extracting key data

**URL:** <https://discourse.nodered.org/t/json-nesting-extracting-key-data/33569>\
**Category:** General\
**Created:** [30 September 2020 13:42 UTC](https://discourse.nodered.org/t/json-nesting-extracting-key-data/33569 "2020-09-30T13:42:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![haskle](https://avatars.discourse-cdn.com/v4/letter/h/e19adc/32.png) [@haskle](https://discourse.nodered.org/u/haskle)\
**Post date:** [30 September 2020 13:42 UTC](https://discourse.nodered.org/t/json-nesting-extracting-key-data/33569/1 "2020-09-30T13:42:32Z")

</div>

A url containing my API for some solar panels returns the following:

```auto
{"overview":{"lastUpdateTime":"2020-09-30 14:19:23","lifeTimeData":{"energy":1165545.0,"revenue":248.58372},"lastYearData":{"energy":1129885.0},"lastMonthData":{"energy":453504.0},"lastDayData":{"energy":4867.0},"currentPower":{"power":441.279},"measuredBy":"INVERTER"}}

```

From googling I _believe_ that it is "nested", and because of this it can't be processed by a "Magic Mirror" module. Can I use NR to clean / tidy / extract just the data that I want (for example lastDayData:4867.0), and if so how might I do this?

So far I have a TimeStamp \> http In (outputting a parsed JSON object) \> json (converting to JSON string) \> debug. But (not surprisingly) this outputs the full string.

How might I extract bits out of the string?

TIA

 ![Screenshot_2020-09-30_at_14_40_15](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/8/a8a1de7dd633fd302104fd03b59c74accee9ef89.jpeg)

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [30 September 2020 13:57 UTC](https://discourse.nodered.org/t/json-nesting-extracting-key-data/33569/2 "2020-09-30T13:57:11Z")

</div>

example using change node

```auto
[{"id":"91be1257.55f2","type":"inject","z":"4484ee28.caa3c","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"overview\":{\"lastUpdateTime\":\"2020-09-30 14:19:23\",\"lifeTimeData\":{\"energy\":1165545.0,\"revenue\":248.58372},\"lastYearData\":{\"energy\":1129885.0},\"lastMonthData\":{\"energy\":453504.0},\"lastDayData\":{\"energy\":4867.0},\"currentPower\":{\"power\":441.279},\"measuredBy\":\"INVERTER\"}}","payloadType":"json","x":150,"y":400,"wires":[["bce2a43b.35904"]]},{"id":"bce2a43b.35904","type":"change","z":"4484ee28.caa3c","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload.overview.lastDayData","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":350,"y":400,"wires":[["269a25ff.79887a"]]},{"id":"269a25ff.79887a","type":"debug","z":"4484ee28.caa3c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":640,"y":340,"wires":[]}]

```

---

<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:** [30 September 2020 14:33 UTC](https://discourse.nodered.org/t/json-nesting-extracting-key-data/33569/3 "2020-09-30T14:33:06Z")

</div>

> [@haskle](#):
>
> How might I extract bits out of the string?

Delete the JSON node and follow this...

[https://nodered.org/docs/user-guide/messages](https://nodered.org/docs/user-guide/messages)

---

<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:** [29 November 2020 14:33 UTC](https://discourse.nodered.org/t/json-nesting-extracting-key-data/33569/4 "2020-11-29T14:33:07Z")

</div>

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