TDV Adapter for Office 365

Build 21.0.8137

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137