Official |[kintone] Add Record

Operation name

Add Record

Function overview

Adds 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.
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.	If Update records with matching key is selected and Key isn't specified in Field list, an error occurs. For details, refer to Updating records with matching key.
Field list	Required	-	Specify fields.
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.
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 Field list, an error occurs. Note The field specified for Key must be selected for Target. For details, refer to Updating records with matching key.
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 added in Base64 format. File Add attachment as file.

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 added in Base64 format.

File

Add 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 records added 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.

Updating records with matching key

When updating with the Add Record operation, select Update record with matching key and select a field code for the key.

When the value of the field that has been selected as key matches, the record will be updated, and when it doesn't, the record will be added.

You can specify multiple keys as update conditions. Records whose values match all the fields selected as key will be updated.

Message codes, exception messages, and limitations

Connector	Message code	Exception message	Limitations
Messages and limitations of the kintone connector