This activity converts a data table to a Comma Separated Values (CSV) string.
The Run SQL Query activity could be used to run a database query and produce a data table. The data table could then be passed to the Convert Data Table To CSV activity to produce the CSV text representing a .csv file. Then use the Create Download activity to generate a URL that allows an end user to download the CSV text as a file, or use the Write File activity to save the CSV text to a file on the server.
Data Table |
Required Type: DataTable The data table to convert. |
Delimiter |
Optional Type: String The delimiter used to separate fields. The default is ",". |
result |
Type: String The result Comma Separated Values (CSV) string. |
For information about the ID, Display Name, and Description properties, see Properties Common to all Activities.
This activity does not work when the device has intermittent connectivity to the network.