Messages and limitations of the kintone connector

Message code list of KINTONE category

The following message codes correspond to errors that occur in kintone Connector.

 

KINTONE0000E

This message code is output when an undefined error occurs.

Cause

Solution

An undefined error occurred.

Check the error message or the help of the operation in which the error has occurred.

Corresponding error

  • None

 

KINTONE0001E

This message code corresponds to errors that occur during Kintone processing.

Cause

Solution

The cause differs according to each error message.

Check whether the cause/solution of the error is described in "Exception messages" below.

Corresponding error

  • KintoneResponseStatusException

 

KINTONE0002E

This message code is output when a connection to Kintone can't be established.

Cause

Solution

The subdomain name is invalid.

Check Subdomain name in the connection resource settings.

Corresponding error

  • org.apache.http.client.ClientProtocolException

 

KINTONE0003E

This message code is output when a required parameter of input data isn't specified for an API call.

Cause

Solution

A required parameter of <input data> isn't specified.

Specify a required parameter of <input data>.

Corresponding error

  • RequestParameterRequiredException

 

Exception messages of KINTONE category

Exception name

Cause

Solution

InputDataNotFoundException

Input data isn't specified.

Specify Input data or draw data flow.

InvalidPropertyConfigurationException

<Property name> is not specified.

<Property name> isn't specified.

Specify <property name>.

InvalidPropertyConfigurationException

Set the field for key as target.

The field specified as Key isn't specified for Target.

Specify it for Target or clear the checkbox for Key.

InvalidPropertyConfigurationException

Field of subtable cannot be specified as key.

A field of subtable is specified as Key.

Clear the checkbox for Key.

InvalidPropertyConfigurationException

Field type [<field type>] cannot be specified as key.

An invalid field type is specified as Key.

Clear the checkbox for Key.

java.lang.NumberFormatException

A non-numerical value is input in numerical field.

Input a numerical value.

java.lang.NumberFormatException

A non-numerical value is input in numerical type field.

Input a numerical value.

KintoneResponseStatusException

<status code><contents of status code>

<contents of error>

An error occurred during Kintone processing.

Check the settings according to the error message.

KintoneResponseStatusException

<status code><contents of status code>

<contents of error>

An error occurred during Kintone processing.

Check the settings and the input value according to the error message.

org.apache.http.client.ClientProtocolException

Subdomain name is invalid.

Check Subdomain name of Destination.

RequestParameterRequiredException

Required parameter of <input data> is not specified.

A required parameter of <input data> isn't specified.

Specify a required parameter of <input data>.

ResourceNotFoundException

Resource definition could not be found. Name: []

Destination isn't specified.

Specify Destination.

ResourceNotFoundException

Resource definition could not be found. Name: [<connection resource name>]

The resource definition specified in Destination isn't found.

Check the connection resource specified in Destination.

 

Limitations of KINTONE category

Operation environment

Notes

  • The behavior described in the help pages is subject to change depending on specification changes in the destination.

Get Record

Specification limits

  • With Update field list, lookup type fields will be displayed in Field type as the types in the reference destination.

  • The following fields are displayed in Field list even if they aren't used in a form of the Kintone app.

    • Record number

    • Creator

    • Modifier

    • Created time

    • Updated time

Add Record

Specification limits

  • When adding records and writing values to the following fields, you need to use a connection resource with login ID of a user who has administrative right for the app.

    • Creator

    • Modifier

    • Created time

    • Updated time

  • When updating records, "Creator" and "Created time" won't be updated, whereas "Modifier" and "Updated time" will be updated with the user set in the connection resource and the date and time of script execution.

  • Although fields whose values are input by the lookup field will be displayed in Field list, values can't be written in the fields directly.

    Values that are input by the lookup field are automatically written. Even if the value is specified directly, the value is ignored.

  • When updating, only the following fields can be specified as key:

    • String (one line)

    • Numeric value

    • Creator

    • Modifier

    If a field other than the above is specified as Key, an error occurs.

    Even for the above fields, if it's a subtable field, it can't be specified as Key. In that case, an error also occurs.

  • When Data (Base64) is selected in Input method for attachment and if the input data size is large, OutOfMemoryError may occur. In such case, select File and upload it as a file.

Update Record

Specification limits

  • Although fields whose values are input by the lookup field will be displayed in Field list, the values can't be updated directly.

    The values are automatically updated with the values input by the lookup field. Even if the value is specified directly, the value is ignored.

  • When Data (Base64) is selected in Input method for attachment and if the input data size is large, OutOfMemoryError may occur. In such case, select File and upload it as a file.

Delete Record

Specification limits

None.

Read Table

Specification limits

  • When multiple values are set in the following fields, the values will be delimited by commas and retrieved.

    • Check box

    • Multiple selection

    • Attachment

    • User selection

    • Department selection

    • Group selection

  • User selection will be retrieved in the "<Login name>:<Display name>" format.

  • Department selection will be retrieved in the "<Department code>:<Department name>" format.

  • Group selection will be retrieved in the "<Group code>:<Group name>" format.

Write Table

Specification limits

  • When inputting multiple values in the following fields, enter multiple values delimited by commas.

    If a value that contains a comma is written, the comma needs to be enclosed with double quotation marks.

    • Check box

    • Multiple selection

    • Attachment

    • User selection

    • Department selection

    • Group selection

  • The following fields in which multiple values can be set can't be specified as Key. If specified, an error occurs.

    • Check box

    • Multiple selection

    • Attachment

    • User selection

    • Department selection

    • Group selection

  • The input data for the following fields will be ignored, and the values set in Kintone will be written.

    • Table row ID

    • Calculation

Notes

  • When a value is written to the attachment field, you need to specify the absolute path of HULFT Square Storage in the column of the attachment field.

Delete Table Data

Specification limits

  • The following fields in which multiple values can be set can't be specified as Key. If specified, an error occurs.

    • Check box

    • Multiple selection

    • Attachment

    • User selection

    • Department selection

    • Group selection

Call API

Specification limits

  • You can't upload an image in Batch Add Guest Users of API type.