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
WHERE 句ではAppId カラムが必須です。connector はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、connector はクライアント側でconnector 内で他のフィルタを処理します。
例えば、次のクエリはサーバー側で処理されます。
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.
使用できる値は次のとおりです。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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description | |
| Lang | String | Locale code used to retrieve mapping 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'. |