Skip to main content

The File Utils JavaScript library

JavaScript methods for parsing and uploading files.

Version: Cloud and 3.188 Edge

The fileUtils JavaScript library includes methods to parse CSV, JSON, and XLSX files.

These methods are not available within transformers.

JavaScript API methods for this object. You can write JavaScript almost anywhere in Retool and use methods to manipulate data and property values.

fileUtils.parseCSV​

Parses a CSV file. Returns a Promise that resolves to a list of objects with one key per column.

Definition
await fileUtils.parseCSV(data)
Parameters

data​

The data.

Type string | number | boolean | object | array
Format Custom data
Returns

Returns a Promise that resolves to the following:

parsedData​

The parsed data.

Type array
Array values string

fileUtils.parseJSON​

Parses a JSON file. Returns a Promise that resolves to a list of objects with one key per column.

Definition
await fileUtils.parseJSON(data)
Parameters

data​

The data.

Type string | number | boolean | object | array
Format Custom data
Returns

Returns a Promise that resolves to the following:

parsedData​

The parsed data.

Type array
Array values string

fileUtils.parseXLSX​

Parses an XLSX file. Returns a Promise that resolves to a list of objects with one key per column.

Definition
await fileUtils.parseXLSX(data)
Parameters

data​

The data.

Type string | number | boolean | object | array
Format Custom data
Returns

Returns a Promise that resolves to the following:

parsedData​

The parsed data.

Type array
Array values string