CSV component

Overview

The CSV component can read the CSV file from a remote URL or from the message attachment. This component can also write a CSV file from the incoming events.

Requirements

Environment variables

Name Mandatory Description Values

EIO_REQUIRED_RAM_MB

false

Value of memory allocated to component

Recommended: 512

REQUEST_TIMEOUT

false

HTTP request timeout in milliseconds

Default value: 10000

REQUEST_RETRY_DELAY

false

Delay between retry attempts in milliseconds

Default value: 7000

REQUEST_MAX_RETRY

false

Number of HTTP request retry attempts

Default value: 7

REQUEST_MAX_CONTENT_LENGTH

false

Maximum size of HTTP request in bytes

Default value: 10485760

TIMEOUT_BETWEEN_EVENTS

false

Number of milliseconds that the write action waits before creating separate attachments

Default value: 10000

LOG_LEVEL

false

Level of logger verbosity

trace, debug, info, warning, error Default: info

Credentials

The component does not require credentials to function.

Triggers

  1. Read CSV file from URL
    This trigger will fetch the CSV file from a given URL.

Actions

  1. Read CSV attachment
    Read a CSV attachment of an incoming message.

  2. Write CSV attachment
    Multiple incoming events can be combined into one CSV file with the write CSV action.

  3. Write CSV attachment from JSON Object
    Multiple incoming events can be combined into one CSV file with the write CSV action.

  4. Write CSV attachment from JSON Array
    Incoming array can be converted into one CSV file with the write CSV action.

Limitations

  1. If you receive a Component run out of memory and terminated error during run-time, then this component requires more memory. If so, add the EIO_REQUIRED_RAM_MB environment variable with an appropriate value. E.g. Specifying 512 allocate 512 MB to this component.

  2. If you receive an Error: write after end error. If so, try working around this issue by increasing the value of the environment variable: TIMEOUT_BETWEEN_EVENTS.

  3. The maximum supported attachment size is 10 MB.