CSV Decode Node#

The CSV Decode Node allows a workflow to decode a CSV string on the payload into an object array.

CSV Decode Node

Configuration#

There are three main parts to the configuration of this node...

Input Path#

This required field specifies the payload path where the CSV string to be decoded is located.

CSV Decode Node Input

Format Configuration#

CSV Decode Node Config

This section contains four fields that specify the format of the incoming CSV string:

  • Record Delimiter: (Optional) This is the character used to separate rows of data. Default \n.

  • Delimiter: (Optional) A string template to override the delimiter. This character is used to separate columns of data. Must be a single character. Leave blank to default to comma (,).

  • Quote: (Optional) A string template to override the quote character. Must be a single character. Leave blank to default to double-quote (").

  • Escape: (Optional) A string template to override the escape character. Must be a single character. Leave blank to default to double-quote (").

Result Path#

This required field specifies the payload path where the decoded object array will be placed.

CSV Decode Node Result

Output#

In this particular instance, the workflow will decode the CSV string at the data.csvString path and place the resulting array of objects at data.out.

So, for the following input payload...

{
...
  "data": {
    "csvString": "Food,Drink\nBurger,Soda\nTaco,Water\n"
  }
...
}

The CSV Decode Node would give the following output payload.

{
...
  "data": {
   "csvString": "Food,Drink\nBurger,Soda\nTaco,Water\n",
   "out": [
    {
     "Drink": "Soda",
     "Food": "Burger"
    },
    {
     "Drink": "Water",
     "Food": "Taco"
    }
   ]
  }
...
}