# Extracting data from a TTN payload for insertion into MariadB

**URL:** https://discourse.nodered.org/t/extracting-data-from-a-ttn-payload-for-insertion-into-mariadb/51381
**Category:** General
**Created:** [22 September 2021 11:15 UTC](https://discourse.nodered.org/t/extracting-data-from-a-ttn-payload-for-insertion-into-mariadb/51381 "2021-09-22T11:15:27Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![moonlight](https://avatars.discourse-cdn.com/v4/letter/m/97f17d/32.png) [@moonlight](https://discourse.nodered.org/u/moonlight)
#### Post date: [23 September 2021 08:27 UTC](https://discourse.nodered.org/t/extracting-data-from-a-ttn-payload-for-insertion-into-mariadb/51381/8 "2021-09-23T08:27:24Z")

</div>

Looks good.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/0/202d426e212ce490a43e611646f6349184a54b86.png)

Now the copied path is: payload.uplink\_message.decoded\_payload.messages[0].measurementValue

Don't know where the [0] came from but will see if it works.

You beauty it works. Thanks guys. Here is my decode for completeness.

`msg.baro = msg.payload.uplink_message.decoded_payload.messages[0].measurementValue; msg.topic = "INSERT INTO TTNsensors(barometrics) VALUES('"+msg.baro + "');" return msg;`

---

_[View the full topic](https://discourse.nodered.org/t/extracting-data-from-a-ttn-payload-for-insertion-into-mariadb/51381)._