Send One E-mail

Operation Name

Send One E-mail

Function Overview

Send a mail to SMTP server.

Properties

For details on 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
Destination	Required	Not Available	Select Global Resources. For details on global resource settings, refer to "Global Resource Properties". [Add]: Add a new global resource. [Edit list]: Allows you to edit the global resource settings in "Edit resource list".
From	Required	Available	Enter the email address of the sender.
To/Cc/Bcc	Required	-	Enter the email address of the destination. Each row can be operated with the following buttons. [Add]: Add a row. [Up]: Move the order of the selected row upwards by one. [Down]: Move the order of the selected row downwards by one. [Delete]: Delete a row.
To/Cc/Bcc / Category	Required	Available	Select the type of destination. [TO]: (default) [CC]: [BCC]:
To/Cc/Bcc / Mail Address	Required	Available	Enter your email address.

Authentication

Item name	Required/Optional	Use of variables	Description	Remarks
Authentication mode	Required	Not Available	Select the authentication mode when sending mail. [None]:(default) Authentication is not performed. [POP before SMTP]: Perform authentication to 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].
Host name	Required	Available	Enter POP mail server host name or the IP address.	Enabled when [POP before SMTP] is selected in [Authentication mode].
Port number	Required	Available	Enter the POP port number to access the 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 to POP mail server or a user name to perform SMTP authentication or a user name to perform OAuth 2.0 AUTH.	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. [Checked]: Make SSL connections. [Not checked]: (default) Does not perform SSL connection.	Enabled when [POP before SMTP] is selected in [Authentication mode]. SSL/TLS is used for SSL connection method. If [Checked] is selected, the certificate of the POP3 server must be imported to the keystore which DataSpiderServista is referring to. For information regarding how to import to the keystore, refer to "Import of certificate".
Authentication (OAuth 2.0)	Required	Not Available	Select a global resource used for authentication. For details on global resource settings, refer to "Global Resource Properties (OAuth 2.0)". [Add]: Add a new global resource. [Edit list]: Allows you to edit the global resource settings in "Edit resource list".	Enabled when [OAuth 2.0 AUTH] is selected in [Authentication mode].

Property Action

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

Message

Item name	Required/Optional	Use of variables	Description	Remarks
Subject	Optional	Available	Enter the subject.
Message	Optional	Available	Enter the text.
Content-Type	Optional	Available	Select or enter the Content-Type. [text/plain]: (default) [text/html]:	If omitted, the message is sent as "text/plain". The value of [Encoding] is set for the charset parameter.
Encoding	Optional	Available	Select or enter type of encoding when sending mail. [Japanese (JIS)]: (default) [Japanese (Shift JIS)]: [Japanese (EUC)]: [US-ASCII]: [ISO 8859-1]: [UTF-8]: [EUC-KR]: When specifying the encoding directly in the field, use the encoding supported by Java SE Runtime Environment 8. For details, refer to "Supported Encodings"(http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html).	If omitted sends in "UTF-8".

Attachments

Item name	Required/Optional	Use of variables	Description	Remarks
Attachments	Optional	-	Specify attachment file paths. Each row can be operated with the following buttons. [Add]: Add a row. [Up]: Move the order of the selected row upwards by one. [Down]: Move the order of the selected row downwards by one. [Delete]: Delete a row.
Attachments/File path	Required	Available	Enter the attachment file path.	Specify the file path as an absolute path of the DataSpider file system. Other than path separators (/), Restrictions on characters used in DataSpider filesystem cannot be used.

Reply-To

Item name	Required/Optional	Use of variables	Description	Remarks
Reply-To	Optional	-	Specify the destination email address of a reply. Each row can be operated with the following buttons. [Add]: Add a row. [Up]: Move the order of the selected row upwards by one. [Down]: Move the order of the selected row downwards by one. [Delete]: Delete a row.
Reply-To / Mail address	Required	Available	Enter your email address.

Header

Item name	Required/Optional	Use of variables	Description	Remarks
Header list	Optional	-	Specifies a header to give when sending mail.
Header list/Header	Required	Available	Enter the key header to give when sending mail.	Double-byte key values are not supported.
Header list/Value	Required	Available	Enter the value header to give when sending mail.	If the double-byte 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 adapter. The description will be applied to the specifications.

Schema

Input Schema

None

Output Schema

None

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available Component Variables

Component variable name	Description	Remarks
count	Returns the number of messages sent.	The default value is null.
message_category	When an error occurs, the category of the message code corresponding to the error that occurred is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error that occurred is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error that occurred is stored.	The default value is null.
error_type	When an error occurs, the type of error that occurred is stored.	The default value is null. Error type is in the following format. Example: "java.io.FileNotFoundException" The contents to be stored may vary depending on the version of DataSpider Servista.
error_message	When an error occurs, the error message of the error that occurred is stored.	The default value is null. The contents to be stored may vary depending on the version of DataSpider Servista.
error_trace	When an error occurs, the trace information of the error that occurred is stored.	The default value is null. The contents to be stored may vary depending on the version and client applications of DataSpider Servista.

Grant charset parameter to attached file setting

If you send a text-format attachment file, the default encoding of the OS will be set to the charset parameters of Content-Type.
By setting up the following property, you can stop granting charset parameter to attached file's Content-Type.

Key	Location	Description	Remarks
mail.mime.setdefaulttextcharset	$DATASPIDER_HOME/server/conf/ system.properties	[true]: Grants default charset parameter if you attach text format file. [false]: Does not grant default charset parameter if you attach text format file.	Default value is "true", and if you omit, "true" is set.

Specifications Limits

Pay attention to the handling of machine-dependent characters and some characters.

Some characters
If you send some of the following characters, send in UTF-8.

Characters Character code (Unicode)

― 0x2014

～ 0x301C

‖ 0x2016

－ 0x2212

￠ 0x00A2

￡ 0x00A3

￢ 0x00AC

Characters	Character code (Unicode)
―	0x2014
～	0x301C
‖	0x2016
－	0x2212
￠	0x00A2
￡	0x00A3
￢	0x00AC

Model dependent characters (CP932)
Transmit and receive the following machine-dependent characters as UTF-8.

Characters	Character code (Unicode)
①	0x2460;
②	0x2461;
③	0x2462;
④	0x2463;
⑤	0x2464;
⑥	0x2465;
⑦	0x2466;
⑧	0x2467;
⑨	0x2468;
⑩	0x2469;
⑪	0x246A;
⑫	0x246B;
⑬	0x246C;
⑭	0x246D;
⑮	0x246E;
⑯	0x246F;
⑰	0x2470;
⑱	0x2471;
⑲	0x2472;
⑳	0x2473;
Ⅰ	0x2160;
Ⅱ	0x2161;
Ⅲ	0x2162;
Ⅳ	0x2163;
Ⅴ	0x2164;
Ⅵ	0x2165;
Ⅶ	0x2166;
Ⅷ	0x2167;
Ⅸ	0x2168;
Ⅹ	0x2169;
㍉	0x3349;
㌔	0x3314;
㌢	0x3322;
㍍	0x334D;
㌘	0x3318;
㌧	0x3327;
㌃	0x3303;
㌶	0x3336;
㍑	0x3351;
㍗	0x3357;
㌍	0x330D;
㌦	0x3326;
㌣	0x3323;
㌫	0x332B;
㍊	0x334A;
㌻	0x333B;
㎜	0x339C;
㎝	0x339D;
㎞	0x339E;
㎎	0x338E;
㎏	0x338F;
㏄	0x33C4;
㎡	0x33A1;
㍻	0x337B;
〝	0x301D;
〟	0x301F;
№	0x2116;
㏍	0x33CD;
℡	0x2121;
㊤	0x32A4;
㊥	0x32A5;
㊦	0x32A6;
㊧	0x32A7;
㊫	0x32AB;
㈱	0x3231;
㈲	0x3232;
㈹	0x3239;
㍾	0x337E;
㍽	0x337D;
㍼	0x337C;
≒	0x2252;
≡	0x2261;
∫	0x222B;
∮	0x222E;
∑	0x2211;
√	0x221A;
⊥	0x22A5;
∠	0x2220;
∟	0x221F;
⊿	0x22BF;
∵	0x2235;
∩	0x2229;
∪	0x222A;
ⅰ	0x2170;
ⅱ	0x2171;
ⅲ	0x2172;
ⅳ	0x2173;
ⅴ	0x2174;
ⅵ	0x2175;
ⅶ	0x2176;
ⅷ	0x2177;
ⅸ	0x2178;
ⅹ	0x2179;
￢	0xFFE2;
￤	0xFFE4;
＇	0xFF07;
＂	0xFF02;

Some formats of RFC2231 encoding cannot be read. If the file contains an attachment with Japanese, it will be handled in RFC2231 encoding, the one with long name may not be handled.
Example:

filename*1=...
filename*2=...

Order of appearance and location of the header set is not guaranteed.

Value is an empty or null if the header is not included in the message header.

Each attachment Content-Type cannot be set.

If you send a text-format attachment file, the default encoding of the OS will be set to the charset parameters of Content-Type. You cannot individually set charset parameter value.
- Therefore, depending on attached file encoding, it does not correspond to charset parameter encoding, and garbling may occur once you preview contents of attached file with some mailer.
  In that case, dodging garbling may be possible if you set stop granting charset parameter to attached file's Content-type.
  For how to setup, refer to "Grant charset parameter to attached file setting".

PGP, S / MIME is not supported.

APOP authentication, CRAM-MD5 authentication, NTLM authentication, Kerberos authentication is not supported.

Major Exceptions

Exception Name	Cause	Solution
ResourceNotFoundException Resource definition is not found. Name: []	[Destination] or [Authentication (OAuth 2.0)] is not specified.	Specify [Destination] or [Authentication (OAuth 2.0)].
ResourceNotFoundException Resource definition is not found. Name : [<Global Resource name>]	The resource definition selected in [Destination] or [Authentication (OAuth 2.0)] is not found.	Check the global resource specified in [Destination] or [Authentication (OAuth 2.0)].
InvalidPropertyConfigurationException <Property name> is not specified.	[<Property name>] is not specified.	Specify [<Property name>].
RecipientsNotFoundException	[To/Cc/Bcc] is incorrect.	Check the following. [To/Cc/Bcc] that is configured with one or more Whether [To/Cc/Bcc / Category] is correct [Send / mail address] is entered. [Send / mail address] does not contain any multi-byte characters.
java.io.UnsupportedEncodingException	Encoding set to [Encoding] is not supported.	Check the specified encoding in [Encoding].
javax.mail.AuthenticationFailedException:	[User name] or [Password] is incorrect.	Check [User name] or [Password].
com.sun.mail.util.MailConnectException: ConnectException	[Hostname] failed to connect to the specified host.	Check that you are not wrong about [Hostname], [Port number]. Check whether services are provided in the specified host specified in [Hostname].
com.sun.mail.util.MailConnectException: UnknownHostException	[Hostname] not found.	Check the host name specified with [Hostname].
javax.mail.SendFailedException	Failed to send message.	Check [Send / mail address].
javax.mail.SendFailedException Invalid Addresses	Failed to send message.	Check [Send / mail address]. If the email address is correct, this exception may occur when the mail server returns an error.
com.sun.mail.smtp.SMTPSendFailedException	Failed to send message.	Check the message and take appropriate measures.
javax.mail.MessagingException: SSLHandshakeException	It occurs when selected [SSL/TLS] or [STARTTLS] in [SSL Connection] in global resource properties.The reason is that the server certificate registered in Java is different from the one that is used to SSL connection,so the validity cannot be verified.	Check if the server certificate is registered in JAVA when connecting to SSL server. If registered,check that the server is the same as the one registered in JAVA and check whether the server certificate has expired.
OAuth2AuthenticationFailedException OAuth 2.0 authorization has failed.	[User name] or [Authentication (OAuth 2.0)] is invalid.	Check [User name] or [Authentication (OAuth 2.0)].