Cloud BOT Docskintone / Add or update multiple records
Home > User guide > BOT > How to use the BOT editor > Extension > kintone > Add or update multiple records
App overview
Targets multiple records, 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-records: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.
* Table fields and non-supported fields are not displayed.
* Click here to learn more about field entry rules.
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 values
Specify the value for the key field. Records matching this value will be updated.
Filters (optional)
Records that match the filter will be processed. The number of filter conditions can be increased or decreased by clicking the Add and Delete buttons.
* Click here to learn more about filter condition.
* Click here for information on input rules for fields and operators.
Update record settings(Input data)
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. Click 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 filters | The number of filtered records is displayed. |
| Number of addiction errors | The number of failed record additions 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. |
| Total | The total of Number of updates, Number of update errors, Number of filters, and Number of skips 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. |
| Filtered record keys | The key of the filtered record is 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. |