SpaceMembers
Manages the membership lists of Spaces so you can review or update which users have access to a workspace and its discussions.
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 |
Identifier of the Space whose membership details are being retrieved or updated. | |
| EntityCode | String | False |
Code identifying the user, group, or department that is a member of the Space. | |
| EntityType | String | False |
Type of entity assigned to the Space, such as a user, group, or department. | |
| IsAdmin | Boolean | False |
Indicates whether the member has Space Administrator privileges, allowing them to manage Space settings and membership. | |
| IsImplicit | Boolean | False |
Indicates whether the member was added implicitly through group or department membership rather than being added individually. | |
| IncludeSubs | Boolean | False |
Indicates whether membership granted to a department also applies to its subordinate departments. |
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 |
List of members to assign when creating a new Space, requiring at least one Space Administrator and excluding inactive or deleted users. |