tab to define how the data access service connector must parse data returned from the database.
The following image shows the
Output
tab:
For each output data item, specify the following properties:
Name
: The name of a field into which a returned value is placed.
Type
: The data type of the value being written to the field. If the type is Object List or Reference, Process Designer displays a list of process objects from which you can choose one of the objects defined within the
Process Objects
tab.
Description
: Enter a description of the output field.
Get From
: Select one of the following options:
Column
: To enter a column name (which is the column name in the database table used within the output returned by the database) to be placed within the output field.
Expression
: To write an expression to parse the output returned by the database. Click
f(x)
to open the Expression Editor where you can type the expression.
Result Set
: To assign the complete contents of the response from the database to the output field.
Entire Response As Attachment
: To handle the entire response as an attachment.
Attachments
: To work with multiple attachments and pass the entire list of attachments to the selected variable except the part used as the payload.