JSON to CSV

Description

This operation converts JSON data into a CSV file.

---

Data types

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

Input data

- JSON data you want to transform into CSV. They must be strings formatted as JSON data.

Output data

- Resulting CSV files.

---

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 the resulting CSV

Row delimiter*

This setting defines the character used to separate rows in the resulting CSV.

---

Example

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

1. In your Pipeline, open the required Action configuration and select the input Field.
2. In the Operation field, choose JSON to CSV.

3. Set Cell delimiter to , (comma).

4. Set Row delimiter to \n (new line)

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

For example, the following JSON:

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

will be transformed into this CSV:

First name,Last name,Age,City       
John,Wick,20,New-York
Tony,Stark,30,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.