Utilities

Sort: 

Helps to sort the columns in either ascending or descending order for a selected table. The sort block can be added on all 3 lanes.

Download File:

The download block helps the BOS to download Files from the Drive. (Drive is accessible from the Menu options of each project). To download a file,

• Specify the Source path (Drive path) in File. 
• Select the download format from the using encoding dropdown list. 
• An output variable of type string can be given in to. It holds the file stream.

Generate File: 

• An input variable with file stream is given in File.
• Specify the with extension format for conversion.
• Select the existing format from the using encoding dropdown list. 
• An output variable is given in to that stores the destination drive path.
• An output variable is given in urI that stores the url of the file (optional field).

Parse CSV: 

This block is used to parse a CSV file to a table. 

• Specify the drive path of the CSV file in File.
• Enter the delimiter in with Delimiter field.

• Select yes/no to Include header information.
• An output variable of type table is given in to.

Comment: 

Additionally, there is also a comment block where text/pseudocode is included in the form of comments inside the Integration Builder for developer reference.