Zendesk Connector
Documentation
Version: 9
Documentation

EndPoint Read Organizations (All)


Name

get_organizations

Description

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

Parameters

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

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
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

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
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.

Examples

SSIS

Use Zendesk Connector in API Source component to read data or in API Destination component to read/write data:

Read Organizations (All) using API Source

Zendesk
Read Organizations (All)
SSIS API Source - Read from table or endpoint

Read Organizations (All) using API Destination

Zendesk
Read Organizations (All)
SSIS API Destination - Access table or endpoint