CSV to JSON

Description

This operation converts a CSV file to JSON format.

---

Data types

These are the input/output expected data types for this operation:

Input data

- CSV-formatted strings you want to transform into JSON.

Output data

- Resulting JSON-formatted strings.

---

Parameters

These are the parameters you need to configure to use this operation (mandatory parameters are marked with a *):

Cell delimiter*

This setting defines the character used to separate cells (or columns) in each row.

Row delimiter

This setting defines the character used to separate rows, if any.

Format*

Format of the resulting JSON. Choose between:

• Array of dictionaries - Each row in the CSV is converted into an object (similar to a dictionary) with key-value pairs where the keys are column headers.

• Array of arrays - Each row in the CSV is converted into a JSON array, with values only and no keys (useful if you don’t need named fields).

---

Example

Suppose you want to convert a series of events in CSV format into JSON:

1. In your Pipeline, open the required Action configuration and select the input Field.

2. In the Operation field, choose CSV to JSON.

3. Set Cell delimiter to , (comma).

4. Leave the Row delimiter field empty.

5. Set Format to Array of dictionaries.

6. Give your Output field a name and click Save. The CSV strings in your input field will be transformed into JSON.

For example, the following CSV:

First name,Last name,Age,City
John,Wick,20,New-York
Tony,Stark,30,Madrid

will be transformed into this JSON:

[
  {
    "First name": "John",
    "Last name": "Wick",
    "Age": "20",
    "City": "New-York"
  },
  {
    "First name": "Tony",
    "Last name": "Stark",
    "Age": "30",
    "City": "Madrid"
  }
]

You can try out operations with specific values using the Input field above the operation. You can enter the value in the example above and check the result in the Output field.