Convert to CSV
| Input | Output |
|---|---|
|
|
Summary
Takes an array of objects (a tabular dataset) and converts it into a CSV file.
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 you’ve set the “Output Property” name 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
|
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:
|
|
Output Property |
Text |
No |
Specify the name of the property to store the CSV data in. |