kintone / Retrieve multiple records

Home > User guide > BOT > How to use the BOT editor > Extension > kintone > Retrieve multiple records

Index

1. App overview
2. Screen description

App overview

Retrieve multiple records from any app.

Extended Feature URL	cbot-extension://cloud-bot:kintone:get-records:2
Provider	Extension : Cloud BOT official kintone : 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 to be filtered.
* click here to learn more about filters.
* Click here for information on input rules for fields and operators.

Result screen

The retrieval is complete.

Results are displayed.

App name	The application name is displayed.
Number of retrievals	The number of records retrieved is displayed.
Error	When record retrieval fails, the error message is displayed.
Error Details	Details of the error are displayed.
Records	The values of the retrieved fields are displayed in table format.

Additional information about filters

Records that match the filter will be processed. Filters can be increased or decreased by clicking the Add or Delete button.
* All specified conditions must match.

Field

Specify the fields.

Operator

The following operators can be selected. The operators available depend on the field you specify.

・= (equal to)
・≠ (not equal to)
・≤ (less than or equal to)
・< (less than)
・≥ (greater than or equal to)
・> (greater than)
・includes any of
・does not include any of
・contains
・does not contain

See below.

Field	equal to	not equal to	less than or equal to	less than	greater than or equal to	grater than	includes any of	does not include any of	contains	does not contain
・Record number ・Record ID ・Number ・Calculated	●	●	●	●	●	●	●	●
・Created datetime ・Updated datetime ・Date ・Time ・Date and time	●	●	●	●	●	●
・Text ・Link	●	●					●	●	●	●
・Created by ・Updated by ・Check box ・Radio button ・Drop-down ・Multi-choice ・User selection(Login name) ・Department selection(Department code) ・Group selection(Group code) ・Status							●	●
・Text area ・Rich text ・Attachment									●	●
・Lookup	* The operator used as the field type of the lookup source remains the same. Click here to learn more about lookup fields.

* On the kintone side, it is necessary to enable Worker , Status and Category.
* Related records, Field group , and Category do not appear in the conditional settings.
If you select “does not contain” for a field in the table, the table will not be subject to data retrieval if the table has zero rows.

If you select a field in a table, different operators are available for different fields.
See below.

Field	equal to	less than or equal to	less than	greater than or equal to	grater than	includes any of	does not include any of	contains	does not contain
・Number ・Calculated ・Date ・Time ・Date and time		●	●	●	●	●	●
・Text ・Link						●	●	●	●
・Radio button ・Multi-choice ・Check box ・Drop-down ・User selection(Login name) ・Department selection(Department code) ・Group selection(Group code)						●	●
・Text area ・Rich text ・Attachment								●	●
・Lookup	* The operator used as the field type of the lookup source remains the same. Click here to learn more about lookup fields.

value

Specify a value.