ApplicationExperienceEdge 1.6.0

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"
    }
   ]
  }
...
}