File upload

File Upload Component

Basics

The File upload helps you to able users to upload binary and text Files and process this data further in Lowcoder to send it to local or remote Storage and other Backends.

File type

You can input an array of strings to restrict the types of the files to be uploaded. The default value of file type is empty, meaning that no limitation is pre-defined. Each string value in a specified file type array should be a unique file type specifier in one of the following formats.

• A valid case-insensitive filename extension, starting with a period character ("."), such as .png, .txt, and .pdf.

• A valid string in MIME format without an extension.

• String audio/* indicating "any audio file".

• String video/* indicating "any video file".

• String image/* indicating "any image file".

For example, when the value of file type is [".pdf", ".mp4", "image/*"], you can upload PDF files, MP4 files, and any type of image files.

Upload type

You can decide whether to upload a single file, multiple files, or a directory.

Configure the File Upload to accept individual, multiple Files or whole Folders

Display uploaded files

Switch on or off Show upload list to display or hide the list of the uploaded files. You can also set this property via JS code. By default, its value is "true".

The upload list presents the file names of all uploaded files in chronological order. You can also access the name of the uploaded files via the property files[index].name. When hovering your mouse over a file, the 🗑️ icon appears and you can click it to delete the corresponding file.

Parse files

Toggle Parse files and Lowcoder will try to parse the uploaded file data structure into objects, arrays, or strings. This does not work with binary data but with structured text data like Excel, JSON, and CSV files. Excel files are only parseable if there is no formula/s applied on these.

Lowcoder can try to parse the content of the files so you can directly access it.

You can access the parsed result via the property parsedValue.

For each uploaded file Lowcoder will try to parse and you can access the data of the files then in the array.

// access the structured content of an uploaded File in Lowcoder Apps
file1.parsedValue[0]
// the array contains the data for each uploaded file.
file1.parsedValue[0], file1.parsedValue[1], file1.parsedValue[2]

You can access the contents of Excel, CSV and JSON Files as JSON Data object after upload and parse

Validation

Under the validation tab, you can configure how many files are allowed to be uploaded, as well as the minimum and maximum size of a single file to be uploaded.

You can define the minimal and maximal size of files that can get uploaded

Max files

When the upload type is "Multiple" or "Directory", you can set Max files to limit the maximum number of files to upload. If the number of files to be uploaded exceeds this threshold, the latest uploaded files will replace the oldest ones.

If multiple files can get uploaded, you can define the maximal amount of files

File size

You can set the minimum and maximum size of the files to upload, using KB, MB, GB, or TB units. The default unit for file size is byte. When the size of the uploaded file exceeds the limit, you will see a global alert.

Access uploaded files

Files uploaded via the file upload component are stored in browser cache memory in base64-encoded string format. To store these files in data sources, you need to build queries to connect to databases or APIs. You can view the properties of the uploaded files in the data browser in the left pane, or access property names in {{}} or JS queries via JS code. Commonly used properties are as follows.

• value: A list of the content of the uploaded files, encoded in base64.

// Access the File content (represented as base64)
{{file1.value[0]}} // will return "WwogIHsKICAgICJpZCI6ICJkODE5NGI3Mi1lZGNiLTRhMWMtYTRlMC1lZT...

• files: A list of metadata of the uploaded files, including uid, name, type, size, and lastModified.

// Access the File metadata information. 

{{file1.files[0].name}} // will return "open_issues.json"

{{file1.files[0].type}} // will return "application/json"

{{file1.files[0].size}} // will return "247285" (in bytes)

{{file1.files[0].lastModified}} // will return the date of last Modification

• parsedValue: A list of the value of the parsed files.

Demo ( File Upload & File Viewer )

Demo ( Inserting CSV File data into Database )