Skip to main content

CSV

This section provides a description how functions to connect to a CSV in the WEB. Before you can create a function, make sure, that you have already created a system within a system line.

Connect to a CSV File​

In order to connect to a CSV File on the WEB, create a Function. It can be done in the Portal in the menu "Virtual Datasets". Since we already provide an example in the get started guide, we refer to the documentation here (todo fix link) (getStartedCreateFirstFunction), for screenshots and further details.

note

In case the CSV contains special characters, like the German "ä", "ü" or "ö", please make sure that the CSV-File is UTF-8 enabled.

Technical Parameters​

  • *COLUMN_DELIMITER: Column delimiter, e. g. comma (,) or semicolon (;) Use a single space ' ' for tabulator separation.
  • COLUMN_INDEXES: The indexes of columns to be retrieved.
  • COLUMN_NAMES: The column names of the output of this
  • HEADERS: A list of key=value pairs, separated by semicolon. All these pairs will be added to the HTTP header when loading the file.
  • ROWS_TO_SKIP: Number of rows at the start of the file that should be ignored.
  • URL: The URL to load the CSV file from. Use defined function parameters in the URL by putting them in double curly brackets, e. g. {{my_param}}. This parameter is required.