Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Name | Required | Not available | Enter the name on the script canvas. | |
Input data | Required | Not available | Select the component on the script canvas. |
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 .
|
|
Form name | Required | Available | Select or enter a form name. |
|
Field definition | Required | - | Display the field definition of the form specified in [Form name]. | |
Field definition / Field name | Required | Available | Enter the field name of form.
By default, the field name in the specified form is set. |
|
Field definition / Type | Required | Not available | Select the type of the field.
By default, the field type in the specified form is set.
|
|
Update mode | Required | Not available | Select how to update data.
|
|
Validity verification | Optional | Not available | Select whether to use the field design formula.
|
|
Delimiter | Required | Available | Enter the delimiter of multiple values. |
|
Item name | Description | Remarks |
---|---|---|
Reset forms and fields | Resets the form list of [Form name] and [Field definition]. |
|
Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Update in initial value when input value is empty. | Optional | Not available | Selects the action when the input data is null or empty character.
|
|
Item name | Required/Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Key | Optional | - | Specify the key.
Reads data matching the specified key. Each column can be operated with the following buttons.
|
|
Key / Key name | Required | Available | Enter the name of the field. |
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. |
<?xml version="1.0" encoding="UTF-8" ?> <table> <row> <column>UniversalID</column> <column>NoteID</column> <column>Field data</column> : </row> <row> : </row> </table>
Component variable name | Description | Remarks |
---|---|---|
count | Returns the total number of documents written data. |
|
insert_count | Returns the number of documents inserted. |
|
update_count | Returns the number of documents updated. |
|
delete_count | Returns the number of documents updated. |
|
message_category | Stroes the category to which corresponding message code belongs to, when an error occurs. |
|
message_code | Stores its corresponding message code of occured error. |
|
message_level | Stores the severity of the corresponding message code of the occured error. |
|
error_type | Stores the type of the occured error. |
|
error_message | Stores the error message for the occured error. |
|
error_trace | Stores stack trace of the occurred error. |
|
Input data | [Insert/Update] Action | [Delete] Action |
---|---|---|
"Universal ID" exists | Searches using "Universal ID" as key, updates the matching Notes documents. Error occurs if no match exists."Note ID" or key value specified in [Key] is ignored. | Searches using "Universal ID" as key, deletes the matching Notes documents. Error occurs if no match exists."Note ID" or key value specified in [Key] is ignored. |
"Universal ID" does not exist, "NoteID" exists | Searches using "Note ID" as key, updates the matching Notes documents. Error occurs if no match exists. Key value specified in [Key] is ignored. | Searches using "Note ID" as key, deletes the matching Notes documents. Error occurs if no match exists. Key value specified in [Key] is ignored. |
Neither "Universal ID" nor "Note ID" exist | Searches using field specified in [Key] as key, updates the matching Notes documents. Inserts input data if no match exists. Error occurs if an non-exist key is specified. | Searches using field specified in [Key] as key, deletes the matching Notes documents. Do not delete when no match existsError occurs if an non-exist key is specified. |
Neither "Universal ID" nor "Note ID" exist, and [Key] is not set | Searches using "field data" as key, deletes the matching Notes documents. Inserts input data if no match exists. | Searches using "field data" as key, deletes the matching Notes documents. Inserts input data if no match exists. |
Field value of Notes document before update |
---|
123,abc |
Field value of Notes document after update |
---|
abc,aiu,123 |
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]. |
InputDataNotFoundException | [Input data] is not specified. | Specify [Input data] or draw a data flow. |
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. |
LotusDominoException 4091: Invalid universal id |
No document matching the "Universal ID" in the input data during operation [Insert/Update] or [Delete]. | Please check [Input data]. |