Official |[kintone] Read Table

Operation name

Read Table

Function overview

Reads 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.

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.
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 read. Selected Include in the target to read. Not selected (Default) Don't include in the target to read.	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/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.

Attachment

Item name	Required/Optional	Use of variables	Description	Remarks
Download and get the file path	Optional	Not available	Specify whether to download the attachment and get the file path or not. Selected Download the attachment and get the file path. Not selected (Default) Don't download the attachment.
Download directory	Required	Available	Select or enter the directory to download attachments. The Browse button launches a directory chooser that allows you to select a directory. The paths of the downloaded attachments will be Download directory/<record ID>/<field code>/<file key>/<attached file name>.	Enabled when Download and get the file path is selected. Note Specify an absolute path of HULFT Square Storage for the file path. With the exception of the path separator "/", the Restricted characters of HULFT Square Storage can't be used.

Item name

Required/Optional

Use of variables

Description

Remarks

Download and get the file path

Optional

Not available

Specify whether to download the attachment and get the file path or not.

Selected

Download the attachment and get the file path.

Not selected

(Default)

Don't download the attachment.

Download directory

Required

Available

Select or enter the directory to download attachments.

The Browse button launches a directory chooser that allows you to select a directory.

The paths of the downloaded attachments will be Download directory/<record ID>/<field code>/<file key>/<attached file name>.

Enabled when Download and get the file path is selected.

Note

Specify an absolute path of HULFT Square Storage for the file path.
With the exception of the path separator "/", the Restricted characters of HULFT Square Storage can't be used.

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

None.

Output schema

= Remarks =

For schema structure, refer to Table model type .

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name	Description	Remarks
count	The number of read 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