SSIS Components for SharePoint

Build 20.0.7656

Calendar

Create, update, query, and delete items in SharePoint Calendar lists.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID of the calendar entry. The format of the ID is: List|ItemID.

List String False

The name of the calendar list.

Title String False

The title of the entry.

ParticipantsPicker String False

The attendees of the calendar entry.

FreeBusy String False

A flag indicating the free or busy status during the event.

Facilities String False

The resources for this calendar entry.

Location String False

The location of the event.

EventDate Date False

The date the calendar entry starts.

EndDate Date False

The date the calendar entry ends.

Description String False

The description of the event.

Duration String False

The duration of the calendar entry.

EventType String False

The type of the event.

IsAllDayEvent String False

A flag indicating whether the entry is an all day event or not.

fRecurrence String False

A flag indicating whether this is a recurring event.

Author String False

The user that created the item.

Editor String False

The last user that modified the item.

Modified Date False

The date modified.

Created Date False

The date created.

Pseudo-Columns

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

Name Type Description
CAMLQuery String

The query to be used while listing the list items.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656