Knowledge Base

The Download as File block is used to download output data as a file in CSV, Excel, or Text format. To enable download option for an external user, you need a Spreadsheet Filter block, Clear Output block, Custom Output block, and Download as File block in the workflow you build.

1. Filter the data you want to download using the Spreadsheet Filter block.

2. Pass the output of the Spreadsheet Filter block to a Clear Output block to clean data and clear any JSON data mess-up in the filter block output.

3. Pass the output of the Clear Output block to the Custom Output block to convert filter output data to JSON format. Specify the filter block name in the field “Output Data” within double curly braces as shown in the screenshot.

4. Pass the output of the Custom Output Block to the Download as File block. In this block:

• Enter a suitable name to the function block in the field Label.
• Add a description to the function block, if any.
• Choose the Action as
  • Download to Client to enable download for an external user and
  • Save to Remote to download and save the file to Vizru storage
• Choose File Type as CSV, Excel, or Text.
• Choose the character set as utf-8, ansi, or us-ascii.
• Give a name to the file you want to download in the field File Name.
• Define the required column names in the field Header Column. Note: If you do not define any column names, entire JSON output gets downloaded. If you define specific fields, then only the defined data will be available in the downloaded file.
• Specify the Custom Output block name in the field Json Data within curly braces, as shown in the screenshot.