ActionSettingsEntities
Returns the detailed components that define each automation rule, helping you understand which fields, conditions, and targets are involved in an action's execution.
Select
WHERE 句ではAppId カラムが必須です。connector はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、connector はクライアント側でconnector 内で他のフィルタを処理します。
例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM ActionSettingsEntities WHERE AppId = 6 SELECT * FROM ActionSettingsEntities WHERE AppId = 6 AND Lang = 'en' SELECT * FROM ActionSettingsEntities WHERE AppId = 6 AND IsPreview = false
Columns
| Name | Type | References | Description |
| AppId | Integer | Identifier of the Kintone app whose action-entity assignments are being retrieved. | |
| Id | String | Unique identifier of the action, used to reference or update the specific automation rule. | |
| Code | String | Code of the entity allowed to use the action, with guest users represented by a login name preceded by guest/. | |
| Type | String | Type of entity permitted to use the action, such as a user, group, or department.
使用できる値は次のとおりです。USER, GROUP, ORGANIZATION | |
| Revision | String | Revision number of the app settings, helping track configuration changes over time. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description | |
| Lang | String | Locale code used to retrieve action-entity details in a specific language. | |
| IsPreview | Boolean | Indicates whether to retrieve action-entity details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |