CSVRecordLookupService

Description:

A reloadable CSV file-based lookup service. When the lookup key is found in the CSV file, the columns are returned as a Record. All returned fields will be strings.

Tags:

lookup, cache, enrich, join, csv, reloadable, key, value, record

Properties:

In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values, and whether a property supports the NiFi Expression Language.

NameDefault ValueAllowable ValuesDescription
CSV FileA CSV file that will serve as the data source.
Supports Expression Language: true (will be evaluated using variable registry only)
CSV FormatDefault
  • Excel
  • MySQL
  • TDF
  • PostgreSQLCsv
  • InformixUnloadCsv
  • Default
  • RFC4180
  • InformixUnload
  • PostgreSQLText
Specifies which "format" the CSV data is in.
Character SetUTF-8The Character Encoding that is used to decode the CSV file.
Supports Expression Language: true (will be evaluated using variable registry only)
Lookup Key ColumnThe field in the CSV file that will serve as the lookup key. This is the field that will be matched against the property specified in the lookup processor.
Supports Expression Language: true (will be evaluated using variable registry only)
Ignore Duplicatestrue
  • true
  • false
Ignore duplicate keys for records in the CSV file.

State management:

This component does not store state.

Restricted:

This component is not restricted.

System Resource Considerations:

None specified.