# SQL Insert query from MQTT

**URL:** <https://discourse.nodered.org/t/sql-insert-query-from-mqtt/49943>\
**Category:** General\
**Created:** [20 August 2021 06:56 UTC](https://discourse.nodered.org/t/sql-insert-query-from-mqtt/49943 "2021-08-20T06:56:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![KartikI](https://avatars.discourse-cdn.com/v4/letter/k/b5ac83/32.png) [@KartikI](https://discourse.nodered.org/u/KartikI)\
**Post date:** [20 August 2021 06:56 UTC](https://discourse.nodered.org/t/sql-insert-query-from-mqtt/49943/1 "2021-08-20T06:56:34Z")

</div>

Hello All,

This is Kartik I am trying to fetch all tag data received in array from Ignition Edge but currently I am able to fetch a single array data but I need the array data as per my array length so anyone please help me figuring this out...

Code  
var array = msg.payload;  
pid = "INSERT INTO [MQTT\_IOT].[dbo].[Data] "  
pid = pid + "(Timestamp, Name, Datatype, Value) "  
pid = pid + " VALUES ('" + array[0].timestamp + "','" + array[0].name + "','" + array[0].datatype +"','"+array[0].doubleValue+"')"  
msg.payload = pid  
return msg;

Thanks,  
Kartik I

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

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [20 August 2021 07:00 UTC](https://discourse.nodered.org/t/sql-insert-query-from-mqtt/49943/2 "2021-08-20T07:00:07Z")

</div>

Use a split node to convert the array into single payloads.

PS I recommend you use MSSQL-PLUS and use the UI to add parameters (avoids SQL injection) and removes the need to create a query in a function node

> **[node-red-contrib-mssql-plus](https://flows.nodered.org/node/node-red-contrib-mssql-plus)**
>
> A node-red node to execute queries, stored procedures and bulk inserts in Microsoft SQL Server and Azure Databases SQL2000 ~ SQL2019

---

<div class="post-metadata">

**Author:** ![KartikI](https://avatars.discourse-cdn.com/v4/letter/k/b5ac83/32.png) [@KartikI](https://discourse.nodered.org/u/KartikI)\
**Post date:** [20 August 2021 07:11 UTC](https://discourse.nodered.org/t/sql-insert-query-from-mqtt/49943/3 "2021-08-20T07:11:54Z")

</div>

Thanks Steve...

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [20 August 2021 08:35 UTC](https://discourse.nodered.org/t/sql-insert-query-from-mqtt/49943/4 "2021-08-20T08:35:12Z")

</div>

Also, that isert query is not safe. Use a prepared statement and make sure that you cleanse the input variables.

---

<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:** [19 October 2021 08:35 UTC](https://discourse.nodered.org/t/sql-insert-query-from-mqtt/49943/5 "2021-10-19T08:35:59Z")

</div>

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