Utilities

  • Updated on Jun 1, 2022
  • Published on May 31, 2022
  • 1 minute(s) read
Prev Next

The Utilities blocks are used to sort tables, download and generate files, parse CSV files, and add comments. 

Utilities thumbnail

Utility Blocks DescriptionUtility Blocks on Canvas

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.

Utilities-sort


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.
Utilities-download

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).
This block can be added only for the on-cloud lane.
Utilities-generate

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.
Note
Accepts any delimiter; Commas are default delimiters in CSV.
  • Select yes/no to Include header information.
  • An output variable of type table is given in to.
Utilities-parsecsv

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. 


Utilities-comment