Page History
Info | ||||
---|---|---|---|---|
| ||||
AQ_CsvConnectivityService is used to load data from a CSV into your session as instances, one instance per row. |
What does it do?
The CsvConectivityService is a service that connects to an external data source which is one way Blueriq is able to handle master data. In this case the data is stored in a .csv (text) file. External data sources are connected to Blueriq Studio through a data connection, which is a set of information that describes how to locate, log in, query, and access the external data source. This service uses the wizard Configure CSV Service to set parametersCSV-file and imported in a Blueriq session (profile) as instances, one instance per row.
AQ_CsvConnectivityService vs. Data rule
Although the editor of the AQ_CsvConnectivityService and the Data rule look the same in Blueriq Encore, and they both use a (CSV) resource, they are used for different purposes. Where the AQ_CsvConnectivityService is used to create instances of an entity when the Runtime reaches the service call of this type in a flow, a data rule is used to model decisions based on data from a CSV file in a declarative way, and is part of the truth maintenance system.
Parameters
Name | Description | ||
---|---|---|---|
Resource | The element that holds either a reference to an external CSV file or the data of an imported CSV file itself. | ||
Target entity | The entity for which an instance is created for each row in the CSV file that meets the criteria. | ||
Assign instance to a relation | |||
Target relation | Select the relation that should be set to the created instance. The from entity should be a singleton. The to entity should match the target entity. | ||
What should happen to existing instances? | Choose 'Clear', 'Do not clear', or 'Merge'. | ||
Criteria | Criterea are used for selection of rows. A criterion consists of a comparator and an expression (compared value). It’s possible to specify more than one criterion per column.
| ||
Goal | The attribute (of the target entity) to which the value in the corresponding column of the CSV will be mapped. |