Frends.CSV.Create / 1.13.0
Summary
Builds CSV text from JSON, XML or rows already in the Process, with control over the delimiter and over whether columns come from the data or from a list you give.
Typical use — producing a file for a system that reads delimited data, where naming the columns explicitly keeps the output stable as the source shape drifts
Input parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| InputType | CreateInputType |
List |
CreateInputType.List |
Select input type to show correct editor for input Possible values:
|
| Delimiter | String |
";" |
; |
Delimiter. |
| Json | String |
– | [{\"Column1\": \"row1Val1\",\"Column2\": \"row1Val2\"},{\"Column1\": \"row2Val1\",\"Column2\": \"row2Val2\"}] |
Json string to write to CSV. Must be an array of objects. |
| SpecifyColumnsManually | Boolean |
false |
false |
If set true, allows the user to manually specify an array of columns which to generate. |
| Columns | List<String> |
– | { "Column1", "Column2", "Column3" } |
Custom columns for the data. |
| Xml | String |
– |
<?xml version="1.0" encoding="utf-8"?>
<Root>
<Row>
<Name>Veijo</Name>
<Street>FrendsStr</Street>
<StartDate>2018-05-27T00:00:00</StartDate>
</Row>
<Row>
<Name>Hodor</Name>
<Street>HodorsStr</Street>
<StartDate>2018-01-01T00:00:00</StartDate>
</Row>
</Root>
|
Xml string to write to CSV. |
| XmlNodeElementName | String |
– | book |
Name of the node from which the data is to be queried. |
| Headers | List<String> |
– | { Values, Foos, Bars, Dates } |
Headers for the data. Need to be in the same order as the underlying data |
| Data | List<List`1> |
– | { 1, "foo", "bar", 2023-02-08 } |
Data to write to the CSV string. Needs to be of type List<List |