# Send data to Microsoft Azure

**URL:** <https://discourse.nodered.org/t/send-data-to-microsoft-azure/10763>\
**Category:** General\
**Created:** [3 May 2019 06:28 UTC](https://discourse.nodered.org/t/send-data-to-microsoft-azure/10763 "2019-05-03T06:28:53Z")\
**Posts on this page:** 1\
**Showing post:** 13

<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:** [3 May 2019 10:28 UTC](https://discourse.nodered.org/t/send-data-to-microsoft-azure/10763/13 "2019-05-03T10:28:00Z")

</div>

> [@ukmoose](#):
>
> msg.payload={ "action": "I", "query": "insert into table (Name, LastName, Age) VALUES ('Jane', 'Doe', '25')" };

So the debug you added gives a number? And I'm guessing you are trying to insert one value and a timestamp to the database?

so most of teh example is a copy and paste

`msg.payload={ "action": "I", "query": "insert into table `\<--- you want to insert  
`(Name, LastName, Age) ` \<-- the column names  
`VALUES ('Jane', 'Doe', '25')" };` \<-- the values

But as in your case the value is coming from the message you will need to reference msg.payload. see this thread [Need Help to Insert, Update and Delete Data from Node-RED Dashboard Inputs to the Database - #34 by tarihoran20](https://discourse.nodered.org/t/need-help-to-insert-update-and-delete-data-from-node-red-dashboard-inputs-to-the-database/1545/34)

---

_[View the full topic](https://discourse.nodered.org/t/send-data-to-microsoft-azure/10763)._