Update Record

Operation Name

Update Record

Update kintone records.

XML type.

For details on use of variables, refer to “Variables”.

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.

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.
Field list	Required	-	Specify fields.	$id field will be the key for record to be updated. Hence, even if [Target] is not checked, it is displayed in schema.
Field list/Target	Optional	Not available	Select whether or not to include each field in target. [Checked]: Include in target. [Not checked]: (default) Do not include in target.	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/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.

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

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 updated in Base 64 format. [File]: Update attachment as file.

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.

For more details on schema used by this adapter, refer to “Record Schema”.

None.

Schema is loaded automatically.

For more details, refer to “Edit Schema”.

Transaction is not supported.

PSP is not supported.

Component variable name	Description	Remarks
count	The number of updated records 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.

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

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.

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>].
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.