csvStringToJSON

The csvStringToJson task converts a CSV string to JSON format.

Given an input table like this:

The CSV should be structured like this (using semicolons as the field delimiter):

first_name;last_name;postalcode;enrolled
Jane;Smith;12345;true
John;Walker;;false

When a semicolon is matched, a new JSON entry is created. The resulting JSON is:

1
[
2
  {
3
    "first_name": "Jane",
4
    "last_name": "Smith",
5
    "postalcode": "12345",
6
    "enrolled": "true"
7
  },
8
  {
9
    "first_name": "John",
10
    "last_name": "Walker",
11
    "postalcode": "",
12
    "enrolled": "false"
13
  }
14
]

Properties

How to configure

Upload a CSV file with the input variables for the workflow. Set the input reference variable to the contents of the CSV file with a static variable source. Set headersIncluded to true.

The response returned by this task contains the comma-separated values converted to JSON format. You can view the outgoing properties in Operations Manager when the task is complete.

Potential use case

If you are building a workflow and need to convert inputs to JSON format, upload a CSV file with the input variables instead of filling in a JSON form. After the csvStringToJson task converts the values to JSON, the variables can be queried from the output and used in further tasks.

Related reading

• csvStringToJSON API
• excelToJson API