# Retrieve data in mysql and return this data in http repsonse

**URL:** <https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606>\
**Category:** General\
**Created:** [17 December 2020 01:44 UTC](https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606 "2020-12-17T01:44:11Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![LordLee123](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/lordlee123/32/33799_2.png) [@LordLee123](https://discourse.nodered.org/u/LordLee123)\
**Post date:** [17 December 2020 01:44 UTC](https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606/1 "2020-12-17T01:44:12Z")

</div>

Hi,  
I made a http request endpoint to retrieve data in mysql and return this data in http repsonse.  
But seems like that it doesn't work. I can get data from mysql .But No way to reply .

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/d/6d79a7883706d2d5cf2e0d3e63120f0caeaba557.png)

---

<div class="post-metadata">

**Author:** ![meeki007](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/meeki007/32/12499_2.png) [@meeki007](https://discourse.nodered.org/u/meeki007)\
**Post date:** [17 December 2020 05:29 UTC](https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606/2 "2020-12-17T05:29:11Z")

</div>

can you post the output of msg.payload ?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [17 December 2020 09:29 UTC](https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606/3 "2020-12-17T09:29:23Z")

</div>

Are you passing on the full message in the function? It is important not to lose message properties coming in from the http node (which is an http in, not an http request). Add debug nodes at each point, set to show complete message and make sure they are not being lost.

> [@LordLee123](#):
>
> No way to reply

Also, if the above suggestions don't fix it, tell us what happens when you try to reply.

---

<div class="post-metadata">

**Author:** ![LordLee123](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/lordlee123/32/33799_2.png) [@LordLee123](https://discourse.nodered.org/u/LordLee123)\
**Post date:** [18 December 2020 01:25 UTC](https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606/4 "2020-12-18T01:25:27Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/d/fd3fb86e6c9ef1c000d736f6095b37a1ddf7abfd.png)

---

<div class="post-metadata">

**Author:** ![LordLee123](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/lordlee123/32/33799_2.png) [@LordLee123](https://discourse.nodered.org/u/LordLee123)\
**Post date:** [18 December 2020 01:26 UTC](https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606/5 "2020-12-18T01:26:25Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/d/fd3fb86e6c9ef1c000d736f6095b37a1ddf7abfd.png)

This is msg.payload information.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [18 December 2020 07:09 UTC](https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606/6 "2020-12-18T07:09:07Z")

</div>

That does not in any way seem to answer the questions and suggestions I made. Please read my post again and make sure you understand each of the points I made and then provide the information asked for.

---

<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:** [16 February 2021 07:09 UTC](https://discourse.nodered.org/t/retrieve-data-in-mysql-and-return-this-data-in-http-repsonse/37606/7 "2021-02-16T07:09:30Z")

</div>

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