# CSV skips boolean false values

**URL:** <https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346>\
**Category:** General\
**Created:** [18 April 2021 05:30 UTC](https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346 "2021-04-18T05:30:09Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nrnoob](https://avatars.discourse-cdn.com/v4/letter/n/77aa72/32.png) [@nrnoob](https://discourse.nodered.org/u/nrnoob)\
**Post date:** [18 April 2021 05:30 UTC](https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346/1 "2021-04-18T05:30:09Z")

</div>

I am using the `CSV` node to convert a JSON object containing an array to CSV. However, when the array contains boolean values (false, true), the node's output skips the false values.  
This is my test flow `

```auto
[{"id":"d5dfd68d.60a738","type":"inject","z":"b77ebf57.35da3","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[false, true]","payloadType":"json","x":440,"y":400,"wires":[["3a96fa3c.76c796"]]},{"id":"3a96fa3c.76c796","type":"csv","z":"b77ebf57.35da3","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\r\\n","temp":"","skip":"0","strings":false,"include_empty_strings":true,"include_null_values":true,"x":630,"y":400,"wires":[["bdf2fef6.2c008"]]},{"id":"bdf2fef6.2c008","type":"debug","z":"b77ebf57.35da3","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":810,"y":400,"wires":[]}]

```

I just get `,true` as the output when I expect it to be `false,true`  
What an I doing wrong? I tried to toggle the node formatting options (empty strings, null values), but it does not make a difference.

---

<div class="post-metadata">

**Author:** ![nrnoob](https://avatars.discourse-cdn.com/v4/letter/n/77aa72/32.png) [@nrnoob](https://discourse.nodered.org/u/nrnoob)\
**Post date:** [18 April 2021 06:07 UTC](https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346/2 "2021-04-18T06:07:13Z")

</div>

As a workaround, I converted the bool array to a string one using a function (`.toString().split(",")`).  
The CSV output looks ok now, but the CSV node should handle boolean array values natively.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [18 April 2021 06:44 UTC](https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346/3 "2021-04-18T06:44:31Z")

</div>

Hi, can you please raise it as an issue on github along with your example so we can track the fix. Thanks

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [19 April 2021 09:05 UTC](https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346/4 "2021-04-19T09:05:51Z")

</div>

Now fixed in master

---

<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:** [18 June 2021 09:06 UTC](https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346/5 "2021-06-18T09:06:23Z")

</div>

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