Job Runner

Retrieve Records by Providing Conditions

Overview

Get the record matching the search condition from the specified app. Search conditions can be assembled on a screen similar to the Kintone refinement settings.

Usage

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

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

Parameter

Set 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 the search conditions to get the record.

Retrieve Records by Providing Conditions allows you to enter search conditions from a screen called Criteria Builder. You cannot enter a string called a query directly. If you want to search using Query, use Get Records by Query.

In queries assembled with the Criteria Builder, the ${expression} part automatically escapes the result of the expression at runtime, but not fixed Value parts that do not become ${expression}. For example, if you want a string field criteria to include Values with double quotes and backslashes in the Comparison value as a fixed value instead of a ${expression}, you have to enter the escaped Value yourself. See the Cybozu documentation for query escaping.

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”
“When All record Rows Are Ready”

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

関連記事