Endpoint

Update Organization

Name

put_organization

Description

Update an organization by its id [API reference]

Related Tables

Organizations

Parameters

Parameter	Label	Required	Options	Description
id	id	NO

Output Columns

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`

If the column you are looking for is missing, consider customizing Zendesk Connector.

Input Columns

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.

Examples

SSIS

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

Update rows in 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

Update

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Update Organization

UPDATE Organizations
SET  name='Abc Inc'
	,external_id='zcrm_1558554000052161270'
	,group_id=114094762733 
	,tags='["paid","trial","solved"]'
	,details='some details'
	,notes='some notes'
	,organization_fields='{"startdate": "1981-01-23", "revenue": 12000000.50, "somenumber": 1235678}'
	,domain_names='["aaa.com", "bbb.com"]'
	,shared_tickets='false'
	,shared_comments='false'
Where id=21863188631451

put_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:

Update Organization

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Organizations
SET  name=''Abc Inc''
	,external_id=''zcrm_1558554000052161270''
	,group_id=114094762733 
	,tags=''["paid","trial","solved"]''
	,details=''some details''
	,notes=''some notes''
	,organization_fields=''{"startdate": "1981-01-23", "revenue": 12000000.50, "somenumber": 1235678}''
	,domain_names=''["aaa.com", "bbb.com"]''
	,shared_tickets=''false''
	,shared_comments=''false''
Where id=21863188631451';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];

put_organization endpoint belongs to Organizations table(s), and can therefore be used via those table(s).