SpaceMembers

Manages the membership lists of Spaces so you can review or update which users have access to a workspace and its discussions.

Select

WHERE 句では、Id カラムが必須です。本製品はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、本製品はクライアント側で本製品内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM SpaceMembers WHERE Id = 1

SpaceMembers を更新するには、Members カラムを集計として指定します。SpaceMembers を更新するには、Id カラムが必須です。

UPDATE SpaceMembers SET Members='[{"entity":{"type":"USER","code":"[email protected]"},"isAdmin":true}]' WHERE Id = 1


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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。


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.