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 *):
Example
Suppose you want to convert a series of events in JSON format into CSV:
In your Pipeline, open the required Action configuration and select the input Field.
In the Operation field, choose JSON to CSV.
Set Cell delimiter to
,
(comma).Set Row delimiter to
\n
(new line)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
Last updated
Was this helpful?