Update Record

Operation Name

Update Record

Function Overview

Update 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".
 
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.  
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 updating file contents with Base64 format.
  • [File]:
    Updates 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 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.

Specification Limits

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