kintone / Add or update record

Home > User guide > BOT > How to use the BOT editor > Extension > kintone > Add or update record

Index

1. App overview
2. Screen description
- 2.1. Input screen
- 2.2. Result screen
  - 2.2.1. The update is complete.

App overview

Updates if the record to be updated exists, and adds a new record if it does not exist.

Extended Feature URL	cbot-extension://cloud-bot:kintone:upsert-record:4
Provider	Extension : Cloud BOT official kintone : Cybozu, Inc.
External communication	Yes
Version	4

Screen description

Input screen

kintone app information settings

Domain name

Specify a domain name.

Example> c-bot.cybozu.com

App ID

Specify the app ID.

Example> 6

Guest space ID

Specify the guest space ID. If the specified application belongs to a guest space, it must be entered.

Example> 3

Authentication method

Select the authentication method.

Password authentication: Authenticate using your login name (user account) and password.
API Token Authentication: Authenticate using the app's API token.

* Click here for about API Token Generation.
* If multiple API tokens are used, specify them separated by commas. Click here for more information

Input fields settings

App name

The application name is displayed.

Input fields

Specify the fields of the record to be updated. The number of fields to be updated can be increased or decreased by clicking the Add and Delete buttons.
* Click here to learn more about field entry rules.

Table update mode

Specifies the update mode for the "Table" field.

・Overwrite: Deletes all existing lines and overwrites them with new lines.
・Append: Leave the existing lines as they are and append new lines.

Update record settings

Key field

Specify the field that serves as the key for the target record conditions.
* Click here for more information about key field.

Key value

Specify the value for the key field. Records matching this value will be updated.

Revision number (optional)

Specify the latest revision number of the record, as desired.
* Click here to learn more about revisions.

Value of each field

Enter a value for each field.

Result screen

The update is complete.

Results are displayed.

* How the corresponding record is processed depends on the field and key specified in the update condition. C lick here for more information.
* If an error occurs, further processing is aborted.

App name	The application name is displayed.
Number of addictions	The number of records added is displayed.
Number of updates	The number of records updated is displayed.
Number of additional errors	The number of failed record additional is displayed.
Number of update errors	The number of failed record updates is displayed.
Number of skips	The number of unprocessed cases interrupted by error handling is displayed.
Added record keys	The key of the added record is displayed.
Revision number of the added records	The revision numbers of the added records will be displayed.
Update record keys	The key of the updated record is displayed.
Revision number of the updated records	The revision numbers of the updated records will be displayed.
Key of the records that failed to add	The keys of the records that failed to add will be displayed.
Key of the records that failed to update	The keys of the records that failed to update will be displayed.
Error	When a record update fails, the error message is displayed.
Error details	Details of the error are displayed.