# Send or retrieve data from Microsoft Azure

**URL:** <https://discourse.nodered.org/t/send-or-retrieve-data-from-microsoft-azure/12684>\
**Category:** General\
**Created:** [28 June 2019 10:44 UTC](https://discourse.nodered.org/t/send-or-retrieve-data-from-microsoft-azure/12684 "2019-06-28T10:44:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jason\_tien](https://avatars.discourse-cdn.com/v4/letter/j/ee59a6/32.png) [@jason\_tien](https://discourse.nodered.org/u/jason_tien)\
**Post date:** [28 June 2019 10:44 UTC](https://discourse.nodered.org/t/send-or-retrieve-data-from-microsoft-azure/12684/1 "2019-06-28T10:44:47Z")

</div>

Hi everyone, I would like to ask how to read and write the query from Microsoft Azure.

Previous I using MSSQL to store the data so example my query like following picture.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/c/cf03cf0918093abe590a98b4f1e5c3bdc0240045.png)  
I insert the data to MSSQL, but now I want insert the data to Microsoft Azure. How?

This is I founded on online [https://www.npmjs.com/package/node-red-contrib-azure-sql](https://www.npmjs.com/package/node-red-contrib-azure-sql) but the data is fix.

How to replace this 3 values?

 ![image.png](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/6/652b796e859ab9f34931b22c80a7d5a14f58f622.png)

If I reply late, please apologizes.  
Thanks.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [28 June 2019 11:10 UTC](https://discourse.nodered.org/t/send-or-retrieve-data-from-microsoft-azure/12684/2 "2019-06-28T11:10:08Z")

</div>

msg.payload contains a string, to concatenate strings in javascript see this page [http://2ality.com/2011/10/string-concatenation.html](http://2ality.com/2011/10/string-concatenation.html)