Reference

Endpoint Delete Attachment

Name

delete_attachment

Description

Delete attachment [API reference]

Parameters

Parameter Required Options
Name: attachment_id

Label: Attachment ID

 YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
attachment_id DT_I8 bigint
If the column you are looking for is missing, consider customizing Zendesk Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Zendesk Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Zendesk
Zendesk Connector can be used to integrate Zendesk REST API in your App / BI Tools. You can read/write data about Tickets, Activity, Users, Organizations and more.
Zendesk
Delete Attachment
Required Parameters
Attachment ID Fill-in the parameter...
Optional Parameters
EnableArrayFlattening True
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Zendesk
Zendesk Connector can be used to integrate Zendesk REST API in your App / BI Tools. You can read/write data about Tickets, Activity, Users, Organizations and more.
Zendesk
Delete Attachment
Required Parameters
Attachment ID Fill-in the parameter...
Optional Parameters
EnableArrayFlattening True
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Delete attachment 

SELECT * FROM delete_attachment
WITH
(
    "attachment_id" = 'abcd-1234-attachment_id'
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Delete attachment 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_attachment
WITH
(
    "attachment_id" = ''abcd-1234-attachment_id''
)';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];