Versions Compared

Old Version 1

changes.mady.by.user Randy Anft

Saved on

compared with

New Version Current

changes.mady.by.user Tijmen Daatselaar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info
iconfalse
titleWhat 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 (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

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. 

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