Official |[Mail] Send Multiple E-mails

Operation name

Send Multiple E-mails

Function overview

Based on the contents of the input data, sends emails to SMTP server.

Data model

The data model of this component is table model type.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name that is used on the script canvas.
Input data	Required	Not available	Select a component on the script canvas.

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
Destination	Required	Not available	Select a connection resource. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.

Item name

Required/Optional

Use of variables

Description

Remarks

Destination

Required

Not available

Select a connection resource.

Add: A new connection resource can be added.
Edit list: Connection resource settings can be edited in > HULFT INTEGRATE > Connections.

Authentication

Item name	Required/Optional	Use of variables	Description	Remarks
Authentication mode	Required	Not available	Select the authentication mode when sending emails. None (Default) Don't perform authentication. POP before SMTP Perform authentication using POP3 before sending. SMTP AUTH (LOGIN) Use SMTP AUTH (LOGIN) to authenticate the system. OAuth 2.0 AUTH Perform OAuth 2.0 authentication.	If POP before SMTP is selected, connection timeout for POP server is 15 seconds. When OAuth 2.0 AUTH is selected, select SSL/TLS or STARTTLS for SSL connection of Destination.
Hostname	Required	Available	Enter the host name or IP address of the POP mail server.	Enabled when POP before SMTP is selected in Authentication mode.
Port number	Required	Available	Enter the port number to access the POP mail server.	The default value is "110". Enabled when POP before SMTP is selected in Authentication mode.
User name	Required	Available	Enter a user name to access POP mail server, a user name to perform SMTP authentication, or a user name to perform OAuth 2.0 authentication.	Enabled when POP before SMTP, SMTP AUTH (LOGIN), or OAuth 2.0 AUTH is selected in Authentication mode.
Password	Required	Available	Enter a password for SMTP AUTH or to access to POP mail server.	Enabled when POP before SMTP or SMTP AUTH (LOGIN) is selected in Authentication mode.
SSL connection	Optional	Not available	Select whether to make the SSL connection to POP mail server. Selected Make SSL connections. Not selected (Default) Don't make SSL connections.	Enabled when POP before SMTP is selected in Authentication mode. The method of SSL connection is SSL/TLS. If this is selected, the server certificate of the POP3 server must be imported to the keystore. Contact support when you import the certificate.
Authentication (OAuth 2.0)	Required	Not available	Select a connection resource to use for authentication. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.	Enabled when OAuth 2.0 AUTH is selected in Authentication mode.

Property actions

Item name	Description	Remarks
Authentication test	Perform an authentication test by using the selected Authentication mode.	Enabled when POP before SMTP or SMTP AUTH (LOGIN) is selected in Authentication mode. In the following cases, Authentication test is disabled. When POP before SMTP or SMTP AUTH (LOGIN) is selected in Authentication mode. Hostname or Port number, User name, or Password has not been entered. A script variable is specified in Hostname or Port number, User name, or Password. When OAuth 2.0 AUTH is selected in Authentication mode

Transmission settings

Item name	Required/Optional	Use of variables	Description	Remarks
Encoding	Optional	Available	Select or enter an encoding when sending emails. Japanese (JIS) (Default) Japanese (Shift JIS) Japanese (EUC) US-ASCII ISO 8859-1 UTF-8 EUC-KR When you enter encoding, specify one of the encodings supported in Java SE Runtime Environment 8. = Remarks = For details, refer to "Supported Encodings" (http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html).	If omitted, "UTF-8" is used when sending.
Skip input data that cannot be sent	Optional	Not available	Select the operation to execute when data that can't be sent is entered. Selected Data that can't be sent will be skipped and the processing continues. Not selected (Default) An error occurs when the data that can't be sent is entered.	When this is selected, if an error occurs during the sending of a message, sending of the message will be skipped, and the processing continues. For connection errors such as when the specified host can't be connected to, an error will persist even if this property is selected, because the processing can't continue. Input data that can't be sent is logged with the log level "WARN."

Item name

Required/Optional

Use of variables

Description

Remarks

Encoding

Optional

Available

Select or enter an encoding when sending emails.

Japanese (JIS): (Default)
Japanese (Shift JIS)
Japanese (EUC)
US-ASCII
ISO 8859-1
UTF-8
EUC-KR

When you enter encoding, specify one of the encodings supported in Java SE Runtime Environment 8.

= Remarks =

For details, refer to "Supported Encodings" (http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html).

If omitted, "UTF-8" is used when sending.

Skip input data that cannot be sent

Optional

Not available

Select the operation to execute when data that can't be sent is entered.

Selected

Data that can't be sent will be skipped and the processing continues.

Not selected

(Default)

An error occurs when the data that can't be sent is entered.

When this is selected, if an error occurs during the sending of a message, sending of the message will be skipped, and the processing continues.
For connection errors such as when the specified host can't be connected to, an error will persist even if this property is selected, because the processing can't continue.
Input data that can't be sent is logged with the log level "WARN."

Header

Item name	Required/Optional	Use of variables	Description	Remarks
Header list	Optional	-	Specify a header to give when sending emails. Up Moves the selected row upward by one row. Down Moves the selected row downward by one row. Add Adds a row. Delete Deletes the row.	Refer to Schemas if you set the schema information for the header.
Header list/Header	Required	Available	Enter the key header to give when sending emails.	Multibyte key values aren't supported. If multibyte characters are included, the value is encoded according to RFC 2047 compliant encoding.

Item name

Required/Optional

Use of variables

Description

Remarks

Header list

Optional

-

Specify a header to give when sending emails.

Up: Moves the selected row upward by one row.
Down: Moves the selected row downward by one row.
Add: Adds a row.
Delete: Deletes the row.

Refer to Schemas if you set the schema information for the header.

Header list/Header

Required

Available

Enter the key header to give when sending emails.

Multibyte key values aren't supported.
If multibyte characters are included, the value is encoded according to RFC 2047 compliant encoding.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Schemas

Input schema

<?xml version="1.0" encoding="UTF-8" ?>
 <table>
   <row>
     <column>Header 1</column>
     <column>Header 2</column>
       : 
     <column>From</column>
     <column>To</column>
     <column>CC</column>
     <column>BCC</column>
     <column>Reply To</column>
     <column>Subject</column>
     <column>Content-Type</column>
     <column>Message</column>
     <column>Attachments</column>
   </row>
   <row>
     : 
   </row>
 </table>

Column name	Description	Remarks
Header	Specify for each key defined in Header List.	If a single key holds multiple values, separate them by comma (,). Note This item isn't available if nothing is defined in Header list.
From		To specify multiple values, separate the values by using the delimiter character (i.e., semi colon (;) or comma (,)).
To		To specify multiple values, separate the values by using the delimiter character (i.e., semi colon (;) or comma (,)).
CC		To specify multiple values, separate the values by using the delimiter character (i.e., semi colon (;) or comma (,)).
BCC		To specify multiple values, separate the values by using the delimiter character (i.e., semi colon (;) or comma (,)).
Reply To		To specify multiple values, separate the values by using the delimiter character (i.e., semi colon (;) or comma (,)).
Subject
Content-Type
Message
Attachments		To specify multiple values, separate the values by comma (,). Note Specify an absolute path of HULFT Square Storage for the file path.

Output schema

None.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Transaction

Transaction isn't supported.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name	Description	Remarks
count	The number of sent emails is stored.	The default value is null.
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
error_type	When an error occurs, the error type is stored.	The default value is null. The format of the error type is as follows. Example: java.io.FileNotFoundException
error_message	When an error occurs, the error message is stored.	The default value is null.
error_trace	When an error occurs, the trace information for the error is stored.	The default value is null.

Text encoding methods for attached files

UTF-8 encoding is set for the charset parameter of Content-Type. It can't be changed.

Message codes, exception messages, and limitations

Connector	Message code	Exception message	Limitations
Messages and limitations of the Mail connector