# REST API Message Retriever

**URL:** https://discourse.nodered.org/t/rest-api-message-retriever/18658
**Category:** General
**Created:** [1 December 2019 15:32 UTC](https://discourse.nodered.org/t/rest-api-message-retriever/18658 "2019-12-01T15:32:37Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Noa17](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Noa17](https://discourse.nodered.org/u/Noa17)
#### Post date: [1 December 2019 15:32 UTC](https://discourse.nodered.org/t/rest-api-message-retriever/18658/1 "2019-12-01T15:32:37Z")

</div>

Hi  
i need a proper response function for this flow

Note that am using this code for the query :  
...........................................................................................................  
if(!msg.req.params.count)  
msg.req.params.count = 1;

msg.topic = "SELECT id,topic,payload,timestamp " +  
"FROM thingData " +  
"WHERE topic='" + escape(msg.req.params.topic) + "' " +  
"AND deleted=0 " +  
"ORDER BY id DESC " +  
"LIMIT " + msg.req.params.count + ";";  
return msg;  
...............................................................................................................................

 ![fzdf](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/d/d38b5ab01deb9793f208fdf9a528bbec1f8f52f2.png)