Zendesk Connector
Documentation
Version: 9
Documentation

EndPoint Delete Organization


Name

delete_organization

Description

Delete an organization by its id [API reference]

Parameters

Parameter Label Required Options Description
id Organization ID for Delete YES

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:

Delete rows from Organizations table using API Destination

This EndPoint belongs to Organizations table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Zendesk
Organizations
Delete
SSIS API Destination - Access table operation