EndPoint Create event
Name
create_event
Description
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
CalendarId | CalendarId | YES |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_WSTR
|
nvarchar(50)
|
50 | False | |
Status |
DT_WSTR
|
nvarchar(50)
|
50 | False | |
Created |
DT_DBTIMESTAMP
|
datetime
|
False | ||
Updated |
DT_DBTIMESTAMP
|
datetime
|
False | ||
HtmlLink |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
iCalUID |
DT_WSTR
|
nvarchar(1024)
|
1024 | False | |
eventType |
DT_WSTR
|
nvarchar(128)
|
128 | False |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
StartsOn |
DT_DBDATE
|
date
|
False | Use StartsOn OR StartsAt | |
StartsAt |
DT_DBTIMESTAMP
|
datetime
|
False | Use StartsOn OR StartsAt | |
StartsInTimeZone |
DT_WSTR
|
nvarchar(300)
|
300 | False | |
EndsOn |
DT_DBDATE
|
date
|
False | ||
EndsAt |
DT_DBTIMESTAMP
|
datetime
|
False | ||
EndsInTimeZone |
DT_WSTR
|
nvarchar(300)
|
300 | False | |
Kind |
DT_WSTR
|
nvarchar(300)
|
300 | False | |
Attendees |
DT_NTEXT
|
nvarchar(MAX)
|
False | ||
Description |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
GuestsCanInviteOthers |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
GuestsCanModify |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
GuestsCanSeeOtherGuests |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Location |
DT_WSTR
|
nvarchar(1024)
|
1024 | False | |
Recurrence |
DT_WSTR
|
nvarchar(1024)
|
1024 | False | |
Status |
DT_WSTR
|
nvarchar(50)
|
50 | False | |
Summary |
DT_WSTR
|
nvarchar(300)
|
300 | False | |
Transparency |
DT_WSTR
|
nvarchar(300)
|
300 | False | |
Visibility |
DT_WSTR
|
nvarchar(300)
|
300 | False |
Required columns that you need to supply are bolded.