EndPoint Read Organizations (All)

Contents

Name

get_organizations

Get a list of all organizations in your account [API reference]

Parameter	Label	Required	Options	Description
PageSize	Records Per Page (Max 100)	NO

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_I8`	`bigint`		False
name	`DT_WSTR`	`nvarchar(500)`	500	False
notes	`DT_WSTR`	`nvarchar(4000)`	4000	False
created_at	`DT_DBTIMESTAMP`	`datetime`		False
details	`DT_WSTR`	`nvarchar(4000)`	4000	False
domain_names	`DT_WSTR`	`nvarchar(144)`	144	False
domain_names_1	`DT_WSTR`	`nvarchar(255)`	255	False
domain_names_2	`DT_WSTR`	`nvarchar(255)`	255	False
domain_names_3	`DT_WSTR`	`nvarchar(255)`	255	False
external_id	`DT_WSTR`	`nvarchar(500)`	500	False
group_id	`DT_I8`	`bigint`		False
shared_comments	`DT_BOOL`	`bit`		False
shared_tickets	`DT_BOOL`	`bit`		False
tags	`DT_WSTR`	`nvarchar(144)`	144	False
tags_1	`DT_WSTR`	`nvarchar(500)`	500	False
tags_2	`DT_WSTR`	`nvarchar(500)`	500	False
tags_3	`DT_WSTR`	`nvarchar(500)`	500	False
tags_4	`DT_WSTR`	`nvarchar(500)`	500	False
tags_5	`DT_WSTR`	`nvarchar(500)`	500	False
updated_at	`DT_DBTIMESTAMP`	`datetime`		False
url	`DT_WSTR`	`nvarchar(500)`	500	False
organization_field_dt_[$parent.key$]	`DT_WSTR`	`nvarchar(4000)`	4000	False
organization_field_[$parent.key$]	`DT_WSTR`	`nvarchar(4000)`	4000	False

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_I8`	`bigint`		False
name	`DT_WSTR`	`nvarchar(500)`	500	False
notes	`DT_WSTR`	`nvarchar(4000)`	4000	False
external_id	`DT_WSTR`	`nvarchar(500)`	500	False
group_id	`DT_I8`	`bigint`		False
details	`DT_WSTR`	`nvarchar(4000)`	4000	False
tags	`DT_WSTR`	`nvarchar(4000)`	4000	True
organization_fields	`DT_WSTR`	`nvarchar(4000)`	4000	True
domain_names	`DT_WSTR`	`nvarchar(1000)`	1000	True
shared_comments	`DT_BOOL`	`bit`		False
shared_tickets	`DT_BOOL`	`bit`		False

Required columns that you need to supply are bolded.