Calendars
This table is dynamic and maps to the corresponding field in the API.
Table Specific Information
Select
You can query Calendars by specifying an Id or selecting all:
SELECT * FROM Calendars WHERE Id = 'your Calendar Id goes here'
Select a certain column from the entity and filter by that column:
SELECT id FROM Calendars WHERE name LIKE 'Calendar%'
Insert
Specify a Name as a minimum in order to create a new Calendar:
INSERT INTO Calendars (Name) VALUES ('John')
Note: In case of client credentials, UserId is required in order to create a new Calendar:
INSERT INTO Calendars (Name, UserId) VALUES ('Test123', '92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe');
Columns
| Name | Type | ReadOnly | References | Description |
| id [KEY] | String | True |
This field is dynamic and maps to the corresponding field in the API. | |
| Etag | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| allowedOnlineMeetingProviders | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| canEdit | Bool | False |
This field is dynamic and maps to the corresponding field in the API. | |
| canShare | Bool | False |
This field is dynamic and maps to the corresponding field in the API. | |
| canViewPrivateItems | Bool | False |
This field is dynamic and maps to the corresponding field in the API. | |
| changeKey | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| color | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| defaultOnlineMeetingProvider | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| hexColor | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| isDefaultCalendar | Bool | False |
This field is dynamic and maps to the corresponding field in the API. | |
| isRemovable | Bool | False |
This field is dynamic and maps to the corresponding field in the API. | |
| isTallyingResponses | Bool | False |
This field is dynamic and maps to the corresponding field in the API. | |
| name | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| owner_address | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| owner_name | String | False |
This field is dynamic and maps to the corresponding field in the API. | |
| UserId [KEY] | String | False |
The UserId column for the table Calendars. |