Help Center

Menu

CSV triggers

Read CSV file from URL

This trigger reads the CSV file from the URL in the configuration fields and outputs the result as a JSON object. The trigger works the same as the Read CSV attachment action, except that the settings should be provided in the configuration fields, not in the body message, as the triggers do not have input messages.

Configuration

Emit behavior

A required drop-down. This selector configures the output behaviour of the component.

Fetch all

The component emits an array of messages.

Emit individually

The component emits a message per row.

Emit batch

Component will produce a series of messages where each message has an array of max length equal to the Batch Size.

Skip empty lines

An optional checkbox. By default, empty lines are parsed. If this is selected, they will be skipped.

Comment char

An optional string. If specified, skip lines starting with this string.

Input metadata

URL

A required string. URL of the CSV file to parse.

Contains headers

An optional boolean. If true, the first row of parsed data will be interpreted as field names. The default is false.

Delimiter

An optional string. The delimiting character. Leave blank to auto-detect from a list of most common delimiters or provide your own.

Example

|== |Delimiter ($)|JSON

|a$b$c$d a|

{
"column0": "a",
"column1": "b",
"column2": "c",
"column3": "d"
}

|==

Convert data types

An optional boolean. Numeric data and boolean data will be converted to their type instead of remaining strings, false by default.

Output metadata

For Fetch page and Emit Batch

An object with key result that has an array as its value.

For Emit Individually

Each object fills the entire message.