{"id":27272,"date":"2024-03-11T11:41:04","date_gmt":"2024-03-11T02:41:04","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=27272"},"modified":"2024-09-20T10:11:48","modified_gmt":"2024-09-20T01:11:48","slug":"app_or_update_multiple_records","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/kintone_apps\/app_or_update_multiple_records\/","title":{"rendered":"kintone \/ Add or update multiple records"},"content":{"rendered":"\n

<\/i> Home<\/a> > User guide<\/a> > BOT<\/a> > How to use the BOT editor<\/a> > Extension<\/a> > kintone<\/a> > Add or update multiple records<\/p>\n\n\n\n

<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

App overview<\/h2>\n\n\n\n

Targets multiple records, updates if the record to be updated exists, and adds a new record if it does not exist.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Extended Feature URL<\/td>cbot-extension:\/\/cloud-bot:kintone:upsert-records:4<\/td><\/tr>
Provider<\/td>Extension : Cloud BOT official<\/span>
kintone : Cybozu, Inc.<\/a><\/td><\/tr>
External communication<\/td>Yes<\/td><\/tr>
Version<\/td>4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Screen description<\/h2>\n\n\n\n

Input screen<\/h3>\n\n\n\n

kintone app information settings<\/strong><\/strong><\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Domain name<\/strong><\/strong><\/p>\n\n\n\n

Specify a domain name.<\/p>\n\n\n\n

Example> c-bot.cybozu.com <\/small><\/p>\n\n\n\n

App ID<\/strong><\/strong><\/strong><\/p>\n\n\n\n

Specify the app ID.<\/p>\n\n\n\n

Example> 6 <\/small><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Guest space ID<\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Specify the guest space ID. If the specified application belongs to a guest space, it must be entered.<\/p>\n\n\n\n

Example> 3 <\/small><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Authentication method<\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Select the authentication method.<\/p>\n\n\n\n

Password authentication: Authenticate using your login name (user account) and password.
\nAPI Token Authentication: Authenticate using the app's API token.<\/p>\n\n\n\n

* Click here<\/a> for about API Token Generation.
* If multiple API tokens are used, specify them separated by commas. Click here<\/a> for more information<\/small><\/p>\n<\/div>\n<\/div>\n\n\n\n

Input fields settings<\/strong><\/strong><\/strong><\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

App name<\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

The application name is displayed.<\/p>\n\n\n\n

Input fields<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

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.
\n* Click here<\/a> to learn more about field entry rules.<\/small><\/p>\n\n\n\n

<\/p>\n<\/div>\n<\/div>\n\n\n\n

Update record settings<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Key field<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Specify the field that serves as the key for the target record conditions.
* Click here<\/a> <\/small>for more information about key field.<\/p>\n\n\n\n

Key valu<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong>es<\/strong><\/p>\n\n\n\n

Specify the value for the key field. Records matching this value will be updated.<\/p>\n\n\n\n

Filters (optional)<\/strong><\/p>\n\n\n\n

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<\/a> to learn more about filter condition.
* Click here<\/a> for information on input rules for fields and operators.<\/small><\/p>\n<\/div>\n<\/div>\n\n\n\n

Update record settings(Input data)<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Value of each field<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/p>\n\n\n\n

Enter a value for each field.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Result screen<\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n

The update is complete.<\/strong><\/strong><\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Results are displayed.<\/p>\n\n\n\n

* How the corresponding record is processed depends on the field and key specified in the update condition. Click here<\/a> for more information.
* If an error occurs, further processing is aborted.<\/small><\/p>\n<\/div>\n<\/div>\n\n\n\n

<\/div>\n\n\n\n
App name<\/strong><\/td>The application name is displayed.<\/td><\/tr>
Number of addictions<\/strong><\/strong><\/strong><\/td>The number of records added is displayed.<\/td><\/tr>
Number of updates<\/strong><\/td>The number of records updated is displayed.<\/td><\/tr>
Number of filters<\/strong><\/td>The number of filtered records is displayed.<\/td><\/tr>
Number of addiction errors<\/strong><\/td>The number of failed record additions is displayed.<\/td><\/tr>
Number of update errors<\/strong><\/strong><\/strong><\/td>The number of failed record updates is displayed.<\/td><\/tr>
Number of skips<\/strong><\/strong><\/td>The number of unprocessed cases interrupted by error handling is displayed.<\/td><\/tr>
Total<\/strong><\/td>The total of Number of updates, Number of update errors, Number of filters, and Number of skips is displayed.<\/td><\/tr>
Added record keys<\/strong><\/td>The key of the added record is displayed.<\/td><\/tr>
Revision number of the added records<\/strong><\/td>The revision numbers of the added records will be displayed.<\/td><\/tr>
Update record keys<\/strong><\/td>The key of the updated record is displayed.<\/td><\/tr>
Revision number of the updated records<\/strong><\/td>The revision numbers of the updated records will be displayed.<\/td><\/tr>
Filtered record keys<\/strong><\/td>The key of the filtered record is displayed.<\/td><\/tr>
Key of the records that failed to add<\/strong><\/strong><\/td>The keys of the records that failed to add will be displayed.<\/td><\/tr>
Key of the records that failed to update<\/strong><\/td>The keys of the records that failed to update will be displayed.<\/td><\/tr>
Error<\/strong><\/td>When a record update fails, the error message is displayed.<\/td><\/tr>
Error details<\/strong><\/td>Details of the error are displayed.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n","protected":false},"excerpt":{"rendered":"

 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 officialkintone : 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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_locale":"en_US","_original_post":"https:\/\/docs.c-bot.pro\/?p=27052","footnotes":""},"categories":[123],"tags":[68,53,59,57],"class_list":["post-27272","post","type-post","status-publish","format-standard","hentry","category-kintone_apps","tag-bot","tag-kintone","tag-59","tag-57","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/27272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/comments?post=27272"}],"version-history":[{"count":11,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/27272\/revisions"}],"predecessor-version":[{"id":30877,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/27272\/revisions\/30877"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=27272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=27272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=27272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}