Update Record

Operation Name

Update Record

Update the record of kintone.

Data model of this component is XML type.

For information about using 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 the component on the script canvas.

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".
Field list	Required	-	Specify field.	$id field will be the key for updating record. Therefore, although you take out the check from [Updating target], it will still be shown in the schema.
Field list/ Updating target	Optional	Not available	Select whether to include each field as the updating target. [Checked]: Includes as updating target. [Not checked]:(default) Does not include as updating 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/ 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.

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.

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 updating file contents with Base64 format. [File]: Updates attached file 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 schemas this adapter uses, please refer to "Record schema".

None.

Schema is loaded automatically.

Please refer to "Edit Schema" for any details.

Transaction is not supported.

PSP is not supported.

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

Fields to which lookup fields enter values are shown in [Field list], but you can't update the values directly.
They are updated by values which lookup fields enter. If you specify the values directly, they'll be ignored.

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.

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