Official |[kintone] Delete Table Data

Operation name

Delete Table Data

Function overview

Deletes the data stored in 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	Optional	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.
Delete all the data of the table	Optional	Not available	Select whether or not to delete all data. Selected All data will be deleted. Not selected (Default) Delete the record matching to the value specified in Key of Table field list matches.	You can specify multiple keys as delete conditions. Rows where all the columns selected as key match will be deleted
Table field list	Required	-	Specify the table fields.	Enabled when Delete all the data of the table is selected.
Table field list/Key	Required	Not available	Select keys to be included as delete conditions. Selected Include as delete conditions. Not selected (Default) Don't include as delete conditions.	If Delete all the data of the table is selected and Key isn't specified in Table field list, an error will 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.

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 deleted data 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