Spaces
Returns information about a number of spaces.
Table-Specific Information
Select
The connector uses the Confluence API to process WHERE clause conditions built with the following columns and operators.
- Key and Type support the =, !=, IN, NOT IN operators.
- Name supports the = operator.
- CreatedDate supports the =, >, >=, <, <= operators.
The rest of the filter is executed client-side within the connector. You can also search for Spaces using CQL (Confluence Query Language).
For example, the following queries are processed server-side:
SQL
SELECT * FROM Spaces WHERE Key = 'abc'
SELECT * FROM Spaces WHERE Name IN ('name1', 'name2')
SELECT * FROM Spaces WHERE Key = 'abc' AND Type = 'global'
CQL
Note: Filtering with CQL has the highest priority and all other filters except "Excerpt" are ignored when a CQL filter is present in the query.
SELECT * FROM Spaces WHERE CQL = 'type = space AND space.title~"Driver Development"' AND Excerpt = 'indexed'
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Description |
| Id | String | True |
Id of the space. | ||
| Key [KEY] | String | False | =,!=,IN,NOT_IN |
Unique key of the space. | |
| Name | String | False | =,!= |
Name of the space. | |
| IconPath | String | True |
Path of the space icon. | ||
| IconWidth | Integer | True |
Width of the space icon. | ||
| IconHeight | Integer | True |
Height of the space icon. | ||
| IsIconDefault | Boolean | True |
Indicator if the icon is default. | ||
| Excerpt | String | True |
Excerpt of the space. | ||
| Type | String | False | =,!=,IN,NOT_IN |
Type of the space. | |
| Url | String | True |
Url of the space. | ||
| LastModified | Datetime | True |
Last modified datetime. | ||
| ItemURL | String | True |
The URL reference of the element in UI. | ||
| Description | String | False |
Description of the space. | ||
| CreatedDate | Datetime | True | =,>,>=,<,<= |
Datetime for the creation of the content. | |
| Alias | String | False |
Identifier for the space in confluence page URLs. | ||
| Status | String | False |
Status of the space. |
Pseudocolumns
Pseudocolumn 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 |
| CQL | String |
CQL (Confluence Query Language) allows you to build structured queries. |