Create Organization
Name
post_organization
Description
Create an organization [API reference]
Related Tables
Parameters
Parameter | Label | Required | Options | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are no parameters |
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 |
Examples
SSIS
Use Zendesk Connector in API Source component to read data or in API Destination component to read/write data:
Insert into 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:

ODBC application
Use these SQL queries in your ODBC application data source:
Create Organization
Create a new organization for specified email id and other information. If organization with same email exists then call fails.
INSERT INTO Organizations
(
name
,external_id
,group_id
,tags
,details
,notes
,organization_fields
,domain_names
,shared_tickets
,shared_comments
)
VALUES(
'Abc Inc'
,'zcrm_1558554000052161270' --external_id
,114094762733
,'["paid","trial","solved"]'
,'some details'
,'some notes'
,'{"startdate": "1981-01-23", "revenue": 12000000.50, "somenumber": 1235678}'
,'["aaa.com", "bbb.com"]'
,'false'
,'false'
)
post_organization
endpoint belongs to
Organizations
table(s), and can therefore be used via those table(s).
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Create Organization
Create a new organization for specified email id and other information. If organization with same email exists then call fails.
DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Organizations
(
name
,external_id
,group_id
,tags
,details
,notes
,organization_fields
,domain_names
,shared_tickets
,shared_comments
)
VALUES(
''Abc Inc''
,''zcrm_1558554000052161270'' --external_id
,114094762733
,''["paid","trial","solved"]''
,''some details''
,''some notes''
,''{"startdate": "1981-01-23", "revenue": 12000000.50, "somenumber": 1235678}''
,''["aaa.com", "bbb.com"]''
,''false''
,''false''
)';
EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];
post_organization
endpoint belongs to
Organizations
table(s), and can therefore be used via those table(s).