Skip to content

CSV Source Provider

The CSV Source feeds data from local CSV or TSV files supporting Records query with dynamic filtering and/or ordering.

Settings

Source Instance Common Settings

SettingDescriptionDefault
NameThe name that will identify this source instance.
Default Cache TimeThe default duration in seconds before the cache is renewed, set to 0 to disable caching. This setting can be overriden in each query configuration.3600

CSV Source Settings

SettingDescriptionDefault
FileThe relative or absolute local path to the file which to use as source.
DelimeterThe delimiter character the content is formated with.,
EnclosureThe enclosure character the content is formated with."

Records Query

Fetches records from the file and resolves to a list of dynamically generated CSV record type based on the file schema.

CSV Records Query

SettingDescriptionDefaultDynamic
FiltersThe list of filter conditions applied to the query.[]
OrderingThe list of ordering conditions applied to the query.[]
StartThe offset applied to the query.1
QuantityThe limit applied to the query.20
CacheThe duration in seconds before the cache is invalidated and the query re-executed.3600