Read View

Operation Name

Read View

Function overview

Read the data of view.

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required/Optional Use of Variables Description Remarks
Name Required Not available Enter the name on the script canvas.  
Required settings
Item name Required/Optional Use of Variables Description Remarks
Destination Required Not available Select Global Resources.
Refer to "Global Resource Properties" for global resource settings .
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be managed from "Edit Resource list".
 
View name Required Available Select or enter a view name.
  • If a script variable is specified, [Column definition] is left unconfigured.
Column definition Required - Display the column definition of the view specified in [View name]  
Column definition / Column name Required Available Enter [Column name]
By default, the column type is set to the specified view.
 
Column definition / Type Required Not available Select the type of the column.
By default, the column type is set to the specified view.
  • [string]
  • [datetime]
  • [double]
 
Column definition / Field name Optional Available Specify field name.  
Delimiter Required Available Enter the delimiter of multiple values.
  • Delimiters of multiple values can be specified freely.
  • The default value is ",".
  • Multiple values can only be retrieved when the type of the field is "text".
Get attachment Optional Not available Select whether to get the attachments in Notes document.
  • [Checked]: (default)
    Get an attachment in Notes document.
  • [Not Checked]:
    Do not get the attachment in Notes document.
 
Destination to save attachment Required Available Select or input directory to save the attached file in the document.

Click [Browse] button to activate the file Selectr and Select the directory.
  • [Get attachment] if you check to enable.
  • The default value is "/tmp".
  • Please specify the absolute path of the DataSpider file system as the file path.
  • Constrained Characters of DataSpider File System cannnot be used, except for the path separator "/"..
Property Action
Item name Description Remarks
Reset view and column Reset the list of views in [View name] as well as [Column definition].
  • If you add or change the view at Domino Designer, you can reflect the changes by using this property action.
    The modification of view or column is only reflected in this operation.
Key settings
Item name Required/Optional Use of Variables Description Remarks
Key definition Optional - Specify the key.
Reads data matching the specified key.

Each column can be operated with the following buttons.
  • [Add]:
    Add a column.
  • [Up]:
    Move the order of the selected column upwards by one.
  • [Down]:
    Move the order of the selected column downwards by one.
  • [Delete]:
    Delete the column.
  • For the details about specifying the key, please refer to "Key settings" .
Key definition / Key name Required Available Enter [Column name]  
Key definition / Key value Required Available Enter the field value.  
Data processing method
Item name Required/Optional Use of Variables Description Remarks
Mass data processing Required Not available Select a data processing method.
  • [Use script settings]: (default)
    Apply mass data processing settings of script property to adapter.
  • [Disable]:
    Mass data processing is not performed.
  • [Enable]:
    Mass data processing is performed.
 
Comment
Item name Required/Optional Use of Variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.
 

Schema

Input Schema

None.

Output Schema

<?xml version="1.0" encoding="UTF-8" ?>
&lt;table&gt;
  &lt;row&gt;
    <column>UniversalID</column>
    <column>NoteID</column>
    <column>Field data</column>
    :
  &lt;/row&gt;
  &lt;row&gt;
    :
  &lt;/row&gt;
</table>

Loading schema in Mapper

Schema is loaded automatically.
See "Edit Schema"for any details .

Mass data processing

Mass data processing is supported.

PSP Usage

PSP is not supported.

Available Component variables

Component variable name Description Remarks
count Returns the number of read data.
  • The value defaults to null.
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Stores the type of the occured error.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The message may vary depending on DataSpider Servista version.
error_message Stores the error message for the occured error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
error_trace Stores stack trace of the occurred error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version or the client application used.

For key settings

If you specify [Key definition], Specify [Column name] at [Key definition / Key name] and specify value of the field at [Key definition / Key value].

Specification Limits

Main exceptions

Exception name Cause Solution
ResourceNotFoundException
Resource definition could not be found.Name: []
[Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found.Name: [<name of Global Resources>]
Resource definition specified in [Destination] is not found. Check the global resource specified in [Destination].
InvalidPropertyConfigurationException
Property "<property name>" value "" is incorrect.
[<Property name>] is not specified. Specify the [<Property name>].
InvalidPropertyConfigurationException
Given <property name> "<value of the property>" not found.
[<Property name>] not found in the specified property value. [<Property name>] Please check the value of the property specified.

Notes