Add/Update/Delete Members

Operation Name

Function Overview

Adds, updates and deletes members belonging to a organization on DataSpider BPM.

Adds, updates and deletes members specified from an input data, and outputs members that failed to add, update and delete to output data.

Data Model

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 to show on the script canvas.
Input data	Required	Not available	Select the component on the script canvas.

Required settings

Item name	Required/Optional	Use of variables	Description
Destination	Required	Not available	Select a global resource. For more details on Global Resource settings, refer to "Global Resource Properties". [Add]: Adds a new global resource. [Edit the list]: Enables to edit the global resource settings in the "Edit resource list".
Organization	Required	Available	Select or input organization that register/update/delete member.
Process method	Optional	Not available	Select the process method. [Add differences]:(default) Adds members of input data to [Organization] as a belonging member. [Delete differences]: Deletes members of input data from [Organization] as a belonging member. [Overwrite Update]: Deletes all members belonging to [Organization], and add members from input data.

Data processing method

Item name	Required/Optional	Use of variables	Description	Remarks
Data processing method	Required	Not available	Select the data processing method. [Use script settings]:(default) Applies the setting of mass data processing setup in script property to the 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

<?xml version="1.0" encoding="UTF-8" ?>
<table>
  <row>
    <column>Email of the member to be added, updated or deleted/email</column>
  </row>
  <row>
    :
  </row>
</table>

Element name	Column name/label	Description	Remarks
row	-	Repeats corresponding to the number of members to add/update/delete.
column	Email of the member to be added, updated or deleted/email	Inputs Email of the member to be added, updated or deleted.

Output Schema

<?xml version="1.0" encoding="UTF-8" ?>
<table>
  <row>
    <column>Email of the member who failed to add, update or delete/email</column>
  </row>
  <row>
    :
  </row>
</table>

Element name	Column name/label	Description	Remarks
row	-	Repeats corresponding to the number of members that failed to add/update/delete.
column	Email of the member who failed to add, update or delete/email	Outputs Email of the member who failed to add, update or delete.

Loading Schema on Mapper

Schema will be loaded automatically.

For more detail, refer to "Edit schema".

Mass Data Processing

Mass data processing is supported.

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available Component Variables

Component variable name	Description	Remarks
Count	Returns the number of organizations that was added/updated/deleted.	Default value is null.
failure_count	Returns the number organizations that failed to add/update/delete.	Default value is null.
message_category	Stores the category of message code corresponding to the occurred error.	Default value is null.
message_code	Stores the code of message code corresponding to the occurred error.	Default value is null.
message_level	Stores the severity of message code corresponding to the occurred error.	Default value is null.
error_type	When an error occurs, the class of error will be stored.	Default value is null. Class of error is in following format. Example: "java.io.FileNotFoundException" Depending on version for the DataSpider Servista, stored contents may alter.
error_message	When an error occurs, the message of error will be stored.	Default value is null. Depending on version for the DataSpider Servista, stored contents may alter.
error_trace	When an error occurs, the trace information of error will be stored.	Default value is null. Depending on version for the DataSpider Servista or executing client application, stored contents may alter.

Specification Limits

An executing user needs to have user management authority.

An add, update and delete process is executed by one line at a time. Therefore, even if error occurs during the process, the data which have been added, updated and deleted are reflected.

If error occurred during the process, result data of line which error occurred will output, but process will continue.

BASIC authentication is supported and OAuth authentication is not supported.

If you checked DataSpider BPM server's [System Settings]-[SSO (SAML)]-[Disable Password Authentication], only users who have system management authority can connect to DataSpider BPM server.

Select "Overwrite update" from [Process method], if deletion of members belonging to [Organization] fails, processing will not continue and generate error.

Main Exceptions

Exception name	Cause	Measure
InputDataNotFoundException	[Input data] is not specified.	Specify [Input data] or draw a data flow.
ResourceNotFoundException Resource definition cannot be found. Name:[]	[Destination] is not specified.	Specify [Destination].
ResourceNotFoundException Resource definition cannot be found. Name:[<Global resource name>]	Selected resource definition in [Destination] cannot be found.	Confirm the global resource specified in [Destination].
InvalidPropertyConfigurationException <Property name> is not specified.	[<Property name>] is not specified.	Specify [<Property name>].
AuthenticationException	[Email] or [Password] for the global resource is false.	Confirm the global resource setting.
GroupNotFoundException	Organization specified in [Organization] does not exist.	Confirm the setting for [Organization].