AppPermissions
Update and Query the App Permissions 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 AppPermissions WHERE AppId = 6 SELECT * FROM AppPermissions WHERE AppId = 6 AND IsPreview = false
Update
For updating the AppPermissions, provide the Rights as an aggregate. The AppId and IsPreview columns are required to update the AppPermissions.
UPDATE AppPermissions SET Rights = '[{"entity":{"type":"CREATOR"},"appEditable":true,"recordViewable":true,"recordAddable":true,"recordEditable":true,"recordDeletable":true,"recordImportable":true,"recordExportable":true}]' WHERE AppId = 6 AND IsPreview = true
Columns
| Name | Type | ReadOnly | References | Description |
| AppId [KEY] | Integer | False |
The App ID of the kintone application. | |
| EntityType [KEY] | String | False |
The type of the entity the permission is granted to. | |
| EntityCode | String | False |
The code of the entity the permission is granted to. | |
| IncludeSubs | Boolean | False |
The permission inheritance settings of the department the permission is granted to. | |
| AppEditable | Boolean | False |
The App management permission of the entity. Entities with this permission are able to access and edit the App's settings. | |
| RecordViewable | Boolean | False |
The record view permission of the entity. | |
| RecordAddable | Boolean | False |
The record add permission of the entity. | |
| RecordEditable | Boolean | False |
The record edit permission of the entity. | |
| RecordDeletable | Boolean | False |
The record delete permission of the entity. | |
| RecordImportable | Boolean | False |
The file import permission of the entity. | |
| RecordExportable | Boolean | False |
The file export permission of the entity. | |
| Revision | String | True |
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 |
| IsPreview | Boolean |
By setting this to False, you will be able to retrieve the App Permissions details of the live App. Default value is true. |
| Rights | String |
Only used for performing Update. |