Import Values

Field Name

Description/Use

Type/Options 

Optional/Mandatory 

Data object

This is the name of the collection into which the system will store the returned data.

Text

Mandatory

Data source

This is the data source name in the database.

Text

Mandatory

Selection

This is a filter query of the data. It corresponds to the FROM clause in the SQL query. For example, select value, type, name from data_source where data_source.category='user';

Collection

Optional

Paths

The system reads in the value from this column as data path. The value in the column should be unique.

Options

Mandatory

Values

The system reads in the value from this column as data value.

Options

Mandatory

Data-types

The system reads in the value from this column as data type.

Options

Mandatory

Log data object

This is the data object that stores the error messages from the execution of the database parts: add data record, get data record, update data record, delete data record, and import values. When the log data object is specified, the error message and stack trace of a database part will be stored to the object in case of errors.

When used by multiple database parts, the Log data object will store the cumulative list of error messages from the different parts.

Text

Optional

Reset log data object

When this is checked the system will clear the error messages from the Log data object. Typically, this option should be checked in the first database part of a sequence of database parts.

Checkbox

Optional

Skip on error

When this is checked the system will skip the execution of subsequent database parts linked to the same Log data object. 

Checkbox

Optional