Advanced file commands

Choose a file with readable contents

Read CSV and ZIP commands need the file's contents. Use an uploaded file input, a file returned by another command, or Get File with Include bytes enabled for a stored file. A path or ordinary file listing alone does not contain the contents to read.

Read CSV

Choose file. Leave delimiter as a comma for ordinary CSV, or choose a semicolon, tab or pipe. has_header is true by default: the first row supplies the column names.

The result contains:

• headers: the column names, or an empty list when has_header is false.

• rows: a list of objects when headers are present, or lists of cell values when they are absent.

• row_count: the number of data rows, excluding the header.

For a file containing name,quantity followed by Tea,2, the first row object has name set to Tea and quantity set to the text 2. Convert a cell to a number later when needed.

Quoted cells can contain delimiters, quotation marks or multiple lines. Files must use UTF-8 text, have a consistent number of columns and contain unique, nonempty headers. An empty file returns empty headers and rows with a count of zero.

Create CSV

Choose rows, a list of objects such as products or orders. Optionally provide columns, a list of field names in the order you want. Without columns, object rows use the first object's fields. Nested objects and lists are not supported as cells; use a list transformation to select simple values first.

Leave include_header enabled to write the column names and choose the delimiter you need. The command returns CSV text. Pass that text to Upload file, choose a filename ending in .csv and set its content type to text/csv to store it.

safe_for_spreadsheets is enabled by default. Text that looks like a spreadsheet formula is prefixed with an apostrophe so opening the download does not execute that formula. Keep this protection enabled for customer-provided text. Disable it only when the receiving application specifically requires the original text and you have reviewed that data.

Read and Create CSV support up to 10,000 data rows and 100 columns. Read CSV accepts files up to 1 MiB. Generated results are also bounded; large exports should be split into smaller files.

Create ZIP

Choose files, a list of objects. Each object has:

• name: the filename inside the archive, for example reports/orders.csv.

• file: a file value with readable contents.

The result is a file value for archive.zip. Save it using Upload file if you want to keep it, or use it in later file commands. Creating the archive does not save it automatically.

Include between 1 and 100 files, using distinct names. Folder paths inside the ZIP may organize the entries, but cannot point outside the archive. Names that differ only by letter case count as duplicates.

List ZIP entries

Choose file to inspect an archive without extracting files. The result lists each entry's name, size, compressed_size and is_directory.

Use this to display the available files or find the entry you want before reading it.

Read ZIP entry

Choose the archive file and the exact entry name from List ZIP entries, such as reports/orders.csv. The result is a file value containing that entry's contents. Pass it to Read CSV or Read Text File, or save it with Upload file.

These commands inspect or read entries without extracting an archive into folders. They reject unsafe paths, links, encrypted archives, ZIP64 archives and unsupported archive formats. Both the archive and its total expanded contents are limited to 1 MiB, with up to 100 entries. Very highly compressed archives may also be rejected. Split larger archives into smaller files.

Download link

Choose path, the path of an existing file in the current workspace. Set ttl_seconds to the number of seconds the link should remain valid: from 1 to 900 seconds. The default is 300 seconds, or five minutes.

The result is a temporary download address. Return it only after checking that the requesting customer may download that file. Anyone holding the address can use it until it expires, so keep it out of shared logs and messages.

This does not change a file's saved permissions. A file already accessible through a public address remains public; adding a temporary link does not make that public address private. Use private file permissions for files that require controlled access.

Useful checks

Test with a small sample before exporting customer data. Check the file's contents, filename and permissions. If Read CSV reports a column mismatch, inspect quoted cells and the selected delimiter. If a ZIP entry is not found, copy its exact name from List ZIP entries.

These additions run in server workflows. They do not change stored files or existing database records unless a later command explicitly saves something.