You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.

What is it for?

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-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

NameDescription
ResourceThe 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 relationSelect 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. 

Only rows that match all criteria will be selected.
Goal

The attribute (of the target entity) to which the value in the corresponding column of the CSV will be mapped.

1 Comment

  1. Is it possible to extend this brief description of this service call? We have encountered numerous problems using this service call and the datatypes it tries to import. Would it be possible to include a list of expected input format such that the runtime doesn't error?