Send Multiple E-mails

Operation Name

Send Multiple E-mails

Function Overview

Based on the contents of the input data, send mail to Gmail SMTP server.

Data Model

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

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.  
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 Global Resources.
For details on global resource settings, refer to "Global Resource Properties (Destination)".
  • [Add]:
    Add a new global resource.
  • [Edit list]:
    Allows you to edit the global resource settings in "Edit resource list".
  
Authentication
Item name Required/Optional Use of variables Description Remarks
Authentication mode Required Not Available Select the authentication mode when sending mail.
  • [OAuth 2.0 AUTH]: (default)
    Perform OAuth 2.0 authentication.
  • [SMTP AUTH (LOGIN)]:
    Use SMTP AUTH (LOGIN) to authenticate the system.
User name Required Available Enter a user name to authenticate by SMTP AUTH or a user name to authenticate by OAuth 2.0 authentication.
  • Enter the value in either of the following formats: “<G Suite user name>” or “<G Suite user name>@<G Suite domain name>”.
Password Required Available Enter a Password for SMTP authentication.
  • Enabled when [SMTP AUTH (LOGIN)] is selected in [Authentication mode].
Authentication (Gmail 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].
  • If the following happens, [Authentication test] is disabled.
    • When [SMTP AUTH (LOGIN)] is selected in [Authentication mode].
      • [User name] or [Password] are not entered.
      • A variable is specified in [User name] or [Password].
    • When [OAuth 2.0 AUTH] is selected in [Authentication mode].
      • When [User name] or [Authentication (Gmail OAuth 2.0)] is not entered.
      • A variable is specified in [User name].
Transmission Setting
Item name Required/Optional Use of variables Description Remarks
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".
Skip input data that cannot be sent Optional Not Available Select the operation to execute when data that cannot be sent is entered.
  • [Checked]:
    Messages that cannot be sent will be skipped and continue to process.
  • [Not Checked]: (default)
    An error occurs when the data that cannot be sent is entered.
  • If checked, when an error occurs when sending a message, the sending message process will be skipped and continue to process.
  • For connection errors that occur when a host that cannot be connected is specified, the error will persist even if this property is checked, because processing cannot continue.
  • Input data that cannot be sent is output into a log with the "WARN" log level.
Header
Item name Required/Optional Use of variables Description Remarks
Header list Optional - Specifies a header to give when sending mail.
  • Refer to Schema if you set the schema information for the header.
Header list/Header Required Available Enter the key header to give when sending mail.
  • Double-byte key values are not supported.
  • 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

<?xml version="1.0" encoding="UTF-8" ?>
 <table>
   <row>
     <column>Message ID</column>
     <column>UID</column>
     <column>Sent Date(Received Date)</column>
     <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 the [Header List].
  • If a single key holds multiple values, specify them as a comma-delimited string (,).
  • No element occurs if nothing is specified in the [Header List].
From  
  • You can only use the email address registered as the "[From] address" In the Gmail settings of the user.
    If the specified email address is not registered, the default email address is used.
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 using the delimiter character (i.e., semi colon (;) or comma (,)).
  • Specify the file path as an absolute path in the DataSpider file system.

Output Schema

None

Loading Schema on Mapper

Schema is loaded automatically.
For details, refer to "Edit Schema".

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

Major Exceptions

Exception Name Cause Solution
ResourceNotFoundException
Resource definition is not found. Name: []		 [Destination] or [Authentication (Gmail OAuth 2.0)] is not specified. Specify [Destination] or [Authentication (Gmail OAuth 2.0)].
ResourceNotFoundException
Resource definition is not found. Name : [<Global Resource name>]		 The resource definition selected in [Destination] or [Authentication (Gmail OAuth 2.0)] is not found. Check the global resource specified in [Destination] or [Authentication (Gmail OAuth 2.0)].
InvalidPropertyConfigurationException
<Property name> is not specified.		 [<Property name>] is not specified. Specify [<Property name>].
InvalidSchemaException [Input data] is not a valid schema. Please check the schema of [Input data].
RecipientsNotFoundException The receiver specified in [Input data] is invalid. Check the following.
  • A receiver is specified in [Input Data].
  • The receiver address specified in [Input Data] does not contain any multi-byte characters.
SenderNotFoundException No sender is specified in [Input data]. Check whether the sender has been specified in [Input data].
InvalidMailAddressException
<sender> is an invalid email address.		 The sender specified for [Input data] is invalid. Check that the sender specified for the [Input data] is valid.
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] and [Password].
com.sun.mail.util.MailConnectException: Failed to establish connection to Gmail SMTP server. Check the network reachability.
javax.mail.SendFailedException
 Failed to send message. Check that To, CC, and BCC for the [Input data] are correct.
OAuth2AuthenticationFailedException
OAuth 2.0 authorization has failed.		 [User name] or [Authentication (Gmail OAuth 2.0)] is invalid. Check [User name] or [Authentication (Gmail OAuth 2.0)].

Notes