Skip to main content

The File Utils JavaScript library

JavaScript methods for parsing and uploading files.

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