Source Providers
CSV Source
Content Source based on CSV files.
The CSV Source feeds data from local files formatted as CSV (comma-separated values) or TSV (tab-separated values), supporting dynamic filtering/ordering. Based on the multi-instance source workflow it allows loading multiple files with different configurations.
Settings
The source settings determines the content structure, every time the instance is saved the structure will be regenerated.
| Setting | Default | Description | Required |
|---|---|---|---|
| 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. |
The following settings are common to all source instances.
| Setting | Default | Description |
|---|---|---|
| Name | CSV | The name that will identify this source instance. |
| Default Cache Time | 3600 | 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. |
Content Structure
Be cautious, changing certain settings of an instance might affect it content structure and break existing content mappings.
Content Queries
For every source instance the following content queries will be made available as Dynamic Content option.
Records Query
Fetches records from the file and resolves to a list of dynamically generated CSV record type based on the file schema.
| Setting | Default | Description |
|---|---|---|
| Filters | [] | The list of filter conditions applied to the query. |
| Ordering | [] | The list of ordering conditions applied to the query. |
| Start | 1 | The offset applied to the query. |
| Quantity | 20 | The limit applied to the query. |
| Cache | 3600 | The duration in seconds before the cache is invalidated and the query re-executed. |