SpaceMembers
Update and Query the available Space Members in kintone.
Select
The Id column is required in the WHERE clause. The add-in will use the Kintone APIs to filter the results by this column. By default, the add-in will process other filters client-side within the add-in.
For example, the following queries are processed server side:
SELECT * FROM SpaceMembers WHERE Id = 1
Update
For updating the SpaceMembers, provide the Members column as an aggregate. The Id column is required to update the SpaceMembers.
UPDATE SpaceMembers SET Members='[{"entity":{"type":"USER","code":"[email protected]"},"isAdmin":true}]' WHERE Id = 1
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The Space ID. | |
| EntityCode | String | False |
The code of the Space member. | |
| EntityType | String | False |
The entity type of the Space member. | |
| IsAdmin | Boolean | False |
The Space Admin settings of the Space member. | |
| IsImplicit | Boolean | False |
If the Space Member is added as a User or not. | |
| IncludeSubs | Boolean | False |
The Include Affiliated Departments setting of the Department Space Member. |
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 |
| Members | String |
A list of members of the Space. It is required while creating a new Space. At least one Space Administrator must be specified. Inactive and deleted users cannot be specified. |