Space

Enables programmatic management of Kintone Spaces, which are workspace areas used for team collaboration, content sharing, and discussion threads.

Select

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

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

SELECT * FROM Space WHERE Id = 7

Insert

INSERT ステートメントでは、SpaceTemplateID、Name、Members カラムが必須です。

INSERT INTO Space(SpaceTemplateID, Name, Members) Values(1, 'New_Space', '[{"entity":{"type":"USER","code":"[email protected]"},"isAdmin":true}]')

Update

Space を更新するには、Id カラムが必須です。

UPDATE Space SET body='Space Body' WHERE Id = 16

Delete

Space を削除するには、Id カラムが必須です。

DELETE FROM Space WHERE Id = 16

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Identifier of the Space, used to reference the workspace throughout the Kintone environment.
Name	String	False		Display name of the Space as shown in the Kintone interface.
DefaultThread	String	False		Identifier of the default thread that was automatically created when the Space was first set up.
IsPrivate	Boolean	False		Indicates whether the Space is private, restricting visibility to explicitly assigned members.
CreatorCode	String	False		Login name of the user who created the Space, returned as an empty string for inactive or deleted users.
CreatorName	String	False		Display name of the user who created the Space, returned as an empty string for inactive or deleted users.
ModifierCode	String	False		Login name of the user who last updated the Space settings, returned as an empty string for inactive or deleted users.
ModifierName	String	False		Display name of the user who last updated the Space settings, returned as an empty string for inactive or deleted users.
MemberCount	String	False		Number of members currently belonging to the Space.
CoverType	String	False		Type of image used for the Space's cover photo, indicating whether it is a preset or an uploaded file.
CoverKey	String	False		Key identifier of the cover photo assigned to the Space.
CoverUrl	String	False		URL pointing to the cover photo used in the Space's header.
Body	String	False		HTML content displayed in the Space body, returned as null when no content is set but may contain preserved tags if content existed previously.
UseMultiThread	Boolean	False		Indicates whether the Space allows multiple discussion threads instead of using a single-thread structure.
IsGuest	Boolean	False		Indicates whether the Space is a Guest Space, which restricts access to designated guest users.
FixedMember	Boolean	False
AttachedApps	String	False		List of apps associated with the Space's thread, excluding apps that are not yet published.
ShowAnnouncement	Boolean	False		Indicates whether the Announcement widget is displayed in the Space.
ShowThreadList	Boolean	False		Indicates whether the Threads widget is displayed in the Space.
ShowAppList	Boolean	False		Indicates whether the Apps widget is displayed in the Space.
ShowMemberList	Boolean	False		Indicates whether the People widget, which shows Space members, is displayed.
ShowRelatedLinkList	Boolean	False		Indicates whether the Related Apps and Spaces widget is displayed in the Space.

Pseudo-Columns

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


Name	Type	Description
SpaceTemplateID	String	Identifier of the Space template used when creating a new Space, required during Space creation.
Members	String	List of users assigned to the Space, required when creating a new Space and must include at least one Space Administrator. Inactive or deleted users cannot be included.