Write Table

Operation name

Write Table

Function overview

Writes the input data to Kintone table.

Data model

The data model of this component is table model 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.
Record ID	Required	Available	Specify the ID of the record to which the table belongs.
Table field code	Required	Available	Specify the field code of the table.
Update records with matching key	Optional	Not available	Select whether to update records whose key field value matches or to add all the records. Selected Update records whose key value matches. Records whose key value doesn't match are added. Not selected (Default) Add all records.	You can specify multiple keys as update conditions. Rows where all the columns selected as key match will be updated.
Table field list	Required	-	Specify the table fields.
Table field list/Target	Optional	Not available	Select whether or not to include each field in target to write. Selected Include in the target to write. Not selected (Default) Don't include in the target to write.	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.
Table field list/Key	Required	Not available	Select keys to be included as update conditions. Selected Include as update conditions. Not selected (Default) Don't include as update conditions.	Enabled when Update records with matching key is selected. If Update records with matching key is selected and Key isn't specified in Table field list, an error occurs. Note Fields in which multiple values can be set can't be specified as Key. For details, refer to Limitations of KINTONE category.
Table field list/Field name	Optional	Not available	Field name is displayed.
Table field list/Field code	Optional	Not available	Field code is displayed.
Table field list/Field type	Required	Not available	Field type is displayed.

Property actions

Item name	Description	Remarks
Get table list	Retrieve the table field codes from Kintone application and display them in Table field code.
Update field list	Retrieve the field information from the table specified in Table field code and set it to Table field list.

Write settings

Item name	Required/Optional	Use of variables	Description	Remarks
Position to insert the row	Required	Not available	When adding the input record, select whether to insert it at the bottom or top. Insert at the bottom (Default) Insert at the bottom. Insert at the top Insert at the top.

Item name

Required/Optional

Use of variables

Description

Remarks

Position to insert the row

Required

Not available

When adding the input record, select whether to insert it at the bottom or top.

Insert at the bottom

(Default)

Insert at the bottom.

Insert at the top

Insert at the top.

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 schema structure, refer to Table model type .

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 written data records is stored.	The default value is null.
insert_count	The number of inserted records of the written data is stored.	The default value is null.
update_count	The number of updated records of the written data 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