File Target

File Target is a component that writes data to a file. It can produce CSV, JSON, Avro, and Parquet files, which you can download manually or place on a file storage service automatically.

Target Type

Under Target Type, select the format of the result file:

• CSV — a plain-text format that stores tabular data as delimited values.
• JSON — a text format for structured, nested data.
• Avro — a compact, row-based binary format.
• Parquet — a column-oriented binary format.

File Destination

Skyvia can deliver the result file in two ways:

• Select Download manually to download the file yourself once the integration runs.
• Select To storage service to upload the file to a storage service automatically. Choose a file storage Connection, then pick the Folder to save it in.

File Name

Configure the result file name with the File Name Type setting:

• Regular — enter a constant value in the File Name box.
• Expression — build the File Name with the Expression Editor to make the name unique each time, for example, by adding a date/time. You can use integration variables and parameters in the expression.

CSV Options

When Target Type is CSV, the following options are available:

• Code Page — sets the encoding of the result file. Click more options to also specify the CSV file options: CSV Separator, Text Qualifier, Row Delimiter, and Locale.
• Include header — determines whether the file is produced with a header row of column names.
• CSV Columns — let File Target determine the result columns automatically (Auto generate), or define them yourself (Explicit columns). For explicit columns, click Edit, then enter the column names in the dialog box, each on a new line. You then map the action parameters that correspond to the specified columns.
• Create Empty Files — determines whether a file is still created when there are no input records.

JSON Options

When Target Type is JSON, the component saves the output data to a JSON file, and you always receive an array as a result. The following options are available:

• Code Page — sets the encoding of the result file.
• Locale — determines how date/time, number, and similar values are formatted.
• CamelCase — when selected, writes the JSON property names in camelCase.
• Formatting — when selected, indents the JSON output instead of writing it on a single line.
• JSON Properties — let File Target determine the properties automatically (Auto generate), or define them yourself by choosing Explicit and modifying the output schema. For nested structures, see Working with Nested Types.

Avro and Parquet Options

When Target Type is Avro or Parquet, the following options are available:

• Locale — determines how date/time, number, and similar values are formatted.
• Create Empty Files — determines whether a file is still created when there are no input records.