Add Record

Operation Name

Add Record

Function Overview

Add kintone records.

Data Model

XML type.

Properties

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 the name to show 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 global resource. For details about how to configure global resource, refer to “Global Resource Properties”. [Add]: Add a new global resource. [Edit list]: Global resource settings can be edited in “Edit resource list” screen.
Update records with matching key	Optional	Not available	Select whether to update records of which the field value specified as key matches or to add all records. [Checked]: Update records of which the key matches. Records of which the key does not match are added. [Not checked]: (default) Add all records.	If [Update records with matching key] is checked and [Key] is not specified in [Field list], an error occurs. Refer to “Updating Records with Matching Key” for more details.
Field list	Required	-	Specify fields.
Field list/Target	Optional	Not available	Select whether or not to include each field in targets. [Checked]: Include in targets. [Not checked]: (default) Do not include in targets.	One or more columns should be checked. The checked column names will be displayed in Mapper schema. Batch operation can be performed by clicking the checkbox displayed in the header.
Field list/Key	Required	Not available	Select keys to be included in update conditions. [Checked]: Include in update conditions. [Not checked]: (default) Doe not include in update conditions.	Enabled when [Update records with matching key] is checked. If [Update records with matching key] is checked and [Key] is not specified in [Field list], an error occurs. You need to check [Target] if the field is [Key]. Refer to “Updating Records with Matching Key” for more details.
Field list/Field name	Optional	Not available	Field name is displayed.
Field list/Field code	Optional	Not available	Field code is displayed.
Field list/Field type	Optional	Not available	Field type is displayed.
Field list/Subtable	Optional	Not available	When a field is included in subtable, the field code of the subtable is displayed.

Property actions

Item name	Description	Remarks
Update field list	Get field information from the kintone application and set it to [Field list].

Attachment

Item name	Required/Optional	Use of variables	Description	Remarks
Input method for attachment	Optional	Not available	Select input method for attachment. [Data (Base64)]: (default) Input contents of the file to be added in Base 64 format. [File]: Add attachment 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 more details on schema used by this adapter, refer to “Record Schema”.

Output schema

None.

Loading schema in Mapper

Schema is loaded automatically.

For more 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	The number of records added is stored.	Default value is null.
message_category	When an error occurs, the corresponding message code's category is stored.	Default value is null.
message_code	When an error occurs, the corresponding message code is stored.	Default value is null.
message_level	When an error occurs, the corresponding message code's severity is stored.	Default value is null.
error_type	When an error occurs, the error type is stored.	Default value is null. The error type will be in the following format. Example: “java.io.FileNotFoundException” The contents that will be stored may vary depending on DataSpider Servista versions.
error_message	When an error occurs, the error message is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions.
error_trace	When an error occurs, the error's trace information is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions and client applications.

Update Records with Matching Key

When updating with Add Record operation, put a check in [Update record with matching key] and select [Field code] for the key. Records of which the value of the field selected as key matches will be updated and records not matching will be added.

Upsert

You can specify multiple keys for update conditions. Records of which the value of all the fields selected as key match will be updated.

Specification Limits

When adding records and writing value to the following fields, you need to use a global resource with login ID of a user who has administrative right for the App.
- Creator
- Modifier
- Created time
- Updated time

While updating records, "Creator" and "Created time" will not be updated, whereas "Modifier" and "Updated time" will be updated with the user set in the global resource and the date and time at the time of script execution.

Although fields whose values are input by lookup field will be displayed in [Field list], value cannot be written in the fields directly.
Automatically written with the value input by lookup field. Even if the value is specified directly, the value is ignored.

When updating, only the following fields can be specified as key.
- String (one line)
- Numeric value
- Creator
- Modifier
If [Key] is checked in the field other than the mentioned above, an error occurs.
Further, even in the above mentioned fields, if it is a subtable field, it cannot be specified as [Key]. In that case, also an error occurs.

When [Data (Base64)] is selected in [Input method for attachment] and if the input data size is large, OutOfMemoryError could occur. In such case, select [File] and upload from it, or ensure the maximum heap size of DataSpiderServer on a large scale.

Major Exceptions

Exception name	Cause	Solution
InputDataNotFoundException	[Input data] is not specified.	Specify [Input data] or draw data flow.
ResourceNotFoundException Resource definition is not found. Name: []	[Destination] is not specified.	Specify [Destination].
ResourceNotFoundException Resource definition is not found. Name: [<global resource name>]	The resource definition specified in [Destination] is not found.	Check the global resource specified in [Destination].
InvalidPropertyConfigurationException <property name> is not specified.	[<property name>] is not specified.	Specify [<property name>].
InvalidPropertyConfigurationException Field type [<field type>] cannot be specified as key.	An invalid field type is specified as [Key].	Remove the check from [Key].
InvalidPropertyConfigurationException Field of subtable cannot be specified as key.	Field of subtable is specified as [Key].	Remove the check from [Key].
InvalidPropertyConfigurationException Set the field for key as target.	Field specified as [Key] is not specified as [Target].	Specify it as [Target] or remove the check from [Key]
KintoneResponseStatusException <status code><contents of status code> <contents of error>	An error occurred during kintone processing.	Check the settings and the input value according to the error message.
org.apache.http.client.ClientProtocolException	[Subdomain name] is invalid.	Check [Subdomain name] of [Destination].
java.lang.NumberFormatException	Non-numerical value is input in numerical field.	Input numerical value.