Delete Table Data

Operation Name

Delete Table Data

Function Overview

Deletes the data stored in kintone table.

Data Model

Table model type.

Properties

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 the name to show 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 global resource. For details on global resource setting, refer to “Global Resource Properties”. [Add]: Add a new global resource. [Edit list]: Global resource settings can be edited in “Edit resource list” screen.
Record ID	Required	Available	Specify the ID of the record of which the table belongs to.
Table field code	Required	Available	Specify the field code of the table.
Delete all the data of the table	Optional	Not available	Set whether or not to delete all data. [Checked]: All data will be deleted. [Not checked]: (default) Deletes the record matching to the value specified in [Key] of [Table field list].	You can specify multiple keys for delete conditions. Deletes the rows of which all the key columns match.
Table field list	Required	-	Specify the table field.	Enabled when [Delete all the data of the table] is checked.
Table field list/Key	Required	Not available	Select keys to be included in delete conditions. [Checked]: Include in delete conditions. [Not checked]: (default) Do not include in delete conditions.	When [Delete all the data of the table] is checked, and [Key] is not specified in [Table field list], an error will occurs. Fields in which multiple values can be set cannot be specified as [Key]. Refer to “Specification Limits” for more details.
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	Retrieves the table field code from kintone application and displays it in [Table field code].
Update field list	Retrieves the field information from the table specified in [Table field code] and sets 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 adapter. The description will be reflected in the specifications.

Schema

Input schema

Refer to “Schema of table model type” for more details.

Output schema

None.

Loading schema in Mapper

Schema is loaded automatically.

Refer to “Edit Schema” for more details.

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available Component Variables

Component variable name	Description	Remarks
count	The number of deleted data is stored.	Default value is null.
message_category	When an error occurs, the corresponding message code's category is stored.	Default value is null.
message_category	When an error occurs, the corresponding message code's category is stored.	Default value is null.
message_code	When an error occurs, the corresponding message code is stored.	Default value is null.
message_level	When an error occurs, the corresponding message code's severity is stored.	Default value is null.
error_type	When an error occurs, the error type is stored.	Default value is null. The error type will be in the following format. Example: “java.io.FileNotFoundException” The contents that will be stored may vary depending on DataSpider Servista versions.
error_message	When an error occurs, the error message is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions.
error_trace	When an error occurs, the error's trace information is stored.	Default value is null. The contents that will be stored may vary depending on DataSpider Servista versions and client applications.

Specification Limits

The following fields in which multiple values can be set cannot be specified as [Key].
- Check box
- Multiple selection
- Attachment
- User selection
- Department selection
- Group selection

Major Exceptions

Exception name	Cause	Solution
ResourceNotFoundException Resource definition is not found. Name: []	[Destination] is not specified.	Specify [Destination].
ResourceNotFoundException Resource definition is not found. Name: [<global resource name>]	The resource definition specified in [Destination] is not found.	Check the global resource specified in [Destination].
InvalidPropertyConfigurationException <property name> is not specified.	[<property name>] is not specified.	Specify [<property name>].
KintoneResponseStatusException <status code><contents of status code> <contents of error>	An error occurred during kintone processing.	Check the settings according to the error message.
org.apache.http.client.ClientProtocolException	[Subdomain name] is invalid.	Check [Subdomain name] of [Destination].