SpaceMembers
Update and Query the available Space Members in kintone.
Select
The Id 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 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. |