# Value to Array conversion

**URL:** <https://discourse.nodered.org/t/value-to-array-conversion/38568>\
**Category:** General\
**Created:** [5 January 2021 06:56 UTC](https://discourse.nodered.org/t/value-to-array-conversion/38568 "2021-01-05T06:56:42Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![DSongra11\_forum.com](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@DSongra11\_forum.com](https://discourse.nodered.org/u/DSongra11_forum.com)\
**Post date:** [5 January 2021 06:56 UTC](https://discourse.nodered.org/t/value-to-array-conversion/38568/1 "2021-01-05T06:56:42Z")

</div>

Hello,

I want to convert msg.payload Value into an array for sql database. Attached debug message screenshot.

Thanks in advance.

Br,  
Devendra

![debug](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/d/6d68a186706269d9c424d8e8bac7ac9f42e898ab.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:** [5 January 2021 07:30 UTC](https://discourse.nodered.org/t/value-to-array-conversion/38568/2 "2021-01-05T07:30:41Z")

</div>

What type of database? (SQL server 20xx? Mysql? Sqlite?)

What node are you using? (Full name please e.g. node-red-contrib-xxxxx)

---

<div class="post-metadata">

**Author:** ![DSongra11\_forum.com](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@DSongra11\_forum.com](https://discourse.nodered.org/u/DSongra11_forum.com)\
**Post date:** [5 January 2021 08:16 UTC](https://discourse.nodered.org/t/value-to-array-conversion/38568/3 "2021-01-05T08:16:25Z")

</div>

Hi,

I am using PostgresSQL database.

Node - node-red-contrib-postgres-multi.

Br,  
Devendra

---

<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:** [5 January 2021 08:27 UTC](https://discourse.nodered.org/t/value-to-array-conversion/38568/4 "2021-01-05T08:27:14Z")

</div>

According to [the readme](https://flows.nodered.org/node/node-red-contrib-postgres-multi) you need to format the payload in a particular way.

Try adding a function node and put this code in (you will need to modify the SQL)...

```auto
msg.payload = [
    {
        query: 'insert into mytable (message) values (1, $p1)',
        params: {
            p1: msg.payload
        },
    },
];
return msg;

```

---

<div class="post-metadata">

**Author:** ![DSongra11\_forum.com](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@DSongra11\_forum.com](https://discourse.nodered.org/u/DSongra11_forum.com)\
**Post date:** [5 January 2021 12:27 UTC](https://discourse.nodered.org/t/value-to-array-conversion/38568/5 "2021-01-05T12:27:34Z")

</div>

Hello,

I tried same but not working.

Below is my Write SQL query program. which i have done in function node.  
msg.payload value is unsigned8 bit (ex. 13 or 234 etc).

var timestamp = new Date().getTime();  
var name = "Sensor1"  
var value = msg.payload;

if (flow.get("Start")===true){  
msg.payload = "INSERT INTO table1 VALUES("+timestamp+","+name+","+value+")";

return msg;  
}

Br,  
Devendra

---

<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:** [5 January 2021 12:46 UTC](https://discourse.nodered.org/t/value-to-array-conversion/38568/6 "2021-01-05T12:46:32Z")

</div>

> [@DSongra11\_forum.com](#):
>
> `msg.payload = "INSERT INTO table1 VALUES("+timestamp+","+name+","+value+")";`

↑ That is nothing like the correct format. Did you read my post or open the "readme"?

This should get you closer to a solution...

```auto
var timestamp = new Date().getTime();
var name = "Sensor1"
var value = msg.payload;
msg.payload = [ 
  { query:`INSERT INTO table1 VALUES(${timestamp},'${name}',${value})` } 
];
return msg;

```

---

<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:** [6 March 2021 12:46 UTC](https://discourse.nodered.org/t/value-to-array-conversion/38568/7 "2021-03-06T12:46:41Z")

</div>

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