Data sources

CSV

This article explains how to handle the data source for data in CSV format. The exact specification and further information about CSV can be found here.

A nice example of CSV data can be found under this URL: http://mysafeinfo.com/api/data?list=presidents&format=csv It lists all American presidents. In addition to the connection via URL, CSV files can also be integrated, like Excel files, as a File or NetworkShareFile.

The handling of the dialog is almost self-explanatory. Write the desired URL in the corresponding text field. If explicit authentication is required, this can be set with the corresponding attribute. As well as the maximum number of records and the reload interval. To load the columns of the data source, click Load. Once the metadata is loaded, the data source is available for further processing like any other source.

CSV Add Data Dialog