Add Record

Operation Name

Add Record

Function Overview

Add the record of kintone.

Data Model

Data model of this component is XML 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	Remarks
Destination	Required	Not available	Select Global Resources. Refer to "Global Resource Properties" for global resource settings . [Add]: Adds new global resource. [Edit list]: Global resource settings can be managed from "Edit Resource list".
Update records that match the value of the key	Optional	Not available	Select whether to update the selected column name as key, and select whether to add all the records. [Checked]: Updates records that match the key value.Add records that does not match the key value. [Not Checked]: (default) Add all records	When [Update records that matches the value of the key] is checked, if [Key] is not specified in [Field list], error occurs. Refer to "About Add/Update" for details.
Field list	Required	-	Specify field.
Field list/ Writing target	Optional	Not available	Select whether to include each field as the writing target. [Checked]: Includes as writing target. [Not checked]:(default) Does not include as writing target.	There needs to be at least one checked column. The checked column name is displayed in the Mapper schema. Checking a checkbox in the header enables bulk operation.
Field list/ Key	Required	Not available	Select the key included in the update criteria. [Checked]: Includes in update criteria. [Not Checked]: (default) Do not include in update criteria.	Enabled when [Update records that match the value of the key] is checked. When [Update records that match the value of the key] is checked, if [Key] is not specified in [Field list], error occurs. Field specified in [Key] is needed to check a box of [an object to write]. Refer to "About Add/Update" for details.
Field list/ Field code	Optional	Not available	Show field code.
Field list/ Field type	Optional	Not available	Show field type.
Field list/ Sub-table	Optional	Not available	Show field code of sub-table, if a field is included in sub-table.

Property Action

Item name	Description	Remarks
Update field list	Get field information from kintone application and set as [Field list].	There needs to be more than 1 line of record in the kintone application. If sub-table exists in the kintone application, there needs to be more than 1 line of record in the sub-table.

Attached file

Item name	Required / Optional	Use of Variables	Description	Remarks
How to input attached file	Optional	Not available	Select how to input the attached file. [Data (Base64)]:(default) Inputs the got attached file contents in Base64 format. [File]: Adds attached file as File.

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

For schemas this adapter uses, please refer to "Record schema".

Output Schema

None.

Loading schema in Mapper

Schema is loaded automatically.

Please refer to "Edit Schema" for any details.

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available Component variables

Component variable name	Description	Remarks
count	Returns the number of records added.	The value defaults to null.
message_category	Stroes the category to which corresponding message code belongs to, when an error occurs.	The value defaults to null.
message_code	Stores its corresponding message code of occured error.	The value defaults to null.
message_level	Stores the severity of the corresponding message code of the occured error.	The value defaults to null.
error_type	Stores the type of the occured error.	The value defaults to null. Error is represented in the format depicted below. Example:java.io.FileNotFoundException The message may vary depending on DataSpider Servista version.
error_message	Stores the error message for the occured error.	The value defaults to null. The message may vary depending on DataSpider Servista version.
error_trace	Stores stack trace of the occurred error.	The value defaults to null. The message may vary depending on DataSpider Servista version or the client application used.

About Add/Update

When updating a table with the writing process, check [Update records that match the value of the key] and select the field as key. Update the records that match the selected field as the key and add records that do not match.

Upsert

Multiple keys can be specified as update criteria.Records that match all the columns selected as keys are updated.

Specification Limits

When you write to the following fields on adding records, you must use a global resource to which a login ID with permission to manage application is set.
- Creator
- Modifier
- Created Time
- Updated Time

On updating records it doesn't update "Creator" and "Created Time". It updates "Modifier" by an user set in the global resource and "Updated Time" by date and time when the script is executed.
Field in which value is entered by lookup fields displays at [Field list], but value is cannot be written directly.
The variable which is entered by lookup fields is written automatically. Even if you specify a value directly, it will be ignored.

When update is performed, fields which can be specified as key is only as follows.
- Single Line Text
- Number
- Creator
- Modifier
When [Key] is specified as a field other than the above fields, an error occurs.
Also, even if the above fields is specified, it cannot be specified in [Key] if the field is sub table. An error occurs.

If you select [Data (Base64)] in [How to input attached file], and enter the larger sized data, OutOfMemoryError may occur. In that case, you can either select [File] and upload, or try to keep the maximum heap size of DataSpiderServer large.

Main exceptions

Exception name	Cause	Solution
InputDataNotFoundException	[Input data] is not specified.	Please specify [Input data], or draw a data flow.
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 selected in [Destination] is not found.	Check the global resource specified in [Destination].
InvalidPropertyConfigurationException <Property name> is not specified.	[<Property name>] is not specified.	Specify the [<Property name>].
InvalidPropertyConfigurationException Field type [<Field type>] cannot be specified in key.	Field type which is not available is spescified in [key].	Uncheck [Key].
InvalidPropertyConfigurationException Field of sub table cannot be specified in key.	Field of sub table is specified in [Key].	Uncheck [Key].
InvalidPropertyConfigurationException Field which is specified in key is required to be the object to write.	Field which is specified in [Key] is not specified in [Object to write].	Specify in [Object to write], or uncheck [Key].
KintoneResponseStatusException <Status code> <Status code content> <Error content>	Error occurred during the process in kintone.	According to the error message, please confirm the input value.
org.apache.http.client.ClientProtocolException	[Sub-domain name] is false.	Please check the [Sub-domain name]of [Destination].
java.lang.NumberFormatException	Values other than numeric values are input to the numeric value field.	Please input the numeric value.