ActionSettingsMappings
Lists the field-to-field mappings used by automation rules so you can trace exactly how data moves between apps when an action is triggered.
Select
The AppId column is required in the WHERE clause. The connector will use the Kintone APIs to filter the results by this column. By default, the connector will process other filters client-side within the connector.
For example, the following queries are processed server side:
SELECT * FROM ActionSettingsMappings WHERE AppId = 6 SELECT * FROM ActionSettingsMappings WHERE AppId = 6 AND Lang = 'en' SELECT * FROM ActionSettingsMappings WHERE AppId = 6 AND IsPreview = false
Columns
| Name | Type | References | Description |
| AppId | Integer | Identifier of the Kintone app whose action mapping details are being retrieved. | |
| Id | String | Unique identifier of the action, used to reference or update the specific automation rule. | |
| SrcType | String | Type of source data used by the action's field mapping, indicating whether the action copies from a field or another supported source.
The allowed values are FIELD, RECORD_URL. | |
| SrcField | String | Field code of the source field defined in the field-mapping settings, returned only when the actions.{actionname}.mappings[].srcType value is FIELD. | |
| DestField | String | Field code of the destination field that receives the copied value when the action executes. | |
| Revision | String | Revision number of the app settings, helping track configuration changes to mapping definitions. |
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 mapping details in a specific language. | |
| IsPreview | Boolean | Indicates whether to retrieve mapping details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'. |