The File Utils JavaScript library

JavaScript methods for parsing and uploading files.

Version: Cloud and 3.200 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

---

---