Space

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

Select

The Id column is required in the WHERE clause. The provider will use the Kintone APIs to filter the results by this column. By default, the provider will process other filters client-side within the provider.

For example, the following queries are processed server side:

SELECT * FROM Space WHERE Id = 7

Insert

The SpaceTemplateID, Name, Members columns are required in the INSERT statement.

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

Update

The Id column is required to update the Space.

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

Delete

The Id column is required to delete the Space.

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


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.