Convert to CSV
Takes an array of objects (a tabular dataset) and converts it into a CSV file.
| Input | Output |
|---|---|
|
|
For example, given the following dataset:
[
{
"Make": "Toyota",
"Model": "Camry",
"Year": 2020,
"Price": 24000
},
{
"Make": "Honda",
"Model": "Civic",
"Year": 2019,
"Price": 22000
},
{
"Make": "Ford",
"Model": "Mustang",
"Year": 2021,
"Price": 27000
}
]
The following CSV dataset will be generated:
"Make","Model","Year","Price"
"Toyota","Camry","2020","24000"
"Honda","Civic","2019","22000"
"Ford","Mustang","2021","27000"
Input object
{
"myData": [
{
"Make": "Toyota",
"Model": "Camry",
"Year": 2020,
"Price": 24000
},
{
"Make": "Honda",
"Model": "Civic",
"Year": 2019,
"Price": 22000
},
{
"Make": "Ford",
"Model": "Mustang",
"Year": 2021,
"Price": 27000
}
]
}
Output object
Assumes that the “Output Property” name has been changed to “myCsvData”.
{
"myData": [
{
"Make": "Toyota",
"Model": "Camry",
"Year": 2020,
"Price": 24000
},
{
"Make": "Honda",
"Model": "Civic",
"Year": 2019,
"Price": 22000
},
{
"Make": "Ford",
"Model": "Mustang",
"Year": 2021,
"Price": 27000
}
],
"myCsvData": ""Make","Model","Year","Price"\n"Toyota","Camry","2020","24000"\n"Honda","Civic","2019","22000"\n"Ford","Mustang","2021","27000""}
Properties
The following properties relateto converting to CSV:
| Name | Type | Templatable | Notes |
|---|---|---|---|
| Field Delimiter | Choice:
| No | Select the field delimiter character. For CSV files, this is usually a comma. |
| Custom Delimiter | Text | No | Only visible if Field Delimiter is "Other". Enter one or more characters to use as the field delimiter. |
| Line Delimiter | Choice
| No | Choose whether you want Windows (CRLF) or Unix (LF) style line endings. |
| Input Array | Text | Yes | Enter an expression pointing to an array of objects to use as the input for the CSV data. Use the "array" function to cast the data as an array. Example: {{ input.myData | array }} |
| Output Property | Text | No | Specify the name of the property to store the CSV data in. |
Updated 20 days ago