Job Runner

Retrieve Records by Providing Conditions in Query

Overview

Retrieve records from the specified app by providing a key.

Usage

Place the action to set the Kintone connection settings before the action to Retrieve Records by Providing Conditions in Query.

You can use the result of the calculation in other Actions.

Parameter

Set the App API Token, Search Condition, and Limit.

app

Select which app you want to get the records from.

API Token setting

Specify the API Token to access the app from. Choose from the Set Kintone API Token action.

The API Token must have view record permission.

Search Condition

Enter search conditions (queries) for getting the record. Enter the information of the query parameter of the Kintone API as it is.

Please refer to the official Cybozu documentation for notation for search conditions (queries).

Example:

String_0 = "${Test}"

You can also embed the result values of fields and actions in the query using Customine expressions. An expression can be of the form ${expression} . If the result Value of ${expression} contains a double quote ' ' and a backslash ' \ ' ‘, then the escaped result is returned. If you do not want to escape, please use Retrieve Records By Condition without Escape. For more information about escaping, please refer to the section “Escape handling of double quotes and backslashes” in the Cybozu official documentation above.

Example:

String_0 = "${Text_1}"

Limit

Setting this parameter limits the number of records to be got if many records match the key. If this parameter value is omitted, all records matching the key are retrieved.

If there are many records that match, it takes time to get them all. In such cases, a smaller value for this parameter can shorten the processing time.

Specifying zero or less causes an error.

Occurrence of record Retrieval Criteria

Criteria Occurrence
“When record Row Is Ready” It happens.
“When All record Rows Are Ready” It happens.

* Not raised if no record exists that matches the Criteria.

Restrictions

  • The standard Kintone search condition can limit the number of records by adding a limit, such as limit 10, but this syntax is not available for the search condition in getting records by query. Use the limit parameter instead.

関連記事