Update Record

Operation name

Update Record

Function overview

Updates Kintone records.

Data model

The data model of this component is XML type.

Properties

= Remarks =

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 a name that is used 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 connection resource.

Add

A new connection resource can be added.

Edit list

Connection resource settings can be edited in > HULFT INTEGRATE > Connections.

 

Field list

Required

-

Specify fields.

  • $id field will be the key for record to be updated. Hence, even if it's not selected for Target, it's displayed in the schema.

Field list/Target

Optional

Not available

Select whether or not to include each field in target to update.

Selected

Include in target to update.

Not selected

(Default)

Don't include in target to update.

  • The selected column names will be displayed in Mapper schema.

  • You can operate all checkboxes at once by clicking the checkbox displayed in the header.

Note

One or more columns must be selected.

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 an input method for attachment.

Data (Base64)

(Default)

Input contents of the file to be updated in Base64 format.

File

Update 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 connector.

 

Schemas

Input schema

= Remarks =

For more details on schema used by this connector, refer to Record schema.

Output schema

None.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Transaction

Transaction isn't supported.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name

Description

Remarks

count

The number of updated records is stored.

  • The default value is null.

message_category

When an error occurs, the category of the message code corresponding to the error is stored.

  • The default value is null.

message_code

When an error occurs, the code of the message code corresponding to the error is stored.

  • The default value is null.

message_level

When an error occurs, the severity of the message code corresponding to the error is stored.

  • The default value is null.

error_type

When an error occurs, the error type is stored.

  • The default value is null.

  • The format of the error type is as follows.

    Example: java.io.FileNotFoundException

error_message

When an error occurs, the error message is stored.

  • The default value is null.

error_trace

When an error occurs, the trace information for the error is stored.

  • The default value is null.

Message codes, exception messages, and limitations

Connector

Message code

Exception message

Limitations

Messages and limitations of the kintone connector

check

check

check