CSV Source Provider
The CSV Source feeds data from local CSV or TSV files supporting Records query with dynamic filtering and/or ordering.
Settings
Setting | Description | Default |
---|---|---|
Name | The name that will identify this source instance. | |
Default Cache Time | The 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 |
Setting | Description | Default |
---|---|---|
File | The relative or absolute local path to the file which to use as source. | |
Delimeter | The delimiter character the content is formated with. | , |
Enclosure | The 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.
Setting | Description | Default | Dynamic |
---|---|---|---|
Filters | The list of filter conditions applied to the query. | [] | ✓ |
Ordering | The list of ordering conditions applied to the query. | [] | ✓ |
Start | The offset applied to the query. | 1 | ✓ |
Quantity | The limit applied to the query. | 20 | ✓ |
Cache | The duration in seconds before the cache is invalidated and the query re-executed. | 3600 |