EndPoint

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_departments

Description

No description available

Parameters

Parameter

Label

Required

Options

Description

LastSyncTime

Option	Value
2023-12-31T00:00:00	2023-12-31T00:00:00
now	now
today	today
yesterday	yesterday
yearstart-10y	yearstart-10y
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
monthend+1d-1y	monthend+1d-1y

The date for which to retrieve the report in YYYYMMDD format. Supported functions now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(500)`	500	False
Name	`DT_WSTR`	`nvarchar(500)`	500	False
ModifiedTime	`DT_DBTIMESTAMP`	`datetime`		False
IsEnabled	`DT_WSTR`	`nvarchar(50)`	50	False
CreatedBy	`DT_WSTR`	`nvarchar(500)`	500	False
IsPublic	`DT_WSTR`	`nvarchar(50)`	50	False
ImageUrl	`DT_WSTR`	`nvarchar(1000)`	1000	False
IsSystemGenerated	`DT_WSTR`	`nvarchar(50)`	50	False
CreatedTime	`DT_DBTIMESTAMP`	`datetime`		False
Description	`DT_WSTR`	`nvarchar(1000)`	1000	False
DisplayName	`DT_WSTR`	`nvarchar(500)`	500	False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.