{"id":27251,"date":"2024-03-08T16:03:17","date_gmt":"2024-03-08T07:03:17","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=27251"},"modified":"2024-09-20T09:56:07","modified_gmt":"2024-09-20T00:56:07","slug":"retrieve_multiple_records","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/kintone_apps\/retrieve_multiple_records\/","title":{"rendered":"kintone \/ Retrieve multiple records"},"content":{"rendered":"\n

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

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

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

Retrieve multiple records from any app.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Extended Feature URL<\/td>cbot-extension:\/\/cloud-bot:kintone:get-records:2<\/td><\/tr>
Provider<\/td>Extension : Cloud BOT official<\/span>
kintone : Cybozu, Inc.<\/a><\/td><\/tr>
External communication<\/td>Yes<\/td><\/tr>
Version<\/td>2<\/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 setting<\/strong><\/strong><\/strong><\/strong>s<\/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

Field<\/strong><\/strong> retrieval setting<\/strong><\/strong>s<\/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

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

Specify the fields to retrieve. The number of fields to be retrieved can be increased or decreased by clicking the Add and Delete buttons.
\n* Click here<\/a> to learn more about field entry rules.<\/small><\/p>\n<\/div>\n<\/div>\n\n\n\n

Record<\/strong><\/strong> retrieval setting<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong>s<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

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

Specify the fields, conditionals, and values to be filtered.
* click here<\/a> to learn more about filters.\n
* Click here<\/a> for information on input rules for fields and operators.<\/small><\/p>\n\n\n\n

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

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

The retrieval<\/strong><\/strong><\/strong><\/strong> is complete.<\/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<\/div>\n<\/div>\n\n\n\n

<\/div>\n\n\n\n
App name<\/strong><\/strong><\/td>The application name is displayed.<\/td><\/tr>
Number of retrieval<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong>s<\/strong><\/strong><\/td>The number of records retrieved is displayed.<\/td><\/tr>
Error<\/strong><\/strong><\/strong><\/strong><\/td>When record retrieval fails, the error message is displayed.<\/td><\/tr>
Error Details<\/strong><\/strong><\/strong><\/strong><\/td>Details of the error are displayed.<\/td><\/tr>
Records<\/strong><\/strong><\/strong><\/td>The values of the retrieved fields are displayed in table format.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/div>\n\n\n\n

Additional information about filters<\/h3>\n\n\n\n

Records that match the filter will be processed. Filters can be increased or decreased by clicking the Add or Delete button.\n
\n* All specified conditions must match.<\/small>\n<\/p>\n\n\n\n

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

Field<\/strong><\/p>\n\n\n\n

Specify the fields.<\/p>\n\n\n\n

Operator<\/strong><\/p>\n\n\n\n

The following operators can be selected. The operators available depend on the field you specify.<\/p>\n\n\n\n

\u30fb= (equal to)
\u30fb\u2260 (not equal to)
\u30fb\u2264 (less than or equal to)
\u30fb< (less than)
\u30fb\u2265 (greater than or equal to)
\u30fb> (greater than)
\u30fbincludes any of
\u30fbdoes not include any of
\u30fbcontains
\u30fbdoes not contain<\/p>\n\n\n\n

See below.<\/p>\n\n\n\n

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

 <\/p>\n\n\n\n\n\n\n\n\n\n
Field<\/strong><\/th>\nequal to<\/th>\nnot equal to<\/th>\nless than or equal to<\/strong><\/th>\nless than<\/strong><\/th>\ngreater than or equal to<\/th>\ngrater than<\/strong><\/th>\nincludes any of<\/strong><\/th>\ndoes not include any of<\/strong><\/th>\ncontains<\/strong><\/th>\ndoes not contain<\/strong><\/th>\n<\/tr>\n
\u30fbRecord number<\/strong>
\u30fbRecord ID<\/strong>
\u30fbNumber<\/strong>
\u30fbCalculated<\/strong><\/td>\n		\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n <\/td>\n <\/td>\n<\/tr>\n
\u30fbCreated datetime<\/strong>
\u30fbUpdated datetime<\/strong>
\u30fbDate<\/strong>
\u30fbTime<\/strong>
\u30fbDate and time<\/strong><\/td>\n		\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n <\/td>\n <\/td>\n <\/td>\n <\/td>\n<\/tr>\n
\u30fbText<\/strong>
\u30fbLink<\/strong><\/td>\n		\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n <\/td>\n <\/td>\n <\/td>\n <\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n<\/tr>\n
\n

\u30fbCreated by<\/strong>
\u30fbUpdated by<\/strong>
\u30fbCheck box<\/strong>
\u30fbRadio button<\/strong>
\u30fbDrop-down<\/strong>
\u30fbMulti-choice<\/strong>
\u30fbUser selection(Login name)<\/strong>
\u30fbDepartment selection(Department code)<\/strong>
\u30fbGroup selection(Group code)
\u30fbStatus<\/strong><\/p>\n<\/td>\n

 <\/td>\n <\/td>\n <\/td>\n <\/td>\n <\/td>\n <\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n <\/td>\n <\/td>\n<\/tr>\n
\u30fbText area<\/strong>
\u30fbRich text
\u30fbAttachment<\/strong><\/td>\n		 <\/td>\n <\/td>\n <\/td>\n <\/td>\n <\/td>\n <\/td>\n <\/td>\n <\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n<\/tr>\n
\u30fbLookup<\/strong><\/td>\n* The operator used as the field type of the lookup source remains the same. Click here<\/a> to learn more about lookup fields.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<\/div>\n<\/div>\n\n\n\n

* On the kintone side, it is necessary to enable Worker , Status and Category.
\n* Related records, Field group\n, and Category do not appear in the conditional settings.
\nIf you select \u201cdoes not contain\u201d for a field in the table, the table will not be subject to data retrieval if the table has zero rows.<\/small><\/p>\n\n\n\n

If you select a field in a table, different operators are available for different fields.
See below.<\/p>\n\n\n\n

\n
\n
\n

\u00a0<\/p>\n\n\n\n\n\n\n\n\n
Field<\/strong><\/th>\nequal to<\/th>\nnot equal to<\/th>\nless than or equal to<\/strong><\/th>\nless than<\/strong><\/th>\ngreater than or equal to<\/th>\ngrater than<\/strong><\/th>\nincludes any of<\/strong><\/th>\ndoes not include any of<\/strong><\/th>\ncontains<\/strong><\/th>\ndoes not contain<\/strong><\/th>\n<\/tr>\n
\n

\u30fbNumber<\/strong>
\u30fbCalculated
\u30fbDate
\u30fbTime
\u30fbDate and time<\/strong><\/p>\n<\/td>\n

\u00a0<\/td>\n\u00a0<\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u30fbText<\/strong>
\u30fbLink<\/strong><\/td>\n		\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n<\/tr>\n
\n

\u30fbRadio button
\u30fbMulti-choice
\u30fbCheck box
\u30fbDrop-down
\u30fbUser selection(Login name)<\/strong>
\u30fbDepartment selection(Department code)<\/strong>
\u30fbGroup selection(Group code)
<\/strong><\/p>\n<\/td>\n

\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u30fbText area<\/strong>
\u30fbRich text
\u30fbAttachment<\/strong><\/td>\n		\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n\u25cf<\/strong><\/span><\/td>\n\u25cf<\/strong><\/span><\/td>\n<\/tr>\n
\u30fbLookup<\/strong><\/td>\n* The operator used as the field type of the lookup source remains the same. Click here<\/a> to learn more about lookup fields.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<\/div>\n<\/div>\n\n\n\n

value<\/strong><\/p>\n\n\n\n

Specify a value.<\/p>\n\n\n\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

 Home > User guide > BOT > How to use the BOT editor > Extension > kintone > Retrieve multiple records App overview Retrieve multiple records from any app. Extended Feature URL cbot-extension:\/\/cloud-bot:kintone:get-records:2 Provider Extension : Cloud BOT officialkintone : Cybozu, Inc. External communication Yes Version 2 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 Field retrieval settings App name The application name is displayed. Retrieval fields Specify the fields to retrieve. The number of fields to be retrieved can be increased or decreased by clicking the Add and Delete buttons. * Click here to learn more about field entry rules. Record retrieval settings Filters(optional) Specify the fields, conditionals, and values […]<\/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=26948","footnotes":""},"categories":[123],"tags":[68,53,59,57],"class_list":["post-27251","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\/27251","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=27251"}],"version-history":[{"count":9,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/27251\/revisions"}],"predecessor-version":[{"id":30859,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/27251\/revisions\/30859"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=27251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=27251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=27251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}