ActionSettingsMappings
Query the available Action Settings Mappings in kintone.
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 | The App ID of the kintone application. | |
| Id | String | The ID of the Action. | |
| SrcType | String | The type of source data that is to be copied.
The allowed values are FIELD, RECORD_URL. | |
| SrcField | String | The field code of the field specified in the Field Mappings options as the source. This parameter is returned only if the actions.{actionname}.mappings[].srcType parameter is set to FIELD. | |
| DestField | String | The field code of the field specified in the Field Mappings options as the destination. | |
| Revision | String | The revision number of the App settings. |
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 | The localized language to retrieve the data. | |
| IsPreview | Boolean | By setting this to False, you will be able to retrieve the Action Settings details of the live App. Default value is true. |