FieldPermissions
Update and Query the available FieldPermissions 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 FieldPermissions WHERE AppId = 6 SELECT * FROM FieldPermissions WHERE AppId = 6 AND IsPreview = false
Update
For updating the FieldPermissions, provide the Rights as an aggregate. The AppId and IsPreview columns are required to update the FieldPermissions.
UPDATE FieldPermissions SET Rights = 'Update FieldPermissions set Rights='[{"code":"Updated_by","entities":[{"accessibility":"READ","entity":{"type":"GROUP","code":"everyone"}}]}]' WHERE AppId = 6 AND IsPreview = true
Columns
| Name | Type | ReadOnly | References | Description |
| AppId [KEY] | Integer | False |
The App ID of the kintone application. | |
| Code [KEY] | String | False |
The field code of a field that has permission settings. | |
| Entities | String | False |
An array listing the entities the permissions are granted to, in order of priority. | |
| 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 FieldPermissions details of the live App. Default value is true. |
| Rights | String |
Only used for performing Update. |