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
The AppId column is required in the WHERE clause. The cmdlet will use the Kintone APIs to filter the results by this column. By default, the cmdlet will process other filters client-side within the cmdlet.
For example, the following queries are processed server side:
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.
The allowed values are USER, GROUP, ORGANIZATION. | |
| Revision | String | Revision number of the app settings, helping track configuration changes over time. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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'. |