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 component will use the Kintone APIs to filter the results by this column. By default, the component will process other filters client-side within the component.
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. |