# MySQL to Telegram

**URL:** <https://discourse.nodered.org/t/mysql-to-telegram/25913>\
**Category:** General\
**Created:** [2 May 2020 09:05 UTC](https://discourse.nodered.org/t/mysql-to-telegram/25913 "2020-05-02T09:05:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hunter](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hunter/32/60045_2.png) [@Hunter](https://discourse.nodered.org/u/Hunter)\
**Post date:** [2 May 2020 09:05 UTC](https://discourse.nodered.org/t/mysql-to-telegram/25913/1 "2020-05-02T09:05:28Z")

</div>

Hi all,

I'm using the node-red-node-mysql to fetch data from a database.  
This part is working.

I'm getting this data :

msg.payload : array[1]  
array[1]  
0: object  
zoektekst: "Schoorveld Maasbree 233291"

Now I would like to pass this `zoektekst´ data to Telegram, what is the best way? I'm either getting "message.payload.content is empty" or an object is returned in stead of a string.

Kind regards,

Peter Hunt

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [2 May 2020 09:13 UTC](https://discourse.nodered.org/t/mysql-to-telegram/25913/2 "2020-05-02T09:13:26Z")

</div>

Hi,

first check out - [https://nodered.org/docs/user-guide/messages](https://nodered.org/docs/user-guide/messages)  
hopefully then you will be able to find what you need.  
The hint is that the payload is an array so you need one more level to find the path to what you want.

---

<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:** [1 July 2020 09:13 UTC](https://discourse.nodered.org/t/mysql-to-telegram/25913/3 "2020-07-01T09:13:27Z")

</div>

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