Job Runner

Retrieve Records by Providing Conditions in Query (No Escaping)

Overview

Retrieve records from the specified app by providing query.

Usage

Place the action to set the Kintone connection settings before the action 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) to get 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:

Text_0 = "Test"

You can also embed the result values of fields and actions in the query using Customine expressions. In this case, the expression result Value is not escaped as a Kintone query. If you need to escape, use Query to Get records. 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 = "${String_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 matching records, it takes time to get them all. A smaller value for this parameter can shorten the processing time in such cases.

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.

関連記事