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
